News

A Practical Guide to Table Partitioning in PostgreSQL

As PostgreSQL tables grow into hundreds of millions of rows, query performance can suffer even with strong indexing. Table partiti...

Investigating the "Bus Factor" Risk in MongoDB, MariaDB, and More

The “bus factor” (also called “truck factor’) measures how many people would have to disappear before no one left knows how to fix...

Anthropic Backs Databasus Under Claude for Open Source Program

atabasus — open source self-hosted database backup tool (5,800+ GitHub stars, 250k+ Docker pulls) — was accepted into Anthrop...

I Spent Two Weeks Testing 8 Databases With the Same Question - Here's What Actua...

An analytics dashboard at a company was taking 4 minutes to load. The company was spending $8,000 a month on a database that was b...

How OpenAI Scaled to 800 Million Users on PostgreSQL

ChatGPT scaled from zero to hundreds of millions of users while staying on PostgreSQL. Instead of migrating to NoSQL, OpenAI appli...

CP Systems Explained, Part 2: Quorums, Consensus, and the Price of Being Right

This is Part 2 of a 4-part series covering the CAP theorem and distributed systems trade-offs. In Part 1, we examined the CAP. the...

Databasus Became the Most Popular PostgreSQL Backup Tool in 2025

Databasus is the most starred Postgres backup tool on GitHub. It surpasses established solutions like WAL-G, pgBackRest and Barman...

The HackerNoon Newsletter: How Will We Distinguish Truth From Fiction? (12/2/202...

Stateful API-to-Database Synchronization: Implementing Incremental Data Ingestio...

Stop writing fragile cron scripts. Learn to build stateful, incremental data streams from any REST API using Python and a pull-bas...

How Google’s GenAI Toolbox Makes LLM-Database Integration Actually Usable

Most teams agree on the same painful truth: connecting an LLM to a production SQL database is way harder than it should be. Goog...

Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunk...

The "bad" correlated subquery outperformed the "good" JOIN. The subquery triggered a Nested Loop plan with fast index lookups (25...

Synchronizing Data from MySQL to PostgreSQL Using Apache SeaTunnel

A step-by-step walkthrough of building a real-time data pipeline to merge and synchronize MySQL data sources using Apache SeaTunne...