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.
48-Hour Field Notes: I Replayed a Generated Migration Twice and the Row Counts Moved
codepy_1473 profile

48-Hour Field Notes: I Replayed a Generated Migration Twice and the Row Counts Moved

#ai #database #devops #testing
Comments
5 min read
Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same
daniel_pertu profile

Every line of a new support thread gets its own millisecond, because one transaction would stamp them all the same

#postgres #typescript #webdev #database
Comments
6 min read
Forty-one columns in our schema are enums in TypeScript and plain text in Postgres
daniel_pertu profile

Forty-one columns in our schema are enums in TypeScript and plain text in Postgres

#postgres #typescript #database #webdev
Comments
6 min read
Building Inventory Applications That Don’t Lose Track Of Their Inventory
memona07 profile

Building Inventory Applications That Don’t Lose Track Of Their Inventory

#architecture #backend #database #systemdesign
Comments
6 min read
Schema Evolution in Financial Data APIs: Versioning Without Breaking Consumers
snehawani21 profile

Schema Evolution in Financial Data APIs: Versioning Without Breaking Consumers

#ai #python #database #api
Comments 1
6 min read
Four ways I tried to ingest data for my League of Legends hobby project
siont profile

Four ways I tried to ingest data for my League of Legends hobby project

#webdev #architecture #database #data
2
Comments
7 min read
How to Detect Schema Drift Before Production Deployments
databaseinsights profile

How to Detect Schema Drift Before Production Deployments

#sql #sqlserver #database #devops
10
Comments 3
6 min read
Free Draft Volume or Paid First Passes: A Debate for Agent SQL Budgets
dataio_4921 profile

Free Draft Volume or Paid First Passes: A Debate for Agent SQL Budgets

#ai #sql #testing #database
Comments
6 min read
DBeaver SQL Summary Learning Notes
maditech profile

DBeaver SQL Summary Learning Notes

#database #postgres #sql #tutorial
Comments
4 min read
Fiber composition is a percentage array with an ordering rule
fulfillnexa profile
life

Fiber composition is a percentage array with an ordering rule

#database #backend #ecommerce #compliance
Comments
5 min read
Entry-time certificate data is a row with four reachable parties
fulfillnexa profile
life

Entry-time certificate data is a row with four reachable parties

#backend #database #logistics #compliance
Comments
5 min read
Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases
tejaswipandava profile

Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases

#architecture #database #sql
Comments
2 min read
MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)
mfaysaldev profile

MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

#mysql #sql #database #beginners
Comments
9 min read
Model Complaints as Batch Events, Not Support Tickets: Lot Links, Severity Triage and Hold Triggers in a Food ERP
yit2022 profile

Model Complaints as Batch Events, Not Support Tickets: Lot Links, Severity Triage and Hold Triggers in a Food ERP

#erp #database #architecture #saas
Comments
5 min read
Designing an Audit Trail for Attendance Edits Without Overwriting Source Events
insacheck profile

Designing an Audit Trail for Attendance Edits Without Overwriting Source Events

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