DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Day 1: Understanding MySQL Storage Engines and MVCC

Day 1: Understanding MySQL Storage Engines and MVCC

Comments
6 min read
The SQL CASE Expression, Explained for Beginners

The SQL CASE Expression, Explained for Beginners

Comments
9 min read
Powering Local-First AI: Searching and Retrieving Context for Inference

Powering Local-First AI: Searching and Retrieving Context for Inference

1
Comments
3 min read
My DuckDB Extension PR Sat Red for Eight Weeks. The Bug Wasn't What the CI Said.

My DuckDB Extension PR Sat Red for Eight Weeks. The Bug Wasn't What the CI Said.

Comments
4 min read
Rewriting PostgreSQL in Rust: Technical Challenges and Lessons Learned

Rewriting PostgreSQL in Rust: Technical Challenges and Lessons Learned

Comments 1
3 min read
Debugging a BSONVersionError in Mongoose: What It Actually Means and How I Fixed It

Debugging a BSONVersionError in Mongoose: What It Actually Means and How I Fixed It

Comments
3 min read
Stop Data Leaks: Tenant Scopes in Laravel 🛡️

Stop Data Leaks: Tenant Scopes in Laravel 🛡️

2
Comments
2 min read
Vector Databases in Practice for Java

Vector Databases in Practice for Java

Comments
9 min read
Building an Auto-Parts Dropshipping Catalog: Lessons From 180k SKUs

Building an Auto-Parts Dropshipping Catalog: Lessons From 180k SKUs

Comments
2 min read
Part 3. How to Fix External I/O Inside Transactions Without Overengineering Everything

Part 3. How to Fix External I/O Inside Transactions Without Overengineering Everything

3
Comments 2
11 min read
Part 2. The Spring @Transactional Pattern That Drained Our Hikari Pool

Part 2. The Spring @Transactional Pattern That Drained Our Hikari Pool

2
Comments 2
6 min read
Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks

Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks

Comments
4 min read
How to Set Up a SQL Database for Beginners

How to Set Up a SQL Database for Beginners

Comments
6 min read
How to know which job postings were removed, when nothing tells you

How to know which job postings were removed, when nothing tells you

Comments 2
3 min read
Day 59: High Availability (HA) and Disaster Recovery (DR) in ClickHouse®

Day 59: High Availability (HA) and Disaster Recovery (DR) in ClickHouse®

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.