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.
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
Vectorless RAG: Entenda Como Fazer RAG Sem Vector Database

Vectorless RAG: Entenda Como Fazer RAG Sem Vector Database

1
Comments
5 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.