DB Pro Blog
From the blog
Product updates, engineering insights, and tutorials for working with your databases.
Postgres Docker: The Complete 2026 Guide
Run Postgres in Docker the way that works on Postgres 18. The PGDATA change that breaks older guides, volumes, Compose healthchecks, and common errors.
JaySQLite Is All You Need
We built a social network on SQLite, put it behind a Node API, and hit it until something broke. One file, one process, 315 million requests a day on the heaviest endpoint. Here are the numbers, the config, and the honest limits.
Solving Sudoku in Pure SQL
Hand SQLite a Sudoku puzzle and a single recursive query fills in every blank. No solver library, no loop in JavaScript, just SQL doing backtracking search. Build it from scratch and solve your own.
A New Look for DB Pro
We gave DB Pro a new logo, a lighter website, and a refreshed brand. Here is the old and the new, side by side, and what the change means to us.
Conway's Game of Life in Pure SQL
Cellular automata, running on nothing but SQL queries, live in your browser. Press play, then build the whole thing from scratch with runnable SQL.
How to Fix Slow SQLite Queries
A practitioner's guide to SQLite performance. The PRAGMAs that change everything, the concurrency model that traps unwary apps, EXPLAIN QUERY PLAN, indexing strategy, FTS5 and JSON, and the tooling worth knowing.
How to Fix Slow ClickHouse Queries
A practitioner's guide to ClickHouse performance. Primary key design, partition pruning, skip indexes, projections, PREWHERE, materialized views, the join strategies that scale, insert patterns, and the system tables worth knowing.
How to Fix Slow Redis Queries
A practitioner's guide to diagnosing and fixing slow Redis workloads. Why Redis slowness is fundamentally different from SQL, the big-key and hot-key problems, SLOWLOG and LATENCY, picking the right data structure, and the configuration that prevents outages.
How to Fix Slow MongoDB Queries
A practitioner's guide to diagnosing and fixing slow MongoDB queries. The diagnostic stack, reading explain output, indexing with the ESR rule, schema design that holds up at scale, aggregation pipeline optimization, and the tools worth knowing.
How to Fix Slow Postgres Queries
A practitioner's guide to diagnosing and fixing slow Postgres queries. The diagnostic stack, reading EXPLAIN like a power user, index design, the configuration knobs that change query plans, and the tools worth installing.
Supabase MCP: Connect AI Agents to Your Database
How to use the Supabase MCP server to give AI agents like Claude direct access to your Supabase database.
AWS Redis (ElastiCache): Setup and Best Practices
How to set up and configure Amazon ElastiCache for Redis, with best practices for production deployments.
Do You Even Need a Database?
We built the same HTTP server in Go, Bun, and Rust using two storage strategies: read the file on every request, or load everything into memory. Then we ran real benchmarks. The results are more interesting than you'd expect.
DB Pro Now Supports Val Town
DB Pro now connects to Val Town's SQLite databases. Browse tables, run queries, and manage your data with a proper desktop client.
Using SQLite with Expo: React Native Guide
How to use SQLite in Expo and React Native apps. Covers expo-sqlite setup, CRUD operations, Drizzle ORM integration, and offline-first patterns.
Memcached vs Redis: Caching Solutions Compared
Comparing Memcached and Redis for caching. When simple key-value caching is enough and when you need Redis's data structures.
ClickHouse vs PostgreSQL: OLAP vs OLTP
ClickHouse and PostgreSQL serve different purposes. Here's when to use a columnar analytics database vs a general-purpose relational database.
ClickHouse vs Snowflake: Cost and Performance Comparison
Comparing ClickHouse and Snowflake for analytics workloads. Performance, pricing models, and when each makes sense.
ClickHouse vs Druid: Real-Time Analytics Comparison
Comparing ClickHouse and Apache Druid for real-time analytics. Architecture, query performance, ingestion, and when to choose each.
Aurora PostgreSQL: Features, Pricing, and When to Use It
A practical breakdown of Amazon Aurora PostgreSQL. What it offers, what it costs, and when it's the right choice over standard RDS or self-managed Postgres.
Best Client Database Software for Small Business in 2026
A practical guide to client database software for small businesses. Covers free and paid options, from simple spreadsheets to full CRMs.
Neon vs PlanetScale: Serverless MySQL vs Postgres
Comparing serverless database platforms: Neon's PostgreSQL with branching versus PlanetScale's MySQL with deploy requests.
ClickHouse Competitors: Comparing Analytics Databases
An overview of databases that compete with ClickHouse for analytical workloads, and when to choose each.
PlanetScale vs Supabase: Database Platform Comparison
MySQL-based serverless database vs PostgreSQL backend platform. Understanding when to use each.
DuckDB vs ClickHouse: Embedded vs Distributed Analytics
Comparing an embedded analytical database with a distributed OLAP powerhouse for different use cases.
ClickHouse vs BigQuery: Performance and Cost Comparison
Comparing self-managed ClickHouse with Google's serverless data warehouse for analytics workloads.
SQLite Alternatives: When to Choose Something Else
SQLite is great, but it's not for everything. Here's when to consider alternatives and what to choose.
Top MongoDB Interview Questions (2026)
Prepare for your MongoDB interview with these commonly asked questions covering basics to advanced topics.
Best Supabase Alternatives in 2026
Looking for alternatives to Supabase? Here are the best options depending on what you need.
Best PlanetScale Alternatives After Hobby Tier Removal
PlanetScale removed their free tier. Here are the best alternatives for developers and small projects.
Using SQLite with Bun: A Complete Guide
Bun's built-in SQLite driver is fast and simple. Here's how to use it effectively.
Redis Streams: Complete Guide to Real-Time Data
Learn how to use Redis Streams for event sourcing, message queues, and real-time data processing.
MySQL vs MariaDB: Which Fork Should You Choose?
Understanding the differences between MySQL and its community fork to make an informed decision.
Neon vs Supabase: Comparing Serverless Postgres
Two modern Postgres platforms with different philosophies. Here's how to choose.
MongoDB vs MySQL: When to Use Each
Document database vs relational database. Understanding the trade-offs to make the right choice.
DynamoDB vs MongoDB: Comparing NoSQL Giants
AWS's managed NoSQL vs the document database pioneer, which one fits your needs?
Announcing DB Pro Cloud
A self-hosted, web-based database client built for developers and teams who need to collaborate on real database work.
MongoDB vs PostgreSQL: A Detailed Comparison
Comparing the leading NoSQL and SQL databases to help you choose the right one for your project.
Supabase vs Firebase: Which Should You Choose?
A detailed comparison of Supabase and Firebase to help you pick the right backend for your next project.
The Last of the JavaScript Frameworks
There's a new JavaScript framework every week. Remember that joke? It's dead. Not because it stopped being funny. Because it stopped being true.
DB Pro v1.6.0: Redis Support and PostgreSQL Enums
Redis database support with managed providers, and PostgreSQL enum browsing.
How to Fix Slow MySQL Queries
Your MySQL query is slow. Here's how to find out why and fix it, from basic EXPLAIN analysis to indexing strategies and query rewrites.
PostgreSQL FOR UPDATE SKIP LOCKED: The One-Liner Job Queue
Building a reliable job queue in your database without double-processing or deadlocks? PostgreSQL's FOR UPDATE SKIP LOCKED makes it surprisingly simple.
DB Pro v1.4.0: MSSQL, SSH Tunneling, and More
MSSQL support, SSH tunneling, Keychain integration, and more.
Chess in Pure SQL
What if I told you SQL could play chess? No JavaScript, no frameworks - just pure SQL rendering a full chess board in your browser.
DB Pro v1.3.0: Database Creation, Multi-Query Editor & PlanetScale Vitess
Create databases directly from the sidebar, execute multiple queries at once, and connect to PlanetScale Vitess.
DB Pro v1.2.0: Windows, Linux, MongoDB & Saved Queries
DB Pro is now available on Windows and Linux. Plus MongoDB support, saved queries with versioning, and more.
SQLite JSON Superpower: Virtual Columns + Indexing
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.
Getting Started with SQL: A Hands-On Tutorial
Learn SQL by doing. This interactive tutorial covers SELECT, INSERT, UPDATE, DELETE, JOINs, and aggregations - everything you need to start working with databases.
DB Pro v1.0.5: One-Time Licenses, Unlimited Connections & Demo Database
Pay once, use forever. We're introducing one-time purchase licenses, removing connection limits for everyone, and adding a demo database to help you get started.
DB Pro is Here: Download Now for Free
After months of building, DB Pro is finally available to download. This is just the start of our journey to reimagine how you work with databases.
The Glass Ceiling of macOS Icon Design
Remember the days when you'd glance down at your dock in macOS and see a duck-shaped icon, perched next to a green circle, which was hanging out next to a fun 3D truck?
Goodbye Prisma, Hello Drizzle
Goodbye Prisma, hello Drizzle. One is a heavyweight champion with an engine under the hood, the other is a featherweight sprinter that just works in Electron. We had to make the switch.
Introducing DB Pro: The Modern Database Desktop App
Born out of frustration with existing database apps, we set out to build something that goes beyond basic queries to become your complete data workbench.