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.
Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours
marcus1968 profile

Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours

#sql #sqlserver #xml #database
Comments
41 min read
From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing
rishabhrawat05 profile

From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing

#csharp #database #performance #mysql
Comments
2 min read
Why Your Redis Values Look Like Garbage in Every GUI (and How to Fix It)
hepengju profile

Why Your Redis Values Look Like Garbage in Every GUI (and How to Fix It)

#redis #java #opensource #database
Comments
7 min read
New Package Release
mayank040902 profile

New Package Release

#backend #database #opensource #typescript
Comments
1 min read
How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes
lingamsuyambu profile

How to Fix SQL Server Deadlocks: Causes, Detection and Real Fixes

#sql #sqlserver #database #performance
Comments
4 min read
A support desk on one small server: sizing, backups and the boring parts
imonitorsoft profile

A support desk on one small server: sizing, backups and the boring parts

#database #devops #infrastructure
Comments
3 min read
One Customer Request Across Website, CRM and AI Adviser
iagassets profile

One Customer Request Across Website, CRM and AI Adviser

#architecture #database
Comments
3 min read
Late facts shouldn't overwrite newer ones: handling out-of-order state in a temporal knowledge graph
ada_cognitia profile

Late facts shouldn't overwrite newer ones: handling out-of-order state in a temporal knowledge graph

#database #architecture #llm #ai
Comments
3 min read
Generated SQL migrations for Python, TypeScript and Go projects
fsmutimeer profile

Generated SQL migrations for Python, TypeScript and Go projects

#python #typescript #go #database
Comments
9 min read
Stop using ddl-auto=update in production
fsmutimeer profile

Stop using ddl-auto=update in production

#java #springboot #postgres #database
Comments
8 min read
Migrax vs Flyway: generated vs hand-written migrations
fsmutimeer profile

Migrax vs Flyway: generated vs hand-written migrations

#java #flyway #database #postgres
Comments
5 min read
Catching schema drift before it breaks production
fsmutimeer profile

Catching schema drift before it breaks production

#java #postgres #database #devops
Comments
6 min read
I made ER diagrams with the fewest line crossings, and proved it
quodline profile

I made ER diagrams with the fewest line crossings, and proved it

#showdev #python #opensource #database
1
Comments
5 min read
The biggest delete in our app is one line of raw SQL against a table our ORM does not manage
daniel_pertu profile

The biggest delete in our app is one line of raw SQL against a table our ORM does not manage

#postgres #database #webdev #typescript
Comments
6 min read
Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON
daniel_pertu profile

Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON

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