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.
Best AI-Powered Data Modeling Tools (2026)
naveensub profile

Best AI-Powered Data Modeling Tools (2026)

#ai #data #database #tools
Comments
11 min read
Data Modelling, Relationships and Joins
victor_muyanzi_baac695cf9 profile

Data Modelling, Relationships and Joins

#analytics #data #database
Comments
7 min read
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT
megventure profile

"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT

#mysql #php #database #devops
Comments
4 min read
# SQL Joins: How to Combine Tables the Right Way
patrickomondi profile

# SQL Joins: How to Combine Tables the Right Way

#backend #database #sql #tutorial
Comments
3 min read
Why we built a five-database adapter layer (and what it cost in build time)
under_peaks profile

Why we built a five-database adapter layer (and what it cost in build time)

#webdev #database #opensource #architecture
Comments
3 min read
PostgreSQL vs MySQL: 7 syntax differences that break migrations
sharefun2023 profile

PostgreSQL vs MySQL: 7 syntax differences that break migrations

#postgres #mysql #database #sql
Comments
4 min read
Databases 101: Relational Modeling
sri2614 profile

Databases 101: Relational Modeling

#backend #architecture #webdev #database
Comments
9 min read
SQLite or PostgreSQL: one codebase, two engines, one env var
benjy33000 profile

SQLite or PostgreSQL: one codebase, two engines, one env var

#sqlite #postgres #go #database
Comments
4 min read
I Built an Audit Log Three Times. The First Two Lied to Me.
jufianto profile

I Built an Audit Log Three Times. The First Two Lied to Me.

#architecture #backend #database #softwareengineering
Comments 1
13 min read
Field Memory — Building a Persistent Memory Platform for Field Knowledge
thirneddi_pardhu_10e66e56 profile

Field Memory — Building a Persistent Memory Platform for Field Knowledge

#showdev #backend #database #webdev
1
Comments
1 min read
Redis 8.4's digest-based SET option cuts a 1MB compare-and-set from 4.3ms to 1.6ms
alexgeorgiev17 profile

Redis 8.4's digest-based SET option cuts a 1MB compare-and-set from 4.3ms to 1.6ms

#redis #database #performance #devops
10
Comments 2
7 min read
The NOT IN trap: why your SQL query returns zero rows
sharefun2023 profile

The NOT IN trap: why your SQL query returns zero rows

#sql #database #postgres #mysql
Comments
3 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N
sharefun2023 profile

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

#sql #database #postgres #mysql
Comments
4 min read
SensorFlow vs Countly in 2026: Analytics Application or SDK-to-ClickHouse Pipeline?
sensorflow profile

SensorFlow vs Countly in 2026: Analytics Application or SDK-to-ClickHouse Pipeline?

#analytics #opensource #database
Comments
5 min read
Running a SaaS in Production: 5 Hard‑Earned Lessons
ntty profile
Ntty

Running a SaaS in Production: 5 Hard‑Earned Lessons

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