Krishan Kumarpodiumofcode.hashnode.dev·May 3, 2024Prisma with PostgreSQL"Ever wondered about a world where complex SQL queries are no longer needed to interact with databases? Enter Prisma. With Prisma, creating tables and adding references becomes a breeze. Say goodbye to tedious SQL syntax and hello to streamlined data...Discuss·1 like·33 readsprisma
Emiliogetemilio.hashnode.dev·Feb 24, 2024Connect to an AWS RDS PostgreSQL database using PSQLHere at Emilio we decided to go for Postgres. I will assume you already have a Postgres instance in AWS RDS. I will create an article on how to do this and link it here when I have it ready. Get the endpoint and port of your database Go to https://c...DiscussPostgreSQL
Alexis Kofmankompile.io·Feb 4, 2024psql + Zellij = ❤️Étant souvent amené à utiliser Postgres comme gestionnaire de base de données, je n'ai jamais vraiment eu de préférence pour un client en particulier. J'ai utilisé PgAdmin, DBeaver, Datagrid, divers plugins dans VSCode et j'ai toujours eu l'impressio...Discuss·1 like·115 readsPostgreSQL
Negarkhajeddin.hashnode.dev·Jan 23, 2024PostgreSQL BasicsInstall PostgreSQL on your system. you can find the installers for various platforms in this link. Difference between PSQL and SQL commands First of all, lets differentiate between PostgreSQL and SQL commands: Any command starting with backslash \ i...DiscussPostgreSQL
Sebinsebzz.hashnode.dev·Nov 18, 2023API optimization using SQL PaginationPagination, the process of dividing a large set of query results into manageable chunks or pages, is a crucial technique in web development and database management. Particularly useful when dealing with large datasets, pagination ensures that loading...Discuss·6 likesSQL
Sebinsebzz.hashnode.dev·Oct 31, 2023API optimization using SQL (n+1) optimizationIn the ever-evolving world of technology, speed and efficiency are key pillars in providing a seamless user experience. When it comes to processing time-series data through an Express endpoint, the initial setup can be the difference between lightnin...DiscussSQL
Ramkumar Sramkumarsanadi.hashnode.dev·Aug 31, 2023Relationships in PostgreSQL: A Comprehensive Guide - Day -5 of Postgres Learning JourneyPostgreSQL, a robust relational database management system, empowers developers with the ability to establish and manage relationships between tables. In this comprehensive guide, we will delve into the intricate world of relations within PostgreSQL,...DiscussLearn PostgresSQL with me {PSQL}SQL
Ramkumar Sramkumarsanadi.hashnode.dev·Aug 29, 2023A Comprehensive Guide to PostgreSQL Constraints - Day -9 of Postgres Learning JourneyWhen it comes to managing data integrity in a relational database system like PostgreSQL, constraints play a crucial role. Constraints ensure that the data stored in the database follows specific rules and conditions, maintaining the accuracy and rel...DiscussLearn PostgresSQL with me {PSQL}psql
Ramkumar Sramkumarsanadi.hashnode.dev·Aug 28, 2023Working with Dates in PostgreSQL: A Comprehensive Guide - Day -8 of Postgres Learning JourneyWhen working with databases, handling dates is a crucial aspect of data management. PostgreSQL (often referred to as PSQL) is a powerful open-source relational database management system that provides robust support for handling date and time data. I...DiscussPostgreSQL
Ramkumar Sramkumarsanadi.hashnode.dev·Aug 25, 2023A Comprehensive Guide to Handling Null Values in PostgreSQLNull values, often referred to as "nulls," are a common aspect of database management systems like PostgreSQL. Nulls represent missing or unknown information in a database table and can pose challenges when querying and manipulating data. In this blo...Discuss·29 readsPostgreSQL