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.
🚀 Mastering Delta Encoding: The Secret to Smarter Data Compression 💡

🚀 Mastering Delta Encoding: The Secret to Smarter Data Compression 💡

3
Comments
3 min read
Calculate monthly account balance and fill in missing dates:From SQL to SPL

Calculate monthly account balance and fill in missing dates:From SQL to SPL

6
Comments
2 min read
Working with JSON in MySQL

Working with JSON in MySQL

4
Comments
3 min read
The Columnar Approach: A Deep Dive into Efficient Data Storage for Analytics 🚀

The Columnar Approach: A Deep Dive into Efficient Data Storage for Analytics 🚀

1
Comments
4 min read
Query Optimization: How the Query Optimizer Works Using Relational Algebra

Query Optimization: How the Query Optimizer Works Using Relational Algebra

23
Comments 2
5 min read
Resumo de conceitos de bancos de dados relacionais

Resumo de conceitos de bancos de dados relacionais

Comments
4 min read
SQL Query basicos.

SQL Query basicos.

Comments
4 min read
15 Databases, 15 Use Cases — The Ultimate Guide That No One Asked For (But Everyone Needs)

15 Databases, 15 Use Cases — The Ultimate Guide That No One Asked For (But Everyone Needs)

5
Comments
2 min read
A Quick Guide to SQL Data Modification Commands with Examples

A Quick Guide to SQL Data Modification Commands with Examples

2
Comments
3 min read
Introduction to SQL: Day 1 - A Beginner's Guide to Databases

Introduction to SQL: Day 1 - A Beginner's Guide to Databases

Comments
3 min read
Trying to predict the performance of file reads/writes

Trying to predict the performance of file reads/writes

9
Comments 1
10 min read
Real-Time Data Integration Techniques Using PostgreSQL Foreign Data Wrapper (FDW)

Real-Time Data Integration Techniques Using PostgreSQL Foreign Data Wrapper (FDW)

2
Comments
10 min read
How I Solved Common Prisma ORM Errors: Debugging Tips and Best Practices

How I Solved Common Prisma ORM Errors: Debugging Tips and Best Practices

Comments
5 min read
Building an LSM-Tree Storage Engine from Scratch

Building an LSM-Tree Storage Engine from Scratch

25
Comments 5
25 min read
Why You Should Use ORM Tools in Your Projects in 2025

Why You Should Use ORM Tools in Your Projects in 2025

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