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.
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
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
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
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
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
A Case for JCars Logistics Business
tim_kariuki325 profile

A Case for JCars Logistics Business

#analytics #data #database
Comments
3 min read
Technical Due Diligence Errors That Can Kill an M&A Deal
dextralabs profile

Technical Due Diligence Errors That Can Kill an M&A Deal

#ai #security #architecture #database
Comments
9 min read
How wine.co.za made an archive of about 145,000 records easier to search with Manticore Search
sanikolaev profile

How wine.co.za made an archive of about 145,000 records easier to search with Manticore Search

#database #search #mariadb #dotnet
5
Comments
4 min read
Race Condition on Concurrent Stock Updates
lukman-ss profile

Race Condition on Concurrent Stock Updates

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