Welcome to the DB Pro blog. Here you'll find product updates, engineering insights, and tutorials to help you get the most out of your database workflows.
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 connects to Val Town's SQLite databases. Browse tables, run queries, and manage your data with a proper desktop client.
How to use SQLite in Expo and React Native apps. Covers expo-sqlite setup, CRUD operations, Drizzle ORM integration, and offline-first patterns.
Comparing Memcached and Redis for caching. When simple key-value caching is enough and when you need Redis's data structures.
ClickHouse and PostgreSQL serve different purposes. Here's when to use a columnar analytics database vs a general-purpose relational database.
Comparing ClickHouse and Snowflake for analytics workloads. Performance, pricing models, and when each makes sense.
Comparing ClickHouse and Apache Druid for real-time analytics. Architecture, query performance, ingestion, and when to choose each.
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.
A practical guide to client database software for small businesses. Covers free and paid options, from simple spreadsheets to full CRMs.
Comparing serverless database platforms: Neon's PostgreSQL with branching versus PlanetScale's MySQL with deploy requests.
MySQL-based serverless database vs PostgreSQL backend platform. Understanding when to use each.
An overview of databases that compete with ClickHouse for analytical workloads, and when to choose each.
Comparing an embedded analytical database with a distributed OLAP powerhouse for different use cases.
Comparing self-managed ClickHouse with Google's serverless data warehouse for analytics workloads.
SQLite is great, but it's not for everything. Here's when to consider alternatives and what to choose.
Prepare for your MongoDB interview with these commonly asked questions covering basics to advanced topics.
Looking for alternatives to Supabase? Here are the best options depending on what you need.
PlanetScale removed their free tier. Here are the best alternatives for developers and small projects.
Bun's built-in SQLite driver is fast and simple. Here's how to use it effectively.
Learn how to use Redis Streams for event sourcing, message queues, and real-time data processing.
Understanding the differences between MySQL and its community fork to make an informed decision.
Two modern Postgres platforms with different philosophies. Here's how to choose.
Document database vs relational database. Understanding the trade-offs to make the right choice.
AWS's managed NoSQL vs the document database pioneer, which one fits your needs?
A self-hosted, web-based database client built for developers and teams who need to collaborate on real database work.
Comparing the leading NoSQL and SQL databases to help you choose the right one for your project.
A detailed comparison of Supabase and Firebase to help you pick the right backend for your next project.
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.
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.
Redis database support with managed providers, and PostgreSQL enum browsing.
Building a reliable job queue in your database without double-processing or deadlocks? PostgreSQL's FOR UPDATE SKIP LOCKED makes it surprisingly simple.
MSSQL support, SSH tunneling, Keychain integration, and more.
What if I told you SQL could play chess? No JavaScript, no frameworks - just pure SQL rendering a full chess board in your browser.
Create databases directly from the sidebar, execute multiple queries at once, and connect to PlanetScale Vitess.
DB Pro is now available on Windows and Linux. Plus MongoDB support, saved queries with versioning, and more.
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.
Learn SQL by doing. This interactive tutorial covers SELECT, INSERT, UPDATE, DELETE, JOINs, and aggregations - everything you need to start working with databases.
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.
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.
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. 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.
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.