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.
The Missing Check After Your Database Query

The Missing Check After Your Database Query

Comments
6 min read
Star Schema vs Snowflake Schema: Which to Use and When

Star Schema vs Snowflake Schema: Which to Use and When

Comments
4 min read
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
READ COMMITTED isn't as safe as you think

READ COMMITTED isn't as safe as you think

Comments 2
6 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
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
Day 38: Optimizing Storage in ClickHouse® with Compression Codecs

Day 38: Optimizing Storage in ClickHouse® with Compression Codecs

1
Comments
4 min read
KoutenDB: Data Locality as a First-Stage Retrieval Index

KoutenDB: Data Locality as a First-Stage Retrieval Index

Comments
6 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.