--- title: Best PostgreSQL posts of 2023 | daily.dev description: The most upvoted PostgreSQL posts of 2023, curated by the daily.dev community. canonical: https://daily.dev/tags/postgresql/best-of/2023 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/postgresql/best-of/2023 og:type: website og:site_name: daily.dev og:title: Best PostgreSQL posts of 2023 | daily.dev og:description: The most upvoted PostgreSQL posts of 2023, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of PostgreSQL — 2023 1. 1 [](/posts/javascript-crud-rest-api-using-nodejs-express-sequelize-postgres-docker-and-docker-compose-t39iklytu "JavaScript CRUD Rest API using Nodejs, Express, Sequelize, Postgres, Docker and Docker Compose") Article Community Picks · 4y JavaScript CRUD Rest API using Nodejs, Express, Sequelize, Postgres, Docker and Docker Compose Learn how to create a CRUD rest API using Node.js, Express, Sequelize, Postgres, Docker, and Docker Compose. Dockerize the Node.js application and test the APIs with Postman. 141 49 2. 2 [](/posts/postgres-vs-mysql-a-complete-comparison-qivjokwec "Postgres vs. MySQL: a Complete Comparison") Article DZone · 3y Postgres vs. MySQL: a Complete Comparison Postgres has taken over the first place spot from MySQL and become the most admired, desired database. As Postgres gains momentum, choosing between them is still hard and often causes heated debate. Postgres is still the world's most popular open-source database by install base. 140 6 3. 3 [](/posts/full-stack-webpageform-builder-nextjs-typescript-react-dnd-kit-postgresql-prisma-ikdzvk5w7 "Full stack WebPageForm builder, NextJs, Typescript ( React ), Dnd-Kit, PostgreSQL, Prisma") Article ITNEXT · 3y Full stack WebPageForm builder, NextJs, Typescript ( React ), Dnd-Kit, PostgreSQL, Prisma A tutorial on building a full stack PageForm builder using NextJs, TypeScript, Dnd-Kit, PostgreSQL, and Prisma. The tutorial includes features such as a drag and drop designer, various form fields, form preview, form sharing, form stats, and more. 118 10 4. 4 [](/posts/typescript-crud-api-next-js-tailwind-trpc-prisma-postgres-docker-5yhkwb7la "Typescript CRUD API: Next.js, Tailwind, tRPC, Prisma Postgres, Docker") Article Community Picks · 3y Typescript CRUD API: Next.js, Tailwind, tRPC, Prisma Postgres, Docker Learn how to build a FULL CRUD API app, including a simple frontend to use it, using the following technologies: Next.js, Tailwind, tRPC, Prisma Postgres, Docker. All the code is available for free on GitHub(link in video description) Learn how to code your own blockchain and create your own crypto-currency with the CoinCamp. 113 7 5. 5 [](/posts/the-complete-modern-react-developer-2022-sydkka2ae "The Complete Modern React Developer 2022") Article Community Picks · 3y The Complete Modern React Developer 2022 Course covering the full stack development using React, Node.js, MongoDB, and PostgreSQL. Backend setup using Express.js or Nest.js. Includes tutorials for setting up local databases and using Docker. Frontend tests using React Testing Library and Cypress. 111 2 6. 6 [](/posts/build-a-full-stack-app-with-rust-next-js-and-docker-dvpnrbv0i "Build a full stack app with Rust, Next.js and Docker") Article Community Picks · 3y Build a full stack app with Rust, Next.js and Docker Learn how to build a full stack app with Rust, Next.js, and Docker. The app uses Next.js 14 with TypeScript and Tailwind CSS for the frontend, Rust without any framework for the backend, and PostgreSQL for the database. Docker and Docker Compose are used to containerize and run the app. The article provides step-by-step instructions on setting up the database, backend, and frontend, as well as testing the app using Postman. 91 7. 7 [](/posts/typescript-crud-rest-api-using-nest-js-typeorm-postgres-docker-and-docker-compose-pymr3gdsu "TypeScript CRUD Rest API, using Nest.js, TypeORM, Postgres, Docker and Docker Compose") Article Community Picks · 4y TypeScript CRUD Rest API, using Nest.js, TypeORM, Postgres, Docker and Docker Compose Learn how to create a CRUD Rest API in Typescript using NestJS, TypeORM, Postgres, Docker, and Docker Compose. 86 10 8. 8 [](/posts/postgresql-course-for-beginners-pajandxjk "PostgreSQL Course for Beginners") Article freeCodeCamp · 3y PostgreSQL Course for Beginners A comprehensive PostgreSQL course is available on the freeCodeCamp.org YouTube channel. It covers PostgreSQL introduction, installation, SELECT statement, WHERE clauses, advanced query structures, aggregate functions, and more. Suitable for developers, aspiring Database Administrators, computer science students, and tech enthusiasts. 79 2 9. 9 [](/posts/full-stack-project-tutorial-create-a-recipe-app-using-react-node-js-and-postgresql-gnoxm22hn "Full Stack Project Tutorial – Create a Recipe App Using React, Node.js and PostgreSQL") Article freeCodeCamp · 3y Full Stack Project Tutorial – Create a Recipe App Using React, Node.js and PostgreSQL In this in-depth tutorial, we'll build a full stack recipe app from scratch, using React, Node.js, Postgres and the Spoonacular API. We'll cover features such as: Building an API server in Node - Integrating securely with a 3rd party API - Interacting with a Postgres database using Prisma. 78 1 10. 10 [](/posts/rust-crud-rest-api-with-docker--gm5hdx7xl "Rust 🦀 CRUD Rest API with Docker 🐳") Article Community Picks · 3y Rust 🦀 CRUD Rest API with Docker 🐳 Learn how to create a CRUD Rest API in Rust using Serde for JSON serialization and deserialization, Postgres for the database, and Docker for containerization. 75 10 11. 11 [](/posts/all-your-servers-accessible-directly-and-securely-from-your-browser-xmwzaxkea "All your servers accessible directly and securely from your Browser") Article AWS in Plain English · 3y All your servers accessible directly and securely from your Browser All your servers are accessible directly and securely from your Browser. Border0 client portal is a beautiful and efficient web interface that allows your users to quickly and easily discover all servers they have access to. The dashboard features app cards for each service, with easily distinguishable icons and details. 74 2 12. 12 [](/posts/mysql-vs-postgresql-in-2023--yustl36rk "MySQL vs PostgreSQL in 2023.") Article DBconvert · 4y MySQL vs PostgreSQL in 2023. PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for decades. They each have different strengths and weaknesses that make one more suitable for certain use cases than the other. This article will compare them to aid in making an informed decision in 2023. 73 7 13. 13 [](/posts/upsert-in-sql-pwuw73xan "Upsert in SQL") Article Pointer · 3y Upsert in SQL This article discusses the concept of upsert in SQL and explains how it works in different database management systems (DBMS) like MySQL, SQLite, and PostgreSQL. It provides examples and code snippets for each DBMS to demonstrate the various ways to perform upsert operations. 70 14. 14 [](/posts/sql-versus-nosql-databases-which-to-use-when-and-why-im6siz5et "SQL Versus NoSQL Databases: Which to Use, When, and Why") Article Amplication · 3y SQL Versus NoSQL Databases: Which to Use, When, and Why The right choice means we can scale up an application quickly and handle increasing user requests without encountering problems. Choosing the right database for your application is no mean feat, given the number of available databases. There are many differences between SQL and NoSQL databases, such as how they handle relational data, their query languages. 67 6 15. 15 [](/posts/postgresql-is-taking-the-lead-ry3fieiuw "PostgreSQL is taking the lead") Article EverSQL · 3y PostgreSQL is taking the lead PostgreSQL is taking the lead from other relational databases such as MySQL. Postgres is gaining popularity among startups and large enterprises. Cloud vendors are going in a PostgreSQL-first approach, with cloud vendors creating customized databases based on PostgreSQL. PostgreSQL has an internal engine that can be trusted to build other technologies. 61 5 16. 16 [](/posts/all-your-ssh-and-database-servers-accessible-directly-from-your-browser-rifghnnol "All your ssh and database servers accessible directly from your Browser") Article DEV · 3y All your ssh and database servers accessible directly from your Browser New Border0 client portal allows users to quickly and easily discover all servers they have access to. The dashboard features app cards for each service, with easily distinguishable icons and details. We offer both a card and a list view and the choice between dark or light mode. The search box at the top of the screen supports fuzzy search capabilities. 60 3 17. 17 [](/posts/vector-databases-explained-bpqzaiwf5 "Vector Databases 🧫 Explained") Article Unzip · 3y Vector Databases 🧫 Explained vector databases use algorithms like ANN(Approximate Nearest Neighbors) so they can facilitate efficient storage, retrieval, and similarity search operations. These databases excel at handling structured data with a fixed schema. But they often struggle with unstructured or high-dimensional data, such as images, audio, and text. 58 5 18. 18 [](/posts/sql-chat---chatgpt-powered-sql-client-for-postgres-mysql-sql-server-se0mgvjhn "SQL Chat - ChatGPT powered SQL client for Postgres, MySQL & SQL Server") Article Product Hunt · 3y SQL Chat - ChatGPT powered SQL client for Postgres, MySQL & SQL Server SQL Chat - ChatGPT powered SQL client for Postgres, MySQL & SQL Server. Launch archive Most loved launches by the community Newsletter The best of Product Hunt, everyday Popular products in... 57 2 19. 19 [](/posts/modern-api-design-with-golang-postgresql-and-docker-gmtpgcbws "Modern API design with Golang, PostgreSQL and Docker") Article Community Picks · 4y Modern API design with Golang, PostgreSQL and Docker Go is a powerful language that's highly performant and has concurrency built in the language itself making it perfect for micro services. This article is aimed at anyone who wants to build a CRUD micro service or a simple RESTful API using Go (or Golang for SEO purposes) You can find all the code in my repository. 55 2 20. 20 [](/posts/the-open-source-alternative-to-vercel-storage-bwa17srmc "The open-source alternative to Vercel Storage") Article Community Picks · 3y The open-source alternative to Vercel Storage Learn how to use WunderGraph as an open-source alternative to Vercel Storage for Serverless Postgres, Redis, and Blob Storage. 53 6 21. 21 [](/posts/detailed-introduction-to-prisma-orm-nwt7a3jff "Detailed Introduction To Prisma ORM") Article Community Picks · 3y Detailed Introduction To Prisma ORM Prisma is an open-source object-relational mapper (ORM) tool for Node.js and TypeScript. In Prisma, you define your models as classes that map to tables in a database. Models are entities that represent data in your database. 51 22. 22 [](/posts/go-typescript-full-stack-web-app-with-nextjs-postgresql-and-docker-apgh1wm6w "Go + TypeScript full stack web app, with nextjs, PostgreSQL and Docker") Article Community Picks · 3y Go + TypeScript full stack web app, with nextjs, PostgreSQL and Docker Learn how to create a full stack web app using Go and TypeScript in this article. The app uses Next.js, Tailwind CSS, Go, PostgreSQL, and Docker. It provides step-by-step instructions for setting up the backend, creating a database with Docker, and building the frontend. You can find the full code on GitHub. 50 23. 23 [](/posts/the-sql-handbook-a-free-course-for-web-developers-mtr8xhzl3 "The SQL Handbook – A Free Course for Web Developers") Article freeCodeCamp · 3y The SQL Handbook – A Free Course for Web Developers The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel. 44 1 24. 24 [](/posts/full-stack-project-tutorial-create-a-notes-app-using-react-and-node-js-v2qr5mzr2 "Full Stack Project Tutorial – Create A Notes App Using React and Node.js") Article freeCodeCamp · 3y Full Stack Project Tutorial – Create A Notes App Using React and Node.js Learn how to create a full stack notes app using React and Node.js. The tutorial covers building the UI, connecting it to the backend, and adding features like validation and error handling. By the end of the tutorial, readers will have a functional notes app that they can use as a starting point for their own projects. 42 25. 25 [](/posts/php-crud-rest-api-using-laravel-composer-postgres-docker-and-docker-compose-z3kno7zgb "PHP CRUD Rest API, using Laravel, Composer, Postgres, Docker and Docker Compose") Article Community Picks · 3y PHP CRUD Rest API, using Laravel, Composer, Postgres, Docker and Docker Compose Learn how to create a CRUD Rest API in PHP using Laravel, Composer, Postgres, Docker, and Docker Compose. Covers prerequisites, project creation, and step-by-step coding instructions. 42 6 [See all PostgreSQL archives](/tags/postgresql/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/postgresql/best-of/2023#page","url":"https://daily.dev/tags/postgresql/best-of/2023","name":"Best PostgreSQL Posts of 2023","description":"The most upvoted PostgreSQL posts of 2023, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/postgresql/best-of/2023#items","numberOfItems":25,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/javascript-crud-rest-api-using-nodejs-express-sequelize-postgres-docker-and-docker-compose-t39iklytu","name":"JavaScript CRUD Rest API using Nodejs, Express, Sequelize, Postgres, Docker and Docker Compose"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/postgres-vs-mysql-a-complete-comparison-qivjokwec","name":"Postgres vs. MySQL: a Complete Comparison"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/full-stack-webpageform-builder-nextjs-typescript-react-dnd-kit-postgresql-prisma-ikdzvk5w7","name":"Full stack WebPageForm builder, NextJs, Typescript ( React ), Dnd-Kit, PostgreSQL, Prisma"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/typescript-crud-api-next-js-tailwind-trpc-prisma-postgres-docker-5yhkwb7la","name":"Typescript CRUD API: Next.js, Tailwind, tRPC, Prisma Postgres, Docker"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/the-complete-modern-react-developer-2022-sydkka2ae","name":"The Complete Modern React Developer 2022"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/build-a-full-stack-app-with-rust-next-js-and-docker-dvpnrbv0i","name":"Build a full stack app with Rust, Next.js and Docker"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/typescript-crud-rest-api-using-nest-js-typeorm-postgres-docker-and-docker-compose-pymr3gdsu","name":"TypeScript CRUD Rest API, using Nest.js, TypeORM, Postgres, Docker and Docker Compose"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/postgresql-course-for-beginners-pajandxjk","name":"PostgreSQL Course for Beginners"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/full-stack-project-tutorial-create-a-recipe-app-using-react-node-js-and-postgresql-gnoxm22hn","name":"Full Stack Project Tutorial – Create a Recipe App Using React, Node.js and PostgreSQL"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/rust-crud-rest-api-with-docker--gm5hdx7xl","name":"Rust 🦀 CRUD Rest API with Docker 🐳"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/all-your-servers-accessible-directly-and-securely-from-your-browser-xmwzaxkea","name":"All your servers accessible directly and securely from your Browser"},{"@type":"ListItem","position":12,"url":"https://daily.dev/posts/mysql-vs-postgresql-in-2023--yustl36rk","name":"MySQL vs PostgreSQL in 2023."},{"@type":"ListItem","position":13,"url":"https://daily.dev/posts/upsert-in-sql-pwuw73xan","name":"Upsert in SQL"},{"@type":"ListItem","position":14,"url":"https://daily.dev/posts/sql-versus-nosql-databases-which-to-use-when-and-why-im6siz5et","name":"SQL Versus NoSQL Databases: Which to Use, When, and Why"},{"@type":"ListItem","position":15,"url":"https://daily.dev/posts/postgresql-is-taking-the-lead-ry3fieiuw","name":"PostgreSQL is taking the lead"},{"@type":"ListItem","position":16,"url":"https://daily.dev/posts/all-your-ssh-and-database-servers-accessible-directly-from-your-browser-rifghnnol","name":"All your ssh and database servers accessible directly from your Browser"},{"@type":"ListItem","position":17,"url":"https://daily.dev/posts/vector-databases-explained-bpqzaiwf5","name":"Vector Databases 🧫 Explained"},{"@type":"ListItem","position":18,"url":"https://daily.dev/posts/sql-chat---chatgpt-powered-sql-client-for-postgres-mysql-sql-server-se0mgvjhn","name":"SQL Chat - ChatGPT powered SQL client for Postgres, MySQL & SQL Server"},{"@type":"ListItem","position":19,"url":"https://daily.dev/posts/modern-api-design-with-golang-postgresql-and-docker-gmtpgcbws","name":"Modern API design with Golang, PostgreSQL and Docker"},{"@type":"ListItem","position":20,"url":"https://daily.dev/posts/the-open-source-alternative-to-vercel-storage-bwa17srmc","name":"The open-source alternative to Vercel Storage"},{"@type":"ListItem","position":21,"url":"https://daily.dev/posts/detailed-introduction-to-prisma-orm-nwt7a3jff","name":"Detailed Introduction To Prisma ORM"},{"@type":"ListItem","position":22,"url":"https://daily.dev/posts/go-typescript-full-stack-web-app-with-nextjs-postgresql-and-docker-apgh1wm6w","name":"Go + TypeScript full stack web app, with nextjs, PostgreSQL and Docker"},{"@type":"ListItem","position":23,"url":"https://daily.dev/posts/the-sql-handbook-a-free-course-for-web-developers-mtr8xhzl3","name":"The SQL Handbook – A Free Course for Web Developers"},{"@type":"ListItem","position":24,"url":"https://daily.dev/posts/full-stack-project-tutorial-create-a-notes-app-using-react-and-node-js-v2qr5mzr2","name":"Full Stack Project Tutorial – Create A Notes App Using React and Node.js"},{"@type":"ListItem","position":25,"url":"https://daily.dev/posts/php-crud-rest-api-using-laravel-composer-postgres-docker-and-docker-compose-z3kno7zgb","name":"PHP CRUD Rest API, using Laravel, Composer, Postgres, Docker and Docker Compose"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"PostgreSQL","item":"https://daily.dev/tags/postgresql"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/postgresql/best-of"},{"@type":"ListItem","position":5,"name":"2023"}]}]} ```