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.
CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

Comments
3 min read
Laravel SQLSTATE HY000 2002 Connection Refused: Solved

Laravel SQLSTATE HY000 2002 Connection Refused: Solved

Comments
6 min read
When the Disparate Must Become One: On Honest Distributed Systems

When the Disparate Must Become One: On Honest Distributed Systems

Comments
2 min read
Piercing the Corporate Veil: How We Built an Autonomous Debtor Syndicate Graph with TigerGraph & Next.js

Piercing the Corporate Veil: How We Built an Autonomous Debtor Syndicate Graph with TigerGraph & Next.js

1
Comments
2 min read
7 Common Data Governance Challenges Every Business Should Know

7 Common Data Governance Challenges Every Business Should Know

Comments 1
5 min read
Supabase for Beginners: A Backend You Can Set Up Without Managing a Server

Supabase for Beginners: A Backend You Can Set Up Without Managing a Server

Comments 1
2 min read
Engineering Scalable Event Ticketing: Concurrency, Database Design, and Payment Flows

Engineering Scalable Event Ticketing: Concurrency, Database Design, and Payment Flows

Comments
5 min read
Modelling Environmental Monitoring in a Food ERP: Sampling Sites, Swab Results and the Workflow a Positive Should Trigger

Modelling Environmental Monitoring in a Food ERP: Sampling Sites, Swab Results and the Workflow a Positive Should Trigger

Comments
5 min read
My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

My open-source text-to-SQL layer is #1 on BIRD Mini-Dev in all three dialects

Comments
1 min read
Deleting one user row empties 21 of our 29 tables, and the delete statement names one of them

Deleting one user row empties 21 of our 29 tables, and the delete statement names one of them

1
Comments 1
5 min read
MCP Postgres Guard: Preventing SQL Injections and Slow Queries in AI Agents

MCP Postgres Guard: Preventing SQL Injections and Slow Queries in AI Agents

Comments
1 min read
SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order

SQL EXISTS vs JOIN: Find Customers Who Have Placed an Order

Comments
3 min read
GBase Database(GBase 8a): How to Fix GCware Add-Node Failures

GBase Database(GBase 8a): How to Fix GCware Add-Node Failures

2
Comments
3 min read
GBase Database(GBase 8a) Installation: 4 Ways to Troubleshoot SSH Login Failures

GBase Database(GBase 8a) Installation: 4 Ways to Troubleshoot SSH Login Failures

2
Comments
2 min read
How to Uninstall GBase Database(GBase 8a): A 5-Step Clean Removal Guide

How to Uninstall GBase Database(GBase 8a): A 5-Step Clean Removal Guide

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