Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
I built an open-source encyclopedia of psychoactive substances with Next.js 16 — here's what I learned

I built an open-source encyclopedia of psychoactive substances with Next.js 16 — here's what I learned

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

Vectorless RAG: Entenda Como Fazer RAG Sem Vector Database

1
Comments
5 min read
From Queries to Bytecode: The Final Pieces of SQLite’s Frontend
Cover image for From Queries to Bytecode: The Final Pieces of SQLite’s Frontend

From Queries to Bytecode: The Final Pieces of SQLite’s Frontend

30
Comments 2
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
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
Scaling pgvector: Memory, Quantization, and Index Build Strategies
Cover image for 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.