4 blog available in the CoPilot directory
postgresA battle-tested relational design for airline-mile-style points that expire per grant, support exact cancellation, and satisfy accounting audits — plus real PostgreSQL benchmarks and a scalability analysis.
postgresHow to add vector similarity search to an existing Postgres app using pgvector — covering extension setup, embedding generation, cosine similarity queries, and HNSW indexing for performance.
postgresStory about how I went from shipping a popular ORM in 2012… to throwing it all away… to realizing that the database itself should be the single source of truth.
postgresTigerFS is a filesystem backed by PostgreSQL, built by the Timescale team. It mounts a database as a...