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.
Claprec: Database Design - Modeling the Data (5/6)
keno_sej profile

Claprec: Database Design - Modeling the Data (5/6)

#database #mssql #entityframeworkcore #dotnet
9
Comments
9 min read
How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)
vivekdraxlr profile

How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

#sql #database #ai #tutorial
Comments
6 min read
Building a Rock‑Solid HA Strategy for GBase 8a: From Cluster Architecture and Failover to Consistency Repair
michaelfv profile

Building a Rock‑Solid HA Strategy for GBase 8a: From Cluster Architecture and Failover to Consistency Repair

#gbase #database #数据库 #consistency
Comments
6 min read
Fixing an email confirmation problem in Supabase
kansoldev profile

Fixing an email confirmation problem in Supabase

#database #learning #supabase
Comments
4 min read
GBase 8a Data Sync in Practice: T+1 Replication, Real‑Time Mirroring, and Write‑Once‑Read‑Many
michaelfv profile

GBase 8a Data Sync in Practice: T+1 Replication, Real‑Time Mirroring, and Write‑Once‑Read‑Many

#gbase #database #数据库 #replication
Comments
4 min read
Learning SQL As If You Built It Yourself
edriso profile

Learning SQL As If You Built It Yourself

#learning #database #sql
1
Comments
12 min read
Three Durability Modes, One WAL: Configurable Guarantees for Different Workloads
nockawa profile

Three Durability Modes, One WAL: Configurable Guarantees for Different Workloads

#csharp #dotnet #database #durability
Comments
8 min read
Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘
bright98 profile

Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘

#postgres #go #cli #database
Comments
4 min read
Secure Database Access for AI Agents: Building an MCP Server with SQLatte
osmanuygar profile

Secure Database Access for AI Agents: Building an MCP Server with SQLatte

#ai #mcp #database #security
1
Comments 1
6 min read
How GBase 8a Rough Index Works: Block‑Level Pruning for 10x Faster Queries
michaelfv profile

How GBase 8a Rough Index Works: Block‑Level Pruning for 10x Faster Queries

#gbase #database #数据库 #performance
Comments
2 min read
Oracle Database Performance Monitoring: A Practitioner's Decision Framework
damasosanoja profile

Oracle Database Performance Monitoring: A Practitioner's Decision Framework

#backend #database #monitoring #performance
Comments
20 min read
Debugging Slow SQL in GBase 8a: How Execution Plans, Distribution Keys, and Parallelism Go Off the Rails Together
michaelfv profile

Debugging Slow SQL in GBase 8a: How Execution Plans, Distribution Keys, and Parallelism Go Off the Rails Together

#gbase #database #数据库 #parallelism
Comments
5 min read
Meet Top Salesforce Connectors for ADO.NET and .NET Projects
dbdeveloper profile

Meet Top Salesforce Connectors for ADO.NET and .NET Projects

#salesforce #database #adonet
Comments
4 min read
Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis
manveer_chawla_64a7283d5a profile

Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis

#database #sql #dataengineering #data
6
Comments
31 min read
Why NornicDB Uses Its Own Monotonic Counter for MVCC Ordering
orneryd profile

Why NornicDB Uses Its Own Monotonic Counter for MVCC Ordering

#database #go #performance #systemdesign
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.