Skip to content

DEV Community

Database

Posts on building, using, and learning about databases.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Jun 26

$lookup join strategies: understanding the trade-offs with flexible documents

#postgres #documentdb #mongodb #database

11 min read

Dane Wu

Jun 26

You Wanted a Number, but Loaded 500,000 Rows Into Memory

#rails #performance #database #ruby

6 min read

Jun 26

Prompting AI for Complex Multi-Table SQL: A Practical Guide

#sql #database #ai #tutorial

5 min read

Prajapati Paresh

Jun 26

Zero-Downtime Database Migrations in Laravel

#laravel #database #architecture #devops

3 min read

Ebendttl

Jun 25

Engineering a High-Performance LSM-Tree Storage Engine: MemTables, SSTables, and Compaction

#webdev #database #typescript #javascript

5 min read

Victor Gutierrez Areyzaga

Jun 25

The Missing Check After Your Database Query

#security #python #database #opensource

6 min read

Vikas Maheshwari

Jun 25

Star Schema vs Snowflake Schema: Which to Use and When

#dataengineering #database #sql #datascience

4 min read

Jun 25

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

#database #performance #sql #tutorial

2 min read

Dane Wu

Jun 25

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

#rails #database #sql #performance

7 min read

Jun 25

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

#database #mongodb #node #npm

2 min read

Kanishga Subramani

Jun 25

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

#clickhouse #analytics #devops #database

4 min read

Jun 25

HABTM, has_many through, STI, and polymorphic associations in Rails

#rails #activerecord #associations #database

4 min read

Serina

Jun 25

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

#ai #database #llm #sql

8 min read

Jun 25

Encrypting Room SQLite Databases with SQLCipher and Biometric Keys

#android #security #kotlin #database

2 min read

Jun 25

Your Database Will Be Breached Someday. The Question Is: Will Passwords Be Inside?

#cybersecurity #database #infosec #security

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.