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.
The Real Cost of a Single Insert in Postgres
tigerdata_dev profile

The Real Cost of a Single Insert in Postgres

#postgres #database #developers #devops
Comments
7 min read
Memory efficiency: bytes per key
sunnysahijwani profile

Memory efficiency: bytes per key

#redis #database #performance #benchmarking
Comments 1
2 min read
Zero-Downtime Database Migrations: Lessons from GitLab's PostgreSQL Architecture
hrlpavan profile

Zero-Downtime Database Migrations: Lessons from GitLab's PostgreSQL Architecture

#postgres #gitlab #database #backend
Comments 1
4 min read
The FETCH FIRST story: from ROW_NUMBER() in 12c back to ROWNUM in 23ai, and a LIMIT equivalent for PostgreSQL
franckpachot profile

The FETCH FIRST story: from ROW_NUMBER() in 12c back to ROWNUM in 23ai, and a LIMIT equivalent for PostgreSQL

#oracle #database #sql #postgres
1
Comments
10 min read
We moved a production backend from a phone
vinaykumars profile

We moved a production backend from a phone

#ai #agents #cloud #database
23
Comments
3 min read
Zoho CRM duplicate records and double data entry: how to stop them
skyfall7 profile

Zoho CRM duplicate records and double data entry: how to stop them

#zoho #crm #data #database
Comments 3
3 min read
Database Indexing: The Performance Trick Nobody Explained Properly
anas_issath profile

Database Indexing: The Performance Trick Nobody Explained Properly

#database #sql #postgres #performance
1
Comments
9 min read
Oracle Autonomous AI Database 26ai: More Than Just a Database
abbassibai profile

Oracle Autonomous AI Database 26ai: More Than Just a Database

#ai #vectordatabase #database #json
Comments
5 min read
When an agent's question is a path, not a similarity score
manoj_kumargogula_4042c7 profile

When an agent's question is a path, not a similarity score

#cognodb #graphdatabase #ai #database
Comments
3 min read
Why Timestamps Lie in Distributed Systems (and How Logical Clocks Fix It)
numb_code_07 profile

Why Timestamps Lie in Distributed Systems (and How Logical Clocks Fix It)

#distributedsystems #backend #systemdesign #database
11
Comments 1
10 min read
Nile isolates Postgres tenants with a tenant_id column and one session variable
alexgeorgiev17 profile

Nile isolates Postgres tenants with a tenant_id column and one session variable

#postgres #database #security #saas
6
Comments 3
5 min read
SQL Window Functions 101
young_odhiambo profile

SQL Window Functions 101

#database #datascience #sql #postgres
2
Comments
2 min read
Postgres for everything hits a wall the moment dashboards get concurrent
adioof profile

Postgres for everything hits a wall the moment dashboards get concurrent

#database #performance #architecture #opinion
1
Comments 1
3 min read
Two Sources of Truth Will Always Disagree
sergueyasaelshinder profile

Two Sources of Truth Will Always Disagree

#sergueyasaelshinder #architecture #database #cleancode
Comments
2 min read
Cheat Sheet: SQL Query Interview Questions
roydevashish profile

Cheat Sheet: SQL Query Interview Questions

#sql #database #programming #interview
1
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.