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.
Design semantic views around business questions, not agents
sudeephazra profile

Design semantic views around business questions, not agents

#agents #analytics #architecture #database
Comments 1
6 min read
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
woodfiresam profile
Sam

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

#database #debugging #sql
Comments
4 min read
Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency
usman_khan_io profile

Advanced System Architecture: Designing Multi-Region Read Replicas and Global Data Consistency

#architecture #postgres #database #distributedsystems
Comments
3 min read
The Empty SMALLINT Column That Led Me to Nine More Missing Types
caiderek profile

The Empty SMALLINT Column That Led Me to Nine More Missing Types

#database #debugging #sql
Comments
2 min read
MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting
abeamar profile

MSSQL EXTENDED EVENTS Stop Guessing and Start Targeting

#database #learning #sqlserver #tutorial
1
Comments
5 min read
Multi-Tenant Database Isolation: RLS, Schema-per-Tenant, and the Migration Wall
freddie_thompson_e0488262 profile

Multi-Tenant Database Isolation: RLS, Schema-per-Tenant, and the Migration Wall

#architecture #database #postgres #security
Comments
5 min read
Zero-Downtime Database Migration: The Dual-Write Window Is Where It Goes Wrong
freddie_thompson_e0488262 profile

Zero-Downtime Database Migration: The Dual-Write Window Is Where It Goes Wrong

#architecture #backend #database #systemdesign
Comments
5 min read
Model Allergens as Data, Not Label Text: Material Flags, Line State and Changeover Gates in a Food ERP
yit2022 profile

Model Allergens as Data, Not Label Text: Material Flags, Line State and Changeover Gates in a Food ERP

#erp #database #architecture #saas
Comments
5 min read
Why the heck Redis ?
ryanabdaul profile

Why the heck Redis ?

#backend #database #performance #redis
Comments
3 min read
MSSQL LEDGER TABLES Bulletproof Data Integrity and Authenticity
abeamar profile

MSSQL LEDGER TABLES Bulletproof Data Integrity and Authenticity

#database #learning #sql #sqlserver
Comments
4 min read
Amazon RDS Custom for Oracle: Root Access to Your DB Host Without Giving Up Managed Backups
arvind_toorpu profile

Amazon RDS Custom for Oracle: Root Access to Your DB Host Without Giving Up Managed Backups

#aws #oracle #rds #database
Comments
5 min read
Vortex TSDB: Live Metrics in One Command — HTTP Writes, Minute Aggregates, Sliding Windows, Replicated in Memory
paganini2008 profile

Vortex TSDB: Live Metrics in One Command — HTTP Writes, Minute Aggregates, Sliding Windows, Replicated in Memory

#backend #database #docker #opensource
Comments
5 min read
Building a High-Speed School Marketplace (Part 2): Multi-Role Security with Supabase RLS
juna_go15 profile

Building a High-Speed School Marketplace (Part 2): Multi-Role Security with Supabase RLS

#architecture #backend #database #security
Comments 3
5 min read
Landed cost is a join against a dated rule table, not a column
fulfillnexa profile
life

Landed cost is a join against a dated rule table, not a column

#backend #database #logistics #fulfillment
Comments
6 min read
DBML: The Small Language I Wish I'd Found Sooner
obare profile

DBML: The Small Language I Wish I'd Found Sooner

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