<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/tags/postgresql/best-of/2024/10" -->

---
title: Best PostgreSQL posts — October 2024 | daily.dev
description: The most upvoted PostgreSQL posts from October 2024, curated by the daily.dev community.
canonical: https://daily.dev/tags/postgresql/best-of/2024/10
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:url: https://daily.dev/tags/postgresql/best-of/2024/10
og:type: website
og:site_name: daily.dev
og:title: Best PostgreSQL posts — October 2024 | daily.dev
og:description: The most upvoted PostgreSQL posts from October 2024, 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 — October 2024

1. 1  
[](/posts/databases-in-depth-complete-course-od3twuyvn "Databases In-Depth – Complete Course")  
collection  
Oct 09, 2024  
### Databases In-Depth – Complete Course  
A comprehensive course on database architecture and optimization, designed by Keerti Purswani and available on freeCodeCamp.org's YouTube channel. It covers transaction management, storage engines, advanced indexing techniques, an in-depth look at SQLite, and understanding MongoDB and PostgreSQL. Suitable for both beginners and experienced engineers, the course aims to equip learners with the skills to manage and optimize data systems efficiently.

+5  
![Post Cover image](https://i.ytimg.com/vi/pPqazMTzNOM/sddefault.jpg)  
236  
2
2. 2  
[](/posts/how-to-create-database-documentation-using-dbdocs-with-dbml-ugupat89v "How to Create Database Documentation Using dbdocs with DBML")  
[![freecodecamp's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1628412854/logos/freecodecamp)](/tags/[tag]/best-of/[year]/[month])  
3m read time • Oct 14, 2024  
### How to Create Database Documentation Using dbdocs with DBML  
Database documentation is crucial for maintaining and scaling systems. This guide demonstrates creating database documentation using DBML and dbdocs. The step-by-step process includes installing the necessary CLI tools, exporting a database schema to DBML, editing the DBML file, and generating documentation with dbdocs. Benefits include simplicity, automation, collaboration, version control, and visualization.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/e4a9117fd6d060533ec650db67bdb2a1?_a=AQAEuiZ)  
98
3. 3  
[](/posts/go-and-postgres-listen-notify-or-how-i-learned-to-stop-worrying-and-love-pubsub-luqrvckbc "Go and Postgres Listen/Notify or: How I Learned to Stop Worrying and Love PubSub")  
[![awego's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/awego)](/tags/[tag]/best-of/[year]/[month])  
9m read time • Oct 24, 2024  
### Go and Postgres Listen/Notify or: How I Learned to Stop Worrying and Love PubSub  
This post explains how to implement PubSub functionality using PostgreSQL's Listen/Notify feature in Golang applications. Unlike traditional PubSub systems that rely on message brokers like Redis, PostgreSQL's Listen/Notify allows for an efficient, single-system solution. The author discusses the use of pgx for connection management, introduces a custom Notifier package, and provides code examples illustrating how to set up a listener, notifier, and subscription system efficiently. Key points include handling notifications, managing subscriptions, and dealing with blocking calls.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/1dc3f4c6f8448fd9f8f3e8438c9a3301?_a=AQAEuiZ)  
82  
1
4. 4  
[](/posts/writing-raw-sql-easier-with-pgx-and-sqlc-in-go-4kw3hpmr3 "Writing raw SQL easier with pgx and sqlc in Go")  
[![awego's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/awego)](/tags/[tag]/best-of/[year]/[month])  
6m read time • Oct 03, 2024  
### Writing raw SQL easier with pgx and sqlc in Go  
Combine pgx, a PostgreSQL driver and toolkit for Golang, with sqlc, a tool that generates type-safe Go code from SQL queries, to streamline database interactions. While ORMs can be limiting for complex queries, pgx and sqlc offer more control and type safety. Using sqlc for CRUD operations and simple queries, and pgx for more complex queries, provides a balanced approach. The post outlines how to set up and use these tools in a Go project.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/71840f0720b2c9340ebf7d820305e945?_a=AQAEuiZ)  
56  
1
5. 5  
[](/posts/building-a-full-stack-portfolio-website-with-a-rag-powered-chatbot-dv75wy5rf "Building a Full-Stack Portfolio Website with a RAG Powered Chatbot")  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
12m read time • Oct 20, 2024  
### Building a Full-Stack Portfolio Website with a RAG Powered Chatbot  
Develop a portfolio website using React and FastAPI, featuring a chatbot powered by pgvector, Neon Postgres, and OpenAI embeddings. This guide walks you through setting up the backend, database, API endpoints, and front end, and optionally containerizing the project with Docker. You'll learn how to create a modern tech portfolio that demonstrates both front-end and back-end skills, while integrating an AI chatbot to answer questions about your experience.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/916b39d37866e119d1da9e99366b9ffa?_a=AQAEuiZ)  
52  
2
6. 6  
[](/posts/a-video-course-on-postgresql-cgdzrex3d "A video course on PostgreSQL")  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
3m read time • Oct 18, 2024  
### A video course on PostgreSQL  
Mastering Postgres is a comprehensive video course designed to enhance your skills with PostgreSQL, covering fundamentals to advanced topics like indexes and data types. Learn to use full text search capabilities, create efficient indexes, and optimize your database performance. The course is taught by Aaron Francis, a seasoned software developer and database educator, and offers real-world examples to help you understand core principles. The course includes 4K resolution videos with both light and dark modes, and offers a satisfaction guarantee with refund options.

+2  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/3b0a11a450560f90560ac94f9ff40bd7?_a=AQAEuiZ)  
46  
1
7. 7  
[](/posts/the-internals-of-a-primary-index-ekwvizuvz "The Internals of a Primary Index")  
[![hnasr's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/afd3cb0661b54386bbe31c04f5efe0dc)](/tags/[tag]/best-of/[year]/[month])  
2m read time • Oct 20, 2024  
### The Internals of a Primary Index  
A primary key uniquely identifies a row and is typically indexed for fast access. Primary indexes are often clustered, meaning they store full rows. Secondary indexes only store row identifiers, requiring an additional lookup of the primary key to retrieve full rows. Postgres is an exception as it does not use a real primary clustered index; all indexes, including primary, point to the row identifier or tuple id. The tuple id in Postgres is unique and allows direct row access with minimal I/O.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/e57176b83751ba4336b4ff2b2ed14eaf?_a=AQAEuiZ)  
44
8. 8  
[](/posts/building-an-api-with-go-postgresql-google-cloud-and-cockroachdb-tbxd086pp "Building an API with Go, PostgreSQL, Google Cloud and CockroachDB")  
[![towardsdev's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/2c710db2750a4a70835862534cb7c9d4)](/tags/[tag]/best-of/[year]/[month])  
16m read time • Oct 25, 2024  
### Building an API with Go, PostgreSQL, Google Cloud and CockroachDB  
The post outlines the process of building and deploying an API using Go, PostgreSQL, Google Cloud Run, and CockroachDB. It provides detailed steps for setting up a local PostgreSQL database, creating an API server with Go, managing middleware and routes, handling error structures, caching, and deploying on Google Cloud Run. Additionally, it includes instructions for integrating with CockroachDB and using Google Secret Manager for managing sensitive data like certificates.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/b7ec60686e0936eaa2465cd4ebf28c5c?_a=AQAEuiZ)  
44
9. 9  
[](/posts/mysql-vs-postgresql-round-2-performance-benchmark-latency---throughput---saturation--ulxvfrf6x "MySQL vs PostgreSQL (Round 2) Performance Benchmark (Latency - Throughput - Saturation)")  
Video  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
13m watch time • Oct 15, 2024  
### MySQL vs PostgreSQL (Round 2) Performance Benchmark (Latency - Throughput - Saturation)  
Performance comparison between PostgreSQL and MySQL focusing on latency, throughput, and system resource usage. The benchmark simulates an e-commerce website managing customer and order data, with tests for INSERT, UPDATE, DELETE, and SELECT operations. Improvements include optimized settings for both databases and utilizing i3en EC2 instances. PostgreSQL outperforms MySQL in write-heavy operations, while read operations show smaller differences.

+4  
![Post Cover image](https://i.ytimg.com/vi/17BqoNEQKTM/sddefault.jpg)  
36
10. 10  
[](/posts/building-change-data-capture-cdc-in-net-with-debezium-rabbitmq-0u5yow8pk "Building Change Data Capture (CDC) in .NET with Debezium + RabbitMQ")  
Video  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
21m watch time • Oct 29, 2024  
### Building Change Data Capture (CDC) in .NET with Debezium + RabbitMQ  
Milan introduces Change Data Capture (CDC), which tracks and reacts to database changes in real-time or near-real-time. He covers setting up CDC with PostgreSQL, RabbitMQ, and MassTransit in a .NET application. The guide includes configuring Docker containers, setting environment variables, and using transformations in Debezium to route messages accurately. Despite initial challenges, the setup enables streaming database changes to RabbitMQ, which are then consumed by a .NET app.

+4  
![Post Cover image](https://i.ytimg.com/vi/pACol04S_Ws/sddefault.jpg)  
31
11. 11  
[](/posts/building-a-high-performance-sensor-data-api-with-fastapi-and-postgres-timescaledb-extension-gvfsxlgvo "Building a High-Performance Sensor Data API with FastAPI and Postgres' TimescaleDB Extension")  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
8m read time • Oct 19, 2024  
### Building a High-Performance Sensor Data API with FastAPI and Postgres' TimescaleDB Extension  
This guide helps you build a high-performance API for streaming, storing, and querying sensor data using FastAPI and TimescaleDB. It covers setting up the project, database, and creating API endpoints that efficiently manage and analyze sensor data, leveraging TimescaleDB's advanced time-series features for optimal performance.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/916b39d37866e119d1da9e99366b9ffa?_a=AQAEuiZ)  
29
12. 12  
[](/posts/watermill-1-4-released-event-driven-go-library--od0b70had "Watermill 1.4 Released (Event-Driven Go Library)")  
[![threedotslabs's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8060f0b72e3f4f008b8b6f313627c2f2)](/tags/[tag]/best-of/[year]/[month])  
10m read time • Oct 29, 2024  
### Watermill 1.4 Released (Event-Driven Go Library)  
Watermill 1.4, an event-driven Go library, has seen significant updates. Key highlights include support for a new universal requeuer component that works with all Pub/Subs (requiring PostgreSQL for now), a pq CLI tool for managing poison queues, and a delay package to add delay metadata to messages. There's also enhanced support for AWS SNS/SQS Pub/Subs and major updates to watermill-amqp and watermill-sql. The new release includes refreshed documentation, a new logo, and several new examples showcasing features like delayed messages and distributed transactions.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/dd81aaac2b75cf8631b963494492ccc3?_a=AQAEuiZ)  
28
13. 13  
[](/posts/how-to-create-an-aws-s3-bucket-for-postgres-backups-5fkasv3ev "How to create an AWS S3 bucket for Postgres backups")  
[![neontech's profile](https://media.daily.dev/image/upload/s--65EDghou--/f_auto/v1724339118/logos/neontech)](/tags/[tag]/best-of/[year]/[month])  
5m read time • Oct 29, 2024  
### How to create an AWS S3 bucket for Postgres backups  
Learn how to set up an AWS S3 bucket to store Postgres backups, a useful step for managing backups in a multi-tenant architecture. This guide includes setting up AWS Providers and Roles, creating an OIDC Identity Provider and Role, and configuring an S3 bucket with an updated policy. The process involves using GitHub Actions to automate transfers, ideal for handling numerous projects efficiently.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/693fd9fa8f29f7f84e514472df3fd865?_a=AQAEuiZ)  
21
14. 14  
[](/posts/seeding-a-postgres-database-in-github-actions-without-storing-sql-in-gitlfs-ywedr86z2 "Seeding a Postgres Database in GitHub Actions Without Storing SQL in GitLFS")  
[![simplethread's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/82c0dd537790449d9b595be436d10e7e)](/tags/[tag]/best-of/[year]/[month])  
3m read time • Oct 21, 2024  
### Seeding a Postgres Database in GitHub Actions Without Storing SQL in GitLFS  
Setting up a Postgres database in a test environment usually avoids preloading data, but sometimes budget constraints require a workaround. To avoid using GitLFS for a large seed data file, compress it with \`tar\` and \`gzip\` before committing it to the repository. During the GitHub Actions workflow, decompress the file before running tests. If you encounter a 'no space left on device' error, increase the shared memory size (\`shm-size\`) to resolve the issue.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/23e33130e0179f8ccbd5f128246500cb?_a=AQAEuiZ)  
21
15. 15  
[](/posts/full-text-search-in-net-with-postgresql-and-ef-core-3op34m0wm "Full Text Search in .NET With PostgreSQL and EF Core")  
Video  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
24m watch time • Oct 29, 2024  
### Full Text Search in .NET With PostgreSQL and EF Core  
Learn how to implement full text search in a .NET application using PostgreSQL and EF Core, without relying on external services like Elasticsearch or Solr. This guide walks through creating a search endpoint, handling case sensitivity, improving performance with indexes, and ranking search results for relevance. Additionally, it covers optimizing database queries for performance with full text search capabilities.

+3  
![Post Cover image](https://i.ytimg.com/vi/NPduWiPzhpE/sddefault.jpg)  
20
16. 16  
[](/posts/go-project-to-backup-and-restore-posgresql-database-to-local-s3-ssh-and-ftp-remote-storage-zfafyxyen "Go project to backup and restore PosgreSQL database to local, S3, SSH and FTP remote storage")  
[![Jonas Kaninda's profile](https://lh3.googleusercontent.com/a/ACg8ocLi-79_XvnVTxWVOw9_0HnIm4mFT51r6kGhZNV7L0wIYRf9D7HN=s64-c)](https://daily.dev/jkaninda)  
[![golangnuts's profile](https://media.daily.dev/image/upload/s--_LlDFbfN--/f_auto/v1723705274/squads/6fc8295e-5271-40f3-9a48-2a5b42f7c85a)](/tags/[tag]/best-of/[year]/[month])  
Jonas Kaninda  
@golangnuts • Oct 17, 2024  
### Go project to backup and restore PosgreSQL database to local, S3, SSH and FTP remote storage

+3  
![Post Cover image](https://media.daily.dev/image/upload/s--iAREkndb--/f_auto/v1729272664/posts/zFAfyxyEn)  
20
17. 17  
[](/posts/docker-backing-up-posgresql-dabatase-to-local-aws-s3-ftp-and-ssh-remote-storage-3emdlftgx "Docker backing up PosgreSQL dabatase to Local, AWS S3, FTP and SSH remote storage")  
[![Jonas Kaninda's profile](https://lh3.googleusercontent.com/a/ACg8ocLi-79_XvnVTxWVOw9_0HnIm4mFT51r6kGhZNV7L0wIYRf9D7HN=s64-c)](https://daily.dev/jkaninda)  
[![devopslife's profile](https://media.daily.dev/image/upload/s--dvoOftsx--/f_auto/v1727334279/squads/1cea5679-59ae-4513-b843-7bf65ad25d5f)](/tags/[tag]/best-of/[year]/[month])  
Jonas Kaninda  
@devopslife • Oct 18, 2024  
### Docker backing up PosgreSQL dabatase to Local, AWS S3, FTP and SSH remote storage

+4  
![Post Cover image](https://media.daily.dev/image/upload/s--7fz4rSiv--/f_auto/v1729273045/posts/3EmDLftgx)  
17
18. 18  
[](/posts/mysql-vs-postgresql-performance-benchmark-latency---throughput---saturation--egmifokeu "MySQL vs PostgreSQL Performance Benchmark (Latency - Throughput - Saturation)")  
Video  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
10m watch time • Oct 09, 2024  
### MySQL vs PostgreSQL Performance Benchmark (Latency - Throughput - Saturation)  
The post compares MySQL and PostgreSQL databases focusing on latency, throughput, and saturation during data ingestion and retrieval. PostgreSQL demonstrates lower latency, efficient CPU and memory usage, and better disk usage efficiency compared to MySQL. Detailed benchmark tests show PostgreSQL handling nearly twice the number of queries per second than MySQL. The author invites suggestions for test improvements and provides a breakdown of various performance metrics collected during the tests.

+3  
![Post Cover image](https://i.ytimg.com/vi/R7jBtnrUmYI/sddefault.jpg)  
18
19. 19  
[](/posts/live-share-when-your-database-escapes-your-browser-u4j0nsapf "Live Share: When your database escapes your browser")  
[![supabase's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/d0aa77cfb88d44dd8e6d5cd02fdf80bd)](/tags/[tag]/best-of/[year]/[month])  
7m read time • Oct 10, 2024  
### Live Share: When your database escapes your browser  
Live Share is a new feature for database.build (formerly postgres.new) that allows connecting to in-browser PGlite databases from outside the browser. This is accomplished by generating a unique Postgres connection string for use with any Postgres client. Database.build offers an AI-assisted sandbox for creating and querying Postgres databases using natural language and standard SQL. Users can drag-and-drop CSVs to generate tables automatically. A websocket-to-tcp proxy facilitates the connection, using pg-gateway to relay messages. PGlite supports single-client connections and has some limitations in protocol support and connection concurrency.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/da8e57af055b83964dcec885ce78888c?_a=AQAEuiZ)  
16
20. 20  
[](/posts/how-uber-handles-trillions-of-transactions-qjsfen4cm "How Uber Handles TRILLIONS of Transactions")  
Video  
[![codingwithlewis's profile](https://media.daily.dev/image/upload/s--St-eJIdL--/f_auto/v1728073102/logos/codingwithlewis)](/tags/[tag]/best-of/[year]/[month])  
13m watch time • Oct 17, 2024  
### How Uber Handles TRILLIONS of Transactions  
Uber handles trillions of transactions by evolving from a monolithic application to a microservices architecture using Postgres and MySQL. They developed their own immutable ledger system called Ledger Store, which sits above existing NoSQL databases, ensuring the integrity of financial transactions. Key features include sealing, manifest for security, and the use of Apache Kafka for real-time data streaming. They managed a complex database migration with minimal disruption by employing strategies like checkpointed data processing and the Shadow Rider system for simultaneous database operations.

+4  
![Post Cover image](https://i.ytimg.com/vi/qGAPokt6Buo/sddefault.jpg)  
16
21. 21  
[](/posts/building-a-high-performance-api-with-fastapi-pydantic-and-neon-postgres-5lrxxaoy2 "Building a High-Performance API with FastAPI, Pydantic, and Neon Postgres")  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
7m read time • Oct 16, 2024  
### Building a High-Performance API with FastAPI, Pydantic, and Neon Postgres  
Learn to create a high-performance API for managing a tech conference system using FastAPI, Pydantic for data validation, and Neon's serverless Postgres. The guide walks through setting up the project, connecting to Neon Postgres, defining models and schemas, creating API endpoints, running and testing the API, and Dockerizing the application. It also covers performance optimization techniques such as database indexing, pagination, dependency injection, and efficient data handling.

+5  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/916b39d37866e119d1da9e99366b9ffa?_a=AQAEuiZ)  
15
22. 22  
[](/posts/what-happened-in-september--s1pltb6vj "What Happened in September?")  
Video  
[![awesome-coding's profile](https://media.daily.dev/image/upload/s--mj_0cdD8--/f_auto/v1710506099/logos/awesome-coding)](/tags/[tag]/best-of/[year]/[month])  
3m watch time • Oct 01, 2024  
### What Happened in September?  
OpenAI released a new model aimed at providing more thoughtful and accurate responses, potentially impacting jobs. September saw the release of Postgres 17 with performance enhancements, and Deno 2, focusing on developer experience and interoperability. The Angular team is pushing for modularity with standalone components, while Vue 3.5 offers performance optimizations and improved reactivity without breaking changes. OpenAI's switch from Next.js to Remix is notable. Additionally, Caleb achieved $1 million in GitHub sponsors through valuable open-source projects.

+5  
![Post Cover image](https://i.ytimg.com/vi/Vz_5SY6finE/sddefault.jpg)  
13
23. 23  
[](/posts/building-an-async-product-management-api-with-fastapi-pydantic-and-postgresql-cocl4q4rs "Building an Async Product Management API with FastAPI, Pydantic, and PostgreSQL")  
[![community's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community)](/tags/[tag]/best-of/[year]/[month])  
8m read time • Oct 12, 2024  
### Building an Async Product Management API with FastAPI, Pydantic, and PostgreSQL  
Learn to build an asynchronous product management API using FastAPI, Pydantic for data validation, and PostgreSQL with connection pooling. This guide covers setting up your project, managing database connections with asyncpg, defining Pydantic models, creating API endpoints, and running and testing your application using various tools.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/916b39d37866e119d1da9e99366b9ffa?_a=AQAEuiZ)  
12

[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/2024/10#page","url":"https://daily.dev/tags/postgresql/best-of/2024/10","name":"Best PostgreSQL Posts — October 2024","description":"The most upvoted PostgreSQL posts from October 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/postgresql/best-of/2024/10#items","numberOfItems":23,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/databases-in-depth-complete-course-od3twuyvn","name":"Databases In-Depth – Complete Course"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/how-to-create-database-documentation-using-dbdocs-with-dbml-ugupat89v","name":"How to Create Database Documentation Using dbdocs with DBML"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/go-and-postgres-listen-notify-or-how-i-learned-to-stop-worrying-and-love-pubsub-luqrvckbc","name":"Go and Postgres Listen/Notify or: How I Learned to Stop Worrying and Love PubSub"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/writing-raw-sql-easier-with-pgx-and-sqlc-in-go-4kw3hpmr3","name":"Writing raw SQL easier with pgx and sqlc in Go"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/building-a-full-stack-portfolio-website-with-a-rag-powered-chatbot-dv75wy5rf","name":"Building a Full-Stack Portfolio Website with a RAG Powered Chatbot"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/a-video-course-on-postgresql-cgdzrex3d","name":"A video course on PostgreSQL"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/the-internals-of-a-primary-index-ekwvizuvz","name":"The Internals of a Primary Index"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/building-an-api-with-go-postgresql-google-cloud-and-cockroachdb-tbxd086pp","name":"Building an API with Go, PostgreSQL, Google Cloud and CockroachDB"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/mysql-vs-postgresql-round-2-performance-benchmark-latency---throughput---saturation--ulxvfrf6x","name":"MySQL vs PostgreSQL (Round 2) Performance Benchmark (Latency - Throughput - Saturation)"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/building-change-data-capture-cdc-in-net-with-debezium-rabbitmq-0u5yow8pk","name":"Building Change Data Capture (CDC) in .NET with Debezium + RabbitMQ"},{"@type":"ListItem","position":11,"url":"https://daily.dev/posts/building-a-high-performance-sensor-data-api-with-fastapi-and-postgres-timescaledb-extension-gvfsxlgvo","name":"Building a High-Performance Sensor Data API with FastAPI and Postgres' TimescaleDB Extension"},{"@type":"ListItem","position":12,"url":"https://daily.dev/posts/watermill-1-4-released-event-driven-go-library--od0b70had","name":"Watermill 1.4 Released (Event-Driven Go Library)"},{"@type":"ListItem","position":13,"url":"https://daily.dev/posts/how-to-create-an-aws-s3-bucket-for-postgres-backups-5fkasv3ev","name":"How to create an AWS S3 bucket for Postgres backups"},{"@type":"ListItem","position":14,"url":"https://daily.dev/posts/seeding-a-postgres-database-in-github-actions-without-storing-sql-in-gitlfs-ywedr86z2","name":"Seeding a Postgres Database in GitHub Actions Without Storing SQL in GitLFS"},{"@type":"ListItem","position":15,"url":"https://daily.dev/posts/full-text-search-in-net-with-postgresql-and-ef-core-3op34m0wm","name":"Full Text Search in .NET With PostgreSQL and EF Core"},{"@type":"ListItem","position":16,"url":"https://daily.dev/posts/go-project-to-backup-and-restore-posgresql-database-to-local-s3-ssh-and-ftp-remote-storage-zfafyxyen","name":"Go project to backup and restore PosgreSQL database to local, S3, SSH and FTP remote storage"},{"@type":"ListItem","position":17,"url":"https://daily.dev/posts/docker-backing-up-posgresql-dabatase-to-local-aws-s3-ftp-and-ssh-remote-storage-3emdlftgx","name":"Docker backing up PosgreSQL dabatase to Local, AWS S3, FTP and SSH remote storage"},{"@type":"ListItem","position":18,"url":"https://daily.dev/posts/mysql-vs-postgresql-performance-benchmark-latency---throughput---saturation--egmifokeu","name":"MySQL vs PostgreSQL Performance Benchmark (Latency - Throughput - Saturation)"},{"@type":"ListItem","position":19,"url":"https://daily.dev/posts/live-share-when-your-database-escapes-your-browser-u4j0nsapf","name":"Live Share: When your database escapes your browser"},{"@type":"ListItem","position":20,"url":"https://daily.dev/posts/how-uber-handles-trillions-of-transactions-qjsfen4cm","name":"How Uber Handles TRILLIONS of Transactions"},{"@type":"ListItem","position":21,"url":"https://daily.dev/posts/building-a-high-performance-api-with-fastapi-pydantic-and-neon-postgres-5lrxxaoy2","name":"Building a High-Performance API with FastAPI, Pydantic, and Neon Postgres"},{"@type":"ListItem","position":22,"url":"https://daily.dev/posts/what-happened-in-september--s1pltb6vj","name":"What Happened in September?"},{"@type":"ListItem","position":23,"url":"https://daily.dev/posts/building-an-async-product-management-api-with-fastapi-pydantic-and-postgresql-cocl4q4rs","name":"Building an Async Product Management API with FastAPI, Pydantic, and PostgreSQL"}]},{"@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":"October 2024"}]}]}
```

