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.
Expanding the Dataset: A Comprehensive Guide to SQL Joins and Window Functions
dennis_ogaka_2d188ab5bef7 profile

Expanding the Dataset: A Comprehensive Guide to SQL Joins and Window Functions

#beginners #database #sql #tutorial
1
Comments
3 min read
How SQLite Internals Connect Into One Unified System
lovestaco profile

How SQLite Internals Connect Into One Unified System

#webdev #programming #database #architecture
27
Comments 4
3 min read
I am building a Notebook Environment for SQL Inside a Database Client
debba profile

I am building a Notebook Environment for SQL Inside a Database Client

#sql #database #productivity #opensource
6
Comments
5 min read
Prisma vs Drizzle vs ZenStack: Choosing a TypeScript ORM in 2026
ymc9 profile
ymc9 for ZenStack

Prisma vs Drizzle vs ZenStack: Choosing a TypeScript ORM in 2026

#typescript #prisma #drizzle #database
30
Comments 2
12 min read
The Perfect Prisma Schema for a SaaS App (Next.js 16 + PostgreSQL)
huangyongshan46a11y profile

The Perfect Prisma Schema for a SaaS App (Next.js 16 + PostgreSQL)

#prisma #nextjs #database #saas
1
Comments
3 min read
Why I built a SQLite workbench in bash
fissible profile

Why I built a SQLite workbench in bash

#opensource #database #tooling #bash
Comments
2 min read
Why I Built a Multi-Paradigm Database in Rust — And Deployed It on 50+ Raspberry Pis
automatanexus profile

Why I Built a Multi-Paradigm Database in Rust — And Deployed It on 50+ Raspberry Pis

#rust #database #opensource #iot
1
Comments
15 min read
How to Explore and Work with MongoDB Data Visually
visualeaf profile

How to Explore and Work with MongoDB Data Visually

#mongodb #nosql #database #data
6
Comments
4 min read
How I Passed the DP-300 Exam by Improving My Preparation Approach
christopherlee2210 profile

How I Passed the DP-300 Exam by Improving My Preparation Approach

#azure #database #learning #microsoft
1
Comments 3
12 min read
How I Took Down Prod With a 400ms Migration (And The Playbook I Use Now)
practiceoverflow profile

How I Took Down Prod With a 400ms Migration (And The Playbook I Use Now)

#database #devjournal #devops #postgres
Comments
8 min read
ACID Properties in DBMS with Examples (Complete Guide)
nishilbhave profile

ACID Properties in DBMS with Examples (Complete Guide)

#database #acid #transactions #postgres
Comments
13 min read
pgvector Distance Functions: Cosine vs L2 vs Inner Product
philip_mcclarence_2ef9475 profile

pgvector Distance Functions: Cosine vs L2 vs Inner Product

#database #machinelearning #postgres #sql
1
Comments 1
3 min read
Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth
rebooter_s profile

Text-to-SQL Finally Gets Real: DySQL-Bench, BibSQL, DLBench Fix the 'Perfect Query' Myth

#ai #database #llm #sql
1
Comments
3 min read
Prepared statements in Manticore Search
sanikolaev profile

Prepared statements in Manticore Search

#backend #database #security #sql
Comments
7 min read
# Understanding Joins and Window Functions in SQL
john_analytics profile

# Understanding Joins and Window Functions in SQL

#sql #postgres #data #database
2
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.