» Tag
postgresql
46 postsAI Agents Write PostgreSQL Like Python
Exploring how AI agents write SQL in a Pythonic style and the resulting challenges.
Supabase's Silent Defaults Caused Four Production Incidents
Four Supabase incidents in one week trace to one cause: silent wrong data, no errors. Three concrete rules to prevent it follow.
Testing PostgreSQL Migrations Before COMMIT
PostgreSQL enables testing migrations after application but before commit, ensuring integrity.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comSupabase vs Firebase: Choosing Your Backend Stack
A practical comparison of Supabase's Postgres foundation and Firebase's Firestore model, covering vendor lock-in, pricing, offline support, and scaling trade-offs.
PostgreSQL VACUUM's Page-Level Byte-by-Byte Inspection
PostgreSQL VACUUM's three-stage operational mechanism was analyzed at the page level using pageinspect, pg_visibility, and pg_freespacemap. The difference between LP_DEAD and LP_UNUSED becomes clearer.
Database Comparison: SQLite, DuckDB, PostgreSQL, and More
Explore features of SQLite, DuckDB, PostgreSQL, MariaDB, ClickHouse, and MongoDB. Essential insights for engineers.
Critiques of PostgreSQL's MVCC Design
Learn about the issues with PostgreSQL's MVCC design and its comparison with other database systems.
All You Need is PostgreSQL: Simplifying Database Solutions
Explore how PostgreSQL can solve complex database problems without additional infrastructure. Key insights for engineers.
Vifu: Open Source Solution for Building AI-Native Games
VifuDev is an open-source project providing stable endpoints and easy installation for local AI agents.
PostgreSQL 19 Introduces Temporal Database Features
PostgreSQL 19 adds temporal keys and referential integrity, enhancing temporal database capabilities.