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.
My AI directory has 92 categories. Ten of them hold 37% of the listings.

My AI directory has 92 categories. Ten of them hold 37% of the listings.

Comments
3 min read
N+1 query problem in Hibernate and JPA: find it and fix it

N+1 query problem in Hibernate and JPA: find it and fix it

1
Comments
13 min read
.NET 10 + Pinecone: como integrar com um banco de dados vetorial

.NET 10 + Pinecone: como integrar com um banco de dados vetorial

Comments
12 min read
Rutba Data Files: twenty-five business templates, and the paperwork each one prints

Rutba Data Files: twenty-five business templates, and the paperwork each one prints

Comments
9 min read
CDC Schema Changes: What Breaks and How to Ship Them

CDC Schema Changes: What Breaks and How to Ship Them

Comments
7 min read
Read-Only Postgres Role for AI Agents: 7 Gaps to Close

Read-Only Postgres Role for AI Agents: 7 Gaps to Close

2
Comments 2
10 min read
Reading Complex XML in SQL Server — Shredding a Thousand Attributes Generically Instead of Looping for Hours

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

Comments
41 min read
From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing

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

Comments
2 min read
New Package Release

New Package Release

Comments
1 min read
A support desk on one small server: sizing, backups and the boring parts

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

Comments
3 min read
One Customer Request Across Website, CRM and AI Adviser

One Customer Request Across Website, CRM and AI Adviser

Comments
3 min read
Navicat Premium 18 on Linux: a hands-on review with Postgres, SQLite, Oracle and MySQL

Navicat Premium 18 on Linux: a hands-on review with Postgres, SQLite, Oracle and MySQL

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

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

Comments
3 min read
I made ER diagrams with the fewest line crossings, and proved it

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

1
Comments
5 min read
Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON

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

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