» Tag
databases
72 postsClickHouse vs Postgres: A 100 Million Row Showdown on a Mac Mini
A Mac Mini M4 benchmark pits ClickHouse against Postgres across 100 million LLM trace rows, comparing ingest speed, disk usage, and query latency.
Rewriting PostgreSQL in Rust: Challenges and Lessons Learned
Porting PostgreSQL to Rust surfaces deep challenges in memory management, concurrency, and extension compatibility, with measurable performance trade-offs.
Querying Historical Data in Postgres with the SCD Type 4 Pattern
A practical Postgres pattern using a history table, triggers, and valid_from/valid_to columns to answer point-in-time queries about record state in a single SELECT.
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.comA Playground Created for 110 Database Systems
An interactive playground for 110 database systems allows users to run queries and compare results.
Syncular: Offline-First SQL Sync with TypeScript and Rust Cores
Syncular offers an offline-first SQL synchronization solution built with TypeScript and Rust cores.
Cisco Verifies Lineage of 900 Open Models: 69% Remain Unverified
Cisco has launched a public database verifying the lineage of 900 open models, addressing significant validation gaps for engineers.
Unified Query Plan in Postgres: Vector, Graph, and Relational Engine
A new approach integrates vector, graph, and relational queries into a single Postgres engine, demonstrating improved performance.
DynamoDB Deep Dive
Explore essential best practices for DynamoDB, focusing on consistency and data access patterns.
Using STRICT Tables in SQLite: A New Approach to Error Management
With SQLite 3.37, STRICT tables prevent data type errors, offering developers a more secure data management approach.
PostgreSQL Benchmark: AWS RDS vs Self-Hosted Hetzner (2026)
In a 2026 2 vCPU/4GB PostgreSQL 16 benchmark, Hostim led on writes, Hetzner won reads on raw CPU, and RDS trailed once hidden costs are counted.