SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration
SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration Today's Highlights This week's highlights feature a de…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
tutorial
typescript
webdev
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist Today's Highlights This week's highlights include powerful new Iceberg data manip…
Billing a Bulk Endpoint Where Any Row Might Be Free
I already had per-invoice billing working: reserve a credit, do the expensive call, settle or refund. Then I added a bulk endpoint — paste a list, ver…
SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension
SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension Today's Highlights This week, we delve into SQLite's secure deletion and blob upd…
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive Today's Highlights This week brings a stable new patch release for…
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals
DuckDB 1.4.5 LTS, pgEdge ColdFront Beta, and SQLite's FCNTL_PDB Internals Today's Highlights This week's highlights feature the latest DuckDB 1.4.5 LT…
Why AI Agents Make Me Reach for SQLite
Lately I keep reaching for SQLite where, before, I'd have reached for Postgres without thinking. It started with small services, then a bigger questio…
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective Today's Highlights This week's database highlights include a deep dive into SQ…
Expanding the Sovereign AI Stack: Moving the Specification from Gateway to Local Silicon
When I first introduced the Sovereign Systems Specification and released the initial foundation of the SDK, sovereign-core and its accompanying sovere…
Metering a Paid API Without Overselling: the Credit Ledger Behind a Solo SaaS
I charge per invoice extracted. One upload of a five-invoice PDF should cost five credits, a failed extraction should cost nothing, and a user with on…
SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests
Running SQLite in production for a multi-tenant SaaS means giving up the operational comfort of a managed database. No automatic backups, no point-in-…
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
PostgreSQL HA Risks, Replication Internals, & Rapid Branching Today's Highlights Today's highlights include critical insights into Patroni's repli…
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data Today's Highlights Today's highlights include DuckDB's innovative data inlinin…
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug
SQLite ON CONFLICT DO SELECT Proposal, PostgreSQL 19 Features & SQLite Critical Bug Today's Highlights This week in databases, a proposal seeks to…
Why SQLite FTS5's default tokenizer drops your Japanese substrings (and the one-line fix)
If you're building any kind of personal-memory layer on top of SQLite — Claude Code conversation history, notes app, indexed knowledge base — there's …
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem Today's Highlights This week's highlights include DuckDB's new Duc…
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning Today's Highlights This week's database news highlights significant advan…
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s Today's Highlights This week, DuckDB introduces integrated vector and hybri…
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture Today's Highlights This week, we explore SQLite's query planner o…
Building an Event Sourced Video Moderation Audit Log with PHP and SQLite
The 3am call from a Japanese rightsholder Last quarter a Japanese label sent a takedown notice for fourteen music videos we'd been aggregating across …
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns Today's Highlights PostgreSQL 19 introduces major features with SQL/PGQ for gra…
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning
DuckDB 1.5.3 Iceberg updates, PostgreSQL TDE extension & AI index tuning Today's Highlights Today's highlights include DuckDB's enhanced Iceberg i…
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm Today's Highlights This week, we dive into a critical SQLite predicate evaluation b…
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's Highlights This week, we dive into SQLite's build process with SQLITE_DQ…
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives Today's Highlights This week features significant advancements for DuckDB'…
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec Today's Highlights This week's highlights feature a practical checklist f…
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions
DuckDB 1.5.2 Release, DuckLake v1.0 & PostgRESTxn for Atomic PG Transactions Today's Highlights DuckDB announces its 1.5.2 patch release with perf…
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension
DuckDB 1.5.3 Adds Quack Client-Server, SQLite Gets Cypher Graph Extension Today's Highlights This week, DuckDB releases version 1.5.3 with the Quack c…
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations Today's Highlights This week's highlights include advanced SQL techniques …
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production Today's Highlights This week's highlights feature new PostgreSQL…