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.
Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Comments
2 min read
Ontology on Snowflake: How to Make AI Actually Understand Your Data

Ontology on Snowflake: How to Make AI Actually Understand Your Data

2
Comments 1
2 min read
READ COMMITTED isn't as safe as you think

READ COMMITTED isn't as safe as you think

Comments 2
6 min read
Your database scales to zero. Your retry loop doesn't know that.

Your database scales to zero. Your retry loop doesn't know that.

Comments 1
4 min read
Modeling a Creator SaaS in a Single DynamoDB Table

Modeling a Creator SaaS in a Single DynamoDB Table

Comments 1
4 min read
Apache Data Lakehouse Weekly: July 21 to July 29, 2026

Apache Data Lakehouse Weekly: July 21 to July 29, 2026

1
Comments
26 min read
A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

Comments
7 min read
Moving from Migrate Mongo to Mongo Migrate Kit (mmk) Without Re Running Old Migrations

Moving from Migrate Mongo to Mongo Migrate Kit (mmk) Without Re Running Old Migrations

Comments
2 min read
Day 37: How to Handle Updates and Deletes in ClickHouse® (Mutations)

Day 37: How to Handle Updates and Deletes in ClickHouse® (Mutations)

1
Comments
4 min read
When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data

When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data

5
Comments
8 min read
How We Built a Multi-Tenant SaaS Using SQLite and Node.js

How We Built a Multi-Tenant SaaS Using SQLite and Node.js

2
Comments 1
3 min read
Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes

Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes

2
Comments
4 min read
Encrypting Room SQLite Databases with SQLCipher and Biometric Keys

Encrypting Room SQLite Databases with SQLCipher and Biometric Keys

Comments
2 min read
Stop Pasting Raw CSVs Into ChatGPT: A Data Scientist's Guide to LLM Context Engineering

Stop Pasting Raw CSVs Into ChatGPT: A Data Scientist's Guide to LLM Context Engineering

Comments
5 min read
Exception-based attendance: stop storing a row for every student who showed up

Exception-based attendance: stop storing a row for every student who showed up

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