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.
What Happens When Two Databases Both Say Yes

What Happens When Two Databases Both Say Yes

28
Comments
15 min read
The migration that shipped with the code and locked the table for eleven minutes

The migration that shipped with the code and locked the table for eleven minutes

Comments
2 min read
PATM: Handle SQL-based databases and provide useful tools and workflows, all in one app!

PATM: Handle SQL-based databases and provide useful tools and workflows, all in one app!

Comments
1 min read
Data Relationships, Data Modelling Schemas, and Joins in Power BI.

Data Relationships, Data Modelling Schemas, and Joins in Power BI.

Comments 1
17 min read
One Cell, Many Values: When a Column Holds a List

One Cell, Many Values: When a Column Holds a List

Comments
8 min read
Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

Why Using FLOAT for Financial Pipelines is a Silent $100k Trap (and How PostgreSQL NUMERIC Saves Your Ledger)

Comments
2 min read
The Memory Engine Will Become the Enterprise's Next Database

The Memory Engine Will Become the Enterprise's Next Database

Comments
7 min read
Close the Migration-Visibility Gap: SMS Alerts for Failed SQL Migrations in 280 Lines of Python

Close the Migration-Visibility Gap: SMS Alerts for Failed SQL Migrations in 280 Lines of Python

Comments
5 min read
The Database That Tells You What It Knows

The Database That Tells You What It Knows

1
Comments
10 min read
Firestore Data Modeling for Offline-First React Native Apps

Firestore Data Modeling for Offline-First React Native Apps

1
Comments
6 min read
How to Master Intermediate SQL in Under 10 Minutes

How to Master Intermediate SQL in Under 10 Minutes

Comments
5 min read
The paginated export that silently skipped records every night

The paginated export that silently skipped records every night

Comments
2 min read
SQLite 3.53's SET NOT NULL replaces a full table rebuild with six writes

SQLite 3.53's SET NOT NULL replaces a full table rebuild with six writes

17
Comments
7 min read
My Roadmap to Becoming a Data Analyst

My Roadmap to Becoming a Data Analyst

Comments
1 min read
Email as a primary key is dead. Most apps don't know it yet

Email as a primary key is dead. Most apps don't know it yet

Comments 1
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.