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.
How I Designed & Tested a Production-Ready SQL Server Database Schema for ERP Systems
wael_ezzat_hafez profile

How I Designed & Tested a Production-Ready SQL Server Database Schema for ERP Systems

#architecture #backend #database #sql
Comments
1 min read
Orion AI: How Cornerstone OnDemand Cut Database Diagnosis by 78% with a Three-Agent System on Amazon Bedrock
mech_app_ai profile

Orion AI: How Cornerstone OnDemand Cut Database Diagnosis by 78% with a Three-Agent System on Amazon Bedrock

#ai #automation #aws #database
1
Comments 1
4 min read
Replay the Feed, Never a Duplicate: Idempotent Upserts in MySQL
bryan_hamilton profile

Replay the Feed, Never a Duplicate: Idempotent Upserts in MySQL

#mysql #php #database #webdev
Comments
3 min read
Why your tests don't catch N+1 queries (and how to make them)
maciejziel profile

Why your tests don't catch N+1 queries (and how to make them)

#database #performance #python #testing
Comments
8 min read
Rework Flows Backwards: Modelling Rework Lots, Allergen Rules and Recursive Traceability in a Food ERP
yit2022 profile

Rework Flows Backwards: Modelling Rework Lots, Allergen Rules and Recursive Traceability in a Food ERP

#erp #database #architecture #startup
Comments
5 min read
I built and 100% tested an enterprise SQL Server database foundation for ERP systems [ApexLedger ERP]
wael_ezzat_hafez profile

I built and 100% tested an enterprise SQL Server database foundation for ERP systems [ApexLedger ERP]

#showdev #sql #database #architecture
Comments 1
1 min read
Promotion - Oracle ASM
technonotes profile

Promotion - Oracle ASM

#architecture #database #infrastructure
Comments
6 min read
Two-Phase Commit in the Real World: Why It Blocks, How Spanner Fixed It, and What to Do When Things Break
deepkpat profile

Two-Phase Commit in the Real World: Why It Blocks, How Spanner Fixed It, and What to Do When Things Break

#architecture #backend #database #systemdesign
1
Comments
6 min read
Cadastral Data and Land Titling: Navigating Philippine RA 11573 and the 20-Year Rule
markanthonygarcia profile

Cadastral Data and Land Titling: Navigating Philippine RA 11573 and the 20-Year Rule

#productivity #database #tutorial
Comments
5 min read
Critical Limits Are Data, Deviations Are Events: Modelling HACCP CCP Monitoring and Batch Holds in a Food ERP
yit2022 profile

Critical Limits Are Data, Deviations Are Events: Modelling HACCP CCP Monitoring and Batch Holds in a Food ERP

#erp #database #architecture #startup
Comments
4 min read
MySQL max_user_connections Error on Shared Hosting: Fix
faizan050 profile

MySQL max_user_connections Error on Shared Hosting: Fix

#mysql #database #tutorial
Comments
12 min read
CircleCI was not hacked. Its database filled a disk with its own diary.
kashif_manzer profile

CircleCI was not hacked. Its database filled a disk with its own diary.

#devops #backend #database #networking
Comments
4 min read
704 lines of SQL, 66,007 lines of JSON, and the one migration Drizzle never generated
daniel_pertu profile

704 lines of SQL, 66,007 lines of JSON, and the one migration Drizzle never generated

#postgres #drizzle #typescript #database
Comments
4 min read
SQLite WAL Does Not Mean Unlimited Writers: A Practical Python Playbook
chenyuan20509 profile

SQLite WAL Does Not Mean Unlimited Writers: A Practical Python Playbook

#python #sqlite #database #backend
Comments
6 min read
A future revision should not change yesterday's data selection
mabdullah_built profile

A future revision should not change yesterday's data selection

#python #testing #database #tutorial
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.