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.

Mar 26

SQLite Can Do More Than You Think — Full-Text Search, JSON, Window Functions, and 281TB Databases

#database #python #beginners #tutorial

2 min read

Mar 26

SQLite Is Enough for Your Side Project — Full-Text Search, JSON, and WAL Mode Included

#database #python #webdev #tutorial

2 min read

Mar 26

DuckDB Changed How I Process CSV Files — 7 Queries That Replace pandas

#python #database #datascience #tutorial

2 min read

Mar 25

Unpopular Opinion: You Don't Need a Database for Most Side Projects

#discuss #webdev #python #database

3 min read

Mar 25

DuckDB Just Made SQLite Look Slow — Run Analytics on CSVs Without a Database

#python #database #tutorial #productivity

3 min read

Mar 25

SQLite Just Got Vector Search — Here's How to Use It for AI (No Database Server Needed)

#ai #python #database #tutorial

4 min read

Mar 25

Why I Store All My Scraped Data in SQLite (Not JSON, Not CSV)

#discuss #python #database #beginners

4 min read

Feb 19

How to Generate a UUID Online (And When You Should Use One)

#beginners #database #programming #tutorial

3 min read

Mar 25

The Modern Data Engineering Stack in 2026: Every Tool You Actually Need

#dataengineering #python #database #productivity

3 min read

Mar 14

Stop Leaking Your Database Logic: The Repository Pattern 🏗️

#architecture #backend #database #softwareengineering

2 min read

Kjudeh

Feb 19

Your PostgreSQL Backups Are Probably Broken (Here's How to Know for Sure)

#postgres #database #devops #backend

2 min read

Tanishka V

Mar 24

SQL Fundamentals: Solving Real Database Queries Step by Step

#beginners #database #sql #tutorial

2 min read

Mar 25

SQL Queries You'll Use Every Day (But Nobody Teaches in Tutorials)

#database #sql #tutorial #beginners

3 min read

Githinji Victor Maina

Mar 4

🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)

#sql #database #datascience #beginners

3 min read

楊東霖

Mar 25

SQL Joins Explained: INNER, LEFT, RIGHT, FULL, and More

#sql #database #programming #tools

6 min read

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