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.
SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY
rahmanfrr profile

SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY

#sql #database #interview #beginners
Comments
5 min read
Postgres for local dev: one container, one Makefile
chloe_smith0104 profile

Postgres for local dev: one container, one Makefile

#database #devops #docker #postgres
Comments
3 min read
Why Package Managers Keep Trying to Use Git as a Database (And Why It Always Fails)
osibajo_inioluwa_74301be0 profile

Why Package Managers Keep Trying to Use Git as a Database (And Why It Always Fails)

#architecture #database #git #software
Comments
3 min read
I made PostgreSQL refuse to store a lie
sergiobm99 profile

I made PostgreSQL refuse to store a lie

#postgres #python #database #softwareengineering
Comments
3 min read
Day 15 — Caching ও Redis — শুধু Cache না, এটা আরও অনেক কিছু
mislam-dev profile

Day 15 — Caching ও Redis — শুধু Cache না, এটা আরও অনেক কিছু

#backend #database #performance #redis
Comments
2 min read
Designing a Single Customer Profile Across WhatsApp, IG, and Telegram
botsailorofficial profile

Designing a Single Customer Profile Across WhatsApp, IG, and Telegram

#architecture #database #ai #automation
1
Comments
8 min read
The Silent Performance Killer: Demystifying the N+1 Query Problem in Node.js
saurav_tb_pandey profile

The Silent Performance Killer: Demystifying the N+1 Query Problem in Node.js

#n1queryproblem #database #node #performance
Comments
3 min read
Drafts, audit logs, or 'don't': three ways platforms handle AI agent writes
mrkelly profile

Drafts, audit logs, or 'don't': three ways platforms handle AI agent writes

#ai #database #opensource #architecture
1
Comments 1
6 min read
💰 Building Spendwise: The Tech Behind an Intelligent Personal Finance Guard
salman_mohammad_53a9d63c2 profile

💰 Building Spendwise: The Tech Behind an Intelligent Personal Finance Guard

#backend #database #python #softwaredevelopment
Comments
3 min read
When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source
zoro7 profile

When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source

#backend #database #java #sql
Comments
26 min read
WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS
emkoki profile

WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS

#database #programming #sql
Comments
2 min read
Why I Keep My Database Layer Boring
devanshu_patil profile

Why I Keep My Database Layer Boring

#architecture #backend #database #softwareengineering
Comments
3 min read
🛠️ 𝗡𝗲𝘄 𝗶𝗻 𝗻𝟵𝟴-𝗺𝗮𝗴𝗲𝗿𝘂𝗻𝟮: 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝗱𝗯:𝗰𝗼𝗺𝗽𝗮𝘁𝗶𝗯𝗶𝗹𝗶𝘁𝘆!
cmuench profile

🛠️ 𝗡𝗲𝘄 𝗶𝗻 𝗻𝟵𝟴-𝗺𝗮𝗴𝗲𝗿𝘂𝗻𝟮: 𝗜𝗻𝘁𝗿𝗼𝗱𝘂𝗰𝗶𝗻𝗴 𝗱𝗯:𝗰𝗼𝗺𝗽𝗮𝘁𝗶𝗯𝗶𝗹𝗶𝘁𝘆!

#database #opensource #php #tools
Comments
1 min read
How Postgres 19 checks foreign keys without running SQL
nobody_4fb7fd10637d3b88a3 profile

How Postgres 19 checks foreign keys without running SQL

#postgres #database #internals #benchmarks
1
Comments
6 min read
Day 14 — Database Sharding — কোটি কোটি ডেটার টেবিলকে কীভাবে সামলাবেন?
mislam-dev profile

Day 14 — Database Sharding — কোটি কোটি ডেটার টেবিলকে কীভাবে সামলাবেন?

#architecture #database #performance #systemdesign
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.