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.
Why don’t my database numbers match? I built a tool to find out.
harrywynn profile

Why don’t my database numbers match? I built a tool to find out.

#database #webdev #programming #dataengineering
Comments
2 min read
PostgreSQL High Availability: A Practical Guide with Patroni and pgBouncer
instadevops profile

PostgreSQL High Availability: A Practical Guide with Patroni and pgBouncer

#postgres #database #devops #highavailability
Comments
6 min read
Migrating from Neon to Supabase (Postgres + Drizzle, in production)
blackie360 profile

Migrating from Neon to Supabase (Postgres + Drizzle, in production)

#database #nextjs #postgres #tutorial
Comments
7 min read
I built a 13-database ORM for Node.js because Prisma doesn't support Oracle
apolocine profile

I built a 13-database ORM for Node.js because Prisma doesn't support Oracle

#node #typescript #database #opensource
Comments
2 min read
Subqueries vs CTEs in SQL: A Complete Guide for Beginners
k1gen_ profile

Subqueries vs CTEs in SQL: A Complete Guide for Beginners

#beginners #database #sql #tutorial
Comments
8 min read
PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE
philip_mcclarence_2ef9475 profile

PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

#database #performance #postgres #sql
Comments
3 min read
Change tracking and soft delete: audit trails without the boilerplate
davidlastrucci profile

Change tracking and soft delete: audit trails without the boilerplate

#delphi #orm #database #opensource
Comments
4 min read
Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation
kanta13jp1 profile

Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

#supabase #postgres #buildinpublic #database
Comments
2 min read
Emergency Workaround When There’s No ER Diagram
tkuni profile

Emergency Workaround When There’s No ER Diagram

#database #erd #webdev #opensource
Comments
3 min read
I keep writing the same Pydantic-asyncpg wrapper. So I published it.
varjoranta profile

I keep writing the same Pydantic-asyncpg wrapper. So I published it.

#python #database #async #postgres
2
Comments
6 min read
How to Save Bloated MCP with Code Mode

Collapsing 2,500 endpoints into two tools
jiasheng profile
JS for ZenStack

How to Save Bloated MCP with Code Mode

#ai #webdev #agents #database
73
Comments 28
7 min read
Inventory Software Starts With Movement History
pytagotech profile

Inventory Software Starts With Movement History

#webdev #database #architecture #product
Comments
2 min read
How to Use Google Sheets as a Free Database with n8n
chasebot profile

How to Use Google Sheets as a Free Database with n8n

#n8n #googlesheets #database #automation
1
Comments
6 min read
Hands-On with Apache Iceberg Using Dremio Cloud
alexmercedcoder profile

Hands-On with Apache Iceberg Using Dremio Cloud

#cloud #database #dataengineering #tutorial
Comments
7 min read
SQL Functions You Will Actually Use in Data Work
muriuki_kahuthu_54 profile

SQL Functions You Will Actually Use in Data Work

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