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.
SQLite PRAGMA: The Underrated Lever That Controls Your DB

SQLite PRAGMA: The Underrated Lever That Controls Your DB

10
Comments 1
3 min read
How to Find and Kill Long-Running Queries in SQL Server

How to Find and Kill Long-Running Queries in SQL Server

1
Comments
3 min read
SQL Concepts and Practical Application

SQL Concepts and Practical Application

1
Comments
2 min read
Building a Multi-Terminal Restaurant POS with C# .NET — Architecture & Lessons

Building a Multi-Terminal Restaurant POS with C# .NET — Architecture & Lessons

1
Comments
4 min read
Beyond the Hype: Building a Practical AI Memory System with Vector Databases

Beyond the Hype: Building a Practical AI Memory System with Vector Databases

1
Comments
5 min read
Write Your SQL Like a Pro: Mastering Common Table Expressions (CTEs)

Write Your SQL Like a Pro: Mastering Common Table Expressions (CTEs)

1
Comments
5 min read
SQLite WAL Mode for Better Concurrent Web Performance

SQLite WAL Mode for Better Concurrent Web Performance

1
Comments
3 min read
We didn't want an AI SQL reviewer. We wanted deterministic

We didn't want an AI SQL reviewer. We wanted deterministic

1
Comments
5 min read
SQL CASE Expressions: Write Smarter Queries with Conditional Logic

SQL CASE Expressions: Write Smarter Queries with Conditional Logic

Comments
5 min read
I Built a 20-Hour DBMS Interview Prep System Using LLMs — Does It Actually Work?

I Built a 20-Hour DBMS Interview Prep System Using LLMs — Does It Actually Work?

Comments 2
2 min read
Local-First Vectors: How to Build Privacy-Preserving AI Apps without the Cloud

Local-First Vectors: How to Build Privacy-Preserving AI Apps without the Cloud

Comments
3 min read
A Beginner's Guide to SQL Joins and Window Functions

A Beginner's Guide to SQL Joins and Window Functions

1
Comments
6 min read
How We Query 16.8M SIRENE Establishments in 66ms

How We Query 16.8M SIRENE Establishments in 66ms

1
Comments
3 min read
Stop Passing *sql.Tx Through Your Go Service Layer

Stop Passing *sql.Tx Through Your Go Service Layer

Comments
3 min read
Scaling pgvector: Memory, Quantization, and Index Build Strategies

Scaling pgvector: Memory, Quantization, and Index Build Strategies

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