» Tag
databases
72 postsDatabase 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.
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.comThe Startup's Postgres Survival Guide: Tips for Engineers
A guide compiling experiences with Postgres. Tips and best practices for developers.
PostgreSQL 19 Introduces Temporal Database Features
PostgreSQL 19 adds temporal keys and referential integrity, enhancing temporal database capabilities.
Transitioning to Desired-State Reference Data in PostgreSQL
Desired-state reference data in PostgreSQL simplifies data model management.
The Challenge of Adding a Column in the Middle of a PostgreSQL Table
Explore the complexities of adding columns in PostgreSQL and its data storage structure.
HNSW and Vector Search: Finding Nearest Neighbors Efficiently
HNSW is an effective method for finding nearest neighbors in vector search systems.
Idempotency: Why 'Just Retry It' Breaks More Than It Fixes
Idempotency is a critical concept in system design. Understanding the implications of retries is essential for avoiding errors.
Building a Personal "Agentic OS" for DBA Tasks
As an Oracle Apps DBA, I created an Agentic OS that manages tasks with approval gates and audit trails.