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.
Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

Comments
10 min read
What is CDC in data engineering? Change data capture explained

What is CDC in data engineering? Change data capture explained

1
Comments
15 min read
Redis vs Valkey vs Dragonfly: Which In-Memory Store Should a New Project Use After the License Changes?

Redis vs Valkey vs Dragonfly: Which In-Memory Store Should a New Project Use After the License Changes?

Comments
6 min read
general_log = 1 writes every query to a file, including the passwords in them

general_log = 1 writes every query to a file, including the passwords in them

Comments
3 min read
UUID v4 vs v7: which one should you use?

UUID v4 vs v7: which one should you use?

Comments
6 min read
`SELECT * FROM DUAL` - The Lore of Oracle DB's Weirdest Table

`SELECT * FROM DUAL` - The Lore of Oracle DB's Weirdest Table

Comments
3 min read
Building NornicDB With NornicDB: Code Graphs and Swarms

Building NornicDB With NornicDB: Code Graphs and Swarms

Comments
6 min read
Your Pagination Is Showing Users the Same Item Twice (and Skipping Others). Here's Why Offset Breaks

Your Pagination Is Showing Users the Same Item Twice (and Skipping Others). Here's Why Offset Breaks

Comments
4 min read
A Gift Card Balance Is a Projection, Not Just a Number

A Gift Card Balance Is a Projection, Not Just a Number

Comments
2 min read
ÂżCĂłmo hacer migraciones de esquema en ClickHouse? Probamos chkit, el Drizzle que le faltaba âś… yoDEV Tested

ÂżCĂłmo hacer migraciones de esquema en ClickHouse? Probamos chkit, el Drizzle que le faltaba âś… yoDEV Tested

Comments
9 min read
Why SyteLine Says "Row Has Been Modified by Another User" (and How Optimistic Concurrency Works)

Why SyteLine Says "Row Has Been Modified by Another User" (and How Optimistic Concurrency Works)

Comments
3 min read
Model 19 CFR part 163 retention as several start-date fields

Model 19 CFR part 163 retention as several start-date fields

Comments
4 min read
Model a drawback claim as a state machine with statutory deadlines

Model a drawback claim as a state machine with statutory deadlines

Comments
5 min read
RLS was enabled and tenants could still read each other's data — the SECURITY DEFINER hole, and the query that catches it

RLS was enabled and tenants could still read each other's data — the SECURITY DEFINER hole, and the query that catches it

Comments
2 min read
Our plan limits have no counter column, the rows are the count, and a refund is a DELETE

Our plan limits have no counter column, the rows are the count, and a refund is a DELETE

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