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.
A 1000x Speedup From One Index — and Why It Sometimes Does Nothing
danewu profile

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

#rails #database #sql #performance
Comments
7 min read
Moving from Migrate Mongo to Mongo Migrate Kit (mmk) Without Re Running Old Migrations
santosh327 profile

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

#database #mongodb #node #npm
Comments
2 min read
Day 37: How to Handle Updates and Deletes in ClickHouse® (Mutations)
kanishga_subramani_49ad73 profile

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

#clickhouse #analytics #devops #database
1
Comments
4 min read
When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data
serina_8340 profile

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

#ai #database #llm #sql
5
Comments
8 min read
How We Built a Multi-Tenant SaaS Using SQLite and Node.js
arslan3535 profile

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

#webdev #javascript #database #sqlite
2
Comments 1
3 min read
Day 35 – ClickHouse® and S3 Integration: Querying Data Lakes
kanishga_subramani_49ad73 profile

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

#clickhouse #devops #analytics #database
2
Comments
4 min read
Encrypting Room SQLite Databases with SQLCipher and Biometric Keys
yadnyesh_rana profile

Encrypting Room SQLite Databases with SQLCipher and Biometric Keys

#android #security #kotlin #database
Comments
2 min read
Stop Pasting Raw CSVs Into ChatGPT: A Data Scientist's Guide to LLM Context Engineering
arian_mokhtariha_6206efac profile

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

#ai #machinelearning #database #data
Comments
5 min read
Exception-based attendance: stop storing a row for every student who showed up
irrationalapps profile

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

#architecture #flutter #firebase #database
Comments
3 min read
Fast at Lunch. Slow at Scale: Why Your App Gets Slow When Real Data Arrives
qodors profile

Fast at Lunch. Slow at Scale: Why Your App Gets Slow When Real Data Arrives

#dotnet #database #webdev #csharp
Comments
4 min read
v0.7.2: One of the biggest updates to py-auto-migrate
kasrakhaksar profile

v0.7.2: One of the biggest updates to py-auto-migrate

#python #opensource #database
Comments
1 min read
How Database Indexes Actually Work — From the Disk Up
elvis_n profile

How Database Indexes Actually Work — From the Disk Up

#computerscience #database #performance #tutorial
Comments
8 min read
Why Replit's AI Agent Deleted a Production Database
kris_joylo profile

Why Replit's AI Agent Deleted a Production Database

#agents #ai #database #production
1
Comments
4 min read
Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)
joy_mbugua_f9c6ecc05289ef profile

Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)

#sql #postgres #database #github
2
Comments
3 min read
Why I set `dynamic: false` on my Elasticsearch audit-log stream
econ__11 profile

Why I set `dynamic: false` on my Elasticsearch audit-log stream

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