#PostgreSQL
3 posts tagged PostgreSQL. All posts
Change data capture in Postgres with logical replication slotsStream inserts, updates and deletes out of Postgres: wal_level=logical, slots with test_decoding and pgoutput, REPLICA IDENTITY, publications, and a Python consumer.
Semantic search in Postgres with pgvectorStore embeddings in Postgres with pgvector: vector columns, distance operators, HNSW and IVFFlat indexes, and filtered queries that still return enough rows.
Type-safe SQL in Go with sqlcGenerate typed Go code from plain SQL with sqlc: a version 2 sqlc.yaml, :one, :many and :exec queries, using pgx or database/sql, and transactions with WithTx.
© 2026 David Li · Home · Blog · RSS ·Classic site · Built with Astro, Starlight and three.js · Logos:Font Awesome Free (CC BY 4.0)