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.
PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

Comments
11 min read
SQL LIMIT and OFFSET: Paginate Your Query Results Like a Pro

SQL LIMIT and OFFSET: Paginate Your Query Results Like a Pro

Comments
5 min read
How Relational Fake Data Speeds Up Your Testing Workflow

How Relational Fake Data Speeds Up Your Testing Workflow

Comments
2 min read
SQL JOIN Tutorial: INNER, LEFT, RIGHT, FULL OUTER Explained

SQL JOIN Tutorial: INNER, LEFT, RIGHT, FULL OUTER Explained

Comments
6 min read
GopServer: Turn Any Database into a REST API in 3 Minutes

GopServer: Turn Any Database into a REST API in 3 Minutes

4
Comments
2 min read
Query Planning Overhead with Many Chunks (And How to Fix It)

Query Planning Overhead with Many Chunks (And How to Fix It)

Comments
4 min read
Why Data Teams Need Data Lineage: From Common Pain Points to Real-World Challenges

Why Data Teams Need Data Lineage: From Common Pain Points to Real-World Challenges

1
Comments
4 min read
I Replaced SQLite with a Rust Database in My AI Robot — Here's What Happened

I Replaced SQLite with a Rust Database in My AI Robot — Here's What Happened

3
Comments 1
4 min read
Why SQLite Is a Poor Fit for Production Strapi Applications

Why SQLite Is a Poor Fit for Production Strapi Applications

Comments
4 min read
LSM Trees (Log-Structured Merge-Trees)

LSM Trees (Log-Structured Merge-Trees)

1
Comments
9 min read
ETL vs ELT: The Data Pipeline Behind Every Powerful Dashboard

ETL vs ELT: The Data Pipeline Behind Every Powerful Dashboard

2
Comments
4 min read
MCP-Manticore: Let Your AI Assistant Write Manticore Queries for You

MCP-Manticore: Let Your AI Assistant Write Manticore Queries for You

1
Comments
6 min read
Understanding SQL: DDL, DML, Filtering, and CASE WHEN

Understanding SQL: DDL, DML, Filtering, and CASE WHEN

1
Comments
3 min read
Apache Data Lakehouse Weekly: March 3–10, 2026

Apache Data Lakehouse Weekly: March 3–10, 2026

1
Comments
5 min read
How I Added Memory to an AI Agent Using Spring AI and Oracle AI Database

How I Added Memory to an AI Agent Using Spring AI and Oracle AI Database

Comments
10 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.