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.
Best Dimensional Data Modeling Tools: erwin Data Modeler Features & Alternatives

Best Dimensional Data Modeling Tools: erwin Data Modeler Features & Alternatives

Comments
11 min read
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

Comments
2 min read
Scaling Firebase for Growing Mobile Apps

Scaling Firebase for Growing Mobile Apps

Comments
5 min read
Your Full-Stack Project Doesn't Need Four Databases. Mine Did, and I'd Do It Differently Now.

Your Full-Stack Project Doesn't Need Four Databases. Mine Did, and I'd Do It Differently Now.

Comments
2 min read
Power BI Data Connectivity: Connecting, Importing, and Integrating Data from Multiple Sources

Power BI Data Connectivity: Connecting, Importing, and Integrating Data from Multiple Sources

5
Comments
8 min read
I picked MongoDB on day one. By month eight I needed Postgres.

I picked MongoDB on day one. By month eight I needed Postgres.

Comments
4 min read
The network died mid-sale. The customer still had cash in her hand.

The network died mid-sale. The customer still had cash in her hand.

Comments
7 min read
The column that existed on staging and not on production

The column that existed on staging and not on production

Comments
8 min read
The afternoon my teammate lost to a stale generated client

The afternoon my teammate lost to a stale generated client

Comments
6 min read
The same models, on a phone with no signal

The same models, on a phone with no signal

Comments
7 min read
I Built a Crash-Safe Key-Value Store Without sqlite3 — Then I Killed It

I Built a Crash-Safe Key-Value Store Without sqlite3 — Then I Killed It

Comments
9 min read
The rollback that could not undo the migration

The rollback that could not undo the migration

Comments
2 min read
Keeping Every Row Forever Is a Decision, Not a Default

Keeping Every Row Forever Is a Decision, Not a Default

Comments
2 min read
How to return top-N from each group with GROUP_CONCAT()

How to return top-N from each group with GROUP_CONCAT()

Comments
6 min read
Cache Avalanche: When Your Cache Fails and Your Database Pays the Price

Cache Avalanche: When Your Cache Fails and Your Database Pays the Price

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