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.
Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes
amujo_elijah_333ac2135b66 profile

Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes

#django #postgres #database #python
Comments
6 min read
Best AI-Powered Data Modeling Tools (2026)
naveensub profile

Best AI-Powered Data Modeling Tools (2026)

#ai #data #database #tools
Comments
11 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
Data Modelling, Relationships and Joins
victor_muyanzi_baac695cf9 profile

Data Modelling, Relationships and Joins

#analytics #data #database
Comments
7 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
# 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
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
Idempotency Part 2: The Backend Contract - Why ON CONFLICT Is Not Enough
suprie_32 profile
Suprie

Idempotency Part 2: The Backend Contract - Why ON CONFLICT Is Not Enough

#architecture #backend #database #postgres
Comments 1
6 min read
Turning phone update policies into dates: precision, minimums and sources
shekh_firoj_6217570f10c6c profile

Turning phone update policies into dates: precision, minimums and sources

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