Skip to content

DEV Community

Database

Posts on building, using, and learning about databases.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Ella

Apr 11

Why PostgreSQL Ignores Your Index (Sometimes), Entry #2

#tutorial #database #productivity #postgres

3 min read

Toprak

Mar 8

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

#nextjs #opensource #webdev #database

2 min read

Athreya aka Maneshwar

Apr 10

SQLite PRAGMA: The Underrated Lever That Controls Your DB

#database #architecture

3 min read

Mar 8

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

#database #performance #sql #tutorial

3 min read

Noel Mwami

Apr 11

SQL Concepts and Practical Application

#beginners #database #sql #tutorial

2 min read

Mar 9

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

#dotnet #csharp #architecture #database

4 min read

Midas126

Mar 30

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

#ai #machinelearning #database #vectors

5 min read

Apr 10

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

#sql #database #tutorial #postgres

5 min read

Mar 7

SQLite WAL Mode for Better Concurrent Web Performance

#php #database #sqlite #performance

3 min read

Mar 7

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

#postgres #database #ai #devops

5 min read

Apr 10

SQL CASE Expressions: Write Smarter Queries with Conditional Logic

#sql #database #tutorial #webdev

5 min read

Apr 10

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

#interview #database #backend #ai

2 min read

Dencio

Apr 10

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

#rust #webassembly #reactnative #database

3 min read

Ng'ang'a Njongo

Mar 7

A Beginner's Guide to SQL Joins and Window Functions

#database #sql #dataengineering #datascience

6 min read

bennaceur walid

Mar 7

How We Query 16.8M SIRENE Establishments in 66ms

#postgressql #database #performance #api

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.