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 Do PostgreSQL Indices Work, Anyways?

How Do PostgreSQL Indices Work, Anyways?

7
Comments
6 min read
GBase 8s Trigger with Stored Procedure Example

GBase 8s Trigger with Stored Procedure Example

2
Comments
2 min read
Fixing Slow MongoDB Queries on Array Fields Using `$elemMatch`

Fixing Slow MongoDB Queries on Array Fields Using `$elemMatch`

2
Comments
2 min read
Inside SQLite’s Frontend: How the WHERE Clause Drives Optimization

Inside SQLite’s Frontend: How the WHERE Clause Drives Optimization

19
Comments
5 min read
Como Usar Supabase CLI: Guia Completo para Desenvolvedores (2026)

Como Usar Supabase CLI: Guia Completo para Desenvolvedores (2026)

1
Comments
10 min read
Connecting power bi to SQL databases locally and through cloud service.

Connecting power bi to SQL databases locally and through cloud service.

3
Comments
5 min read
Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

Next.js 16 SaaS Database Schema with Prisma: Users, Subscriptions, and AI Chat

1
Comments 1
3 min read
วิธีใช้ Supabase CLI: คู่มือพัฒนาฉบับสมบูรณ์ (2026)

วิธีใช้ Supabase CLI: คู่มือพัฒนาฉบับสมบูรณ์ (2026)

1
Comments
5 min read
MongoDB vs MySQL: Choosing the Right Database for Your Project

MongoDB vs MySQL: Choosing the Right Database for Your Project

17
Comments 1
7 min read
Ujorm3: A New Lightweight ORM for JavaBeans and Records

Ujorm3: A New Lightweight ORM for JavaBeans and Records

Comments 2
5 min read
Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

Inside SQLite’s Frontend: How the Query Optimizer Makes Your SQL Fast

22
Comments 4
5 min read
We're d-band — Here's Why We Build Open-Source Tools

We're d-band — Here's Why We Build Open-Source Tools

Comments
3 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

Comments
6 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

3
Comments
5 min read
Number Guessing Game

Number Guessing Game

1
Comments 1
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.