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.
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

Comments
12 min read
MySQL Labs: Querying Country GNP, Manipulating Personnel Database Dates & Functions

MySQL Labs: Querying Country GNP, Manipulating Personnel Database Dates & Functions

Comments
3 min read
Database optimization best practices

Database optimization best practices

Comments
3 min read
A spanner-cli Contributor's Perspective on the Official Spanner CLI

A spanner-cli Contributor's Perspective on the Official Spanner CLI

Comments
12 min read
What are knowledge graphs and why is everyone talking about them?

What are knowledge graphs and why is everyone talking about them?

12
Comments
6 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

1
Comments
1 min read
Learning SQL for 30-days. Day 4.

Learning SQL for 30-days. Day 4.

Comments
1 min read
No pre-filtering in pgvector means reduced ANN recall

No pre-filtering in pgvector means reduced ANN recall

Comments
12 min read
[Share] SQLite

[Share] SQLite

Comments
4 min read
How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds

How I Optimized EF Core Query from 30 Seconds to 30 Milliseconds

Comments
14 min read
How to Bring SQL Database Online From Recovery Pending State

How to Bring SQL Database Online From Recovery Pending State

1
Comments 1
6 min read
Airtable Data Limit Reached: 3 Common Solutions

Airtable Data Limit Reached: 3 Common Solutions

Comments
8 min read
Real-time AI Unleashed: The Power of Time-Series and Vector Database Synergy

Real-time AI Unleashed: The Power of Time-Series and Vector Database Synergy

Comments
3 min read
🔐 How to Reset Your Forgotten PostgreSQL Password (Windows Guide)

🔐 How to Reset Your Forgotten PostgreSQL Password (Windows Guide)

5
Comments
3 min read
Supabase + Express + Drizzle ORM

Supabase + Express + Drizzle ORM

Comments
4 min read
The Scaling Gauntlet, Pt. 2: Connection Pooling and How to Stop DDoSing Yourself

The Scaling Gauntlet, Pt. 2: Connection Pooling and How to Stop DDoSing Yourself

Comments
6 min read
I Built a Database from Scratch in Go - Here's What I Learned About B+ Trees, ACID Transactions, and 1,800 ops/sec Performance 🚀

I Built a Database from Scratch in Go - Here's What I Learned About B+ Trees, ACID Transactions, and 1,800 ops/sec Performance 🚀

1
Comments
4 min read
Database Mastery: Hands-On Labs for Country GNP, Student Course Analysis & Stored Procedures

Database Mastery: Hands-On Labs for Country GNP, Student Course Analysis & Stored Procedures

Comments
2 min read
Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42

Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42

6
Comments 1
2 min read
Enterprise SQL Server Index Maintenance: Multi-Database Automation with Email Reporting

Enterprise SQL Server Index Maintenance: Multi-Database Automation with Email Reporting

Comments
3 min read
From MySQL to PostgreSQL: Enforcing Row-Level Security

From MySQL to PostgreSQL: Enforcing Row-Level Security

Comments
2 min read
PostgreSQL Practical Labs: Error Handling, Maintenance, and Performance Tuning

PostgreSQL Practical Labs: Error Handling, Maintenance, and Performance Tuning

Comments
2 min read
Mining Data Streams and Graph Mining

Mining Data Streams and Graph Mining

Comments
2 min read
Top 15 Must-Have Resources for DBA Security

Top 15 Must-Have Resources for DBA Security

Comments
6 min read
The MongoDB Role Pitfalls That Bit Me: Lessons in Multi-Customer Access Control

The MongoDB Role Pitfalls That Bit Me: Lessons in Multi-Customer Access Control

1
Comments
5 min read
loading...