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.
Database Indexing: The Hidden Key to Application Speed

Database Indexing: The Hidden Key to Application Speed

1
Comments
2 min read
Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀

Relational vs Non-Relational Databases: Choosing the Right One for Your Dream Project 🚀

4
Comments
3 min read
SQL Server Ledger Tables: Complete Guide with Banking Example

SQL Server Ledger Tables: Complete Guide with Banking Example

Comments
3 min read
MongoDB Multikey Indexes and Index Bound Optimization

MongoDB Multikey Indexes and Index Bound Optimization

1
Comments
8 min read
🚀 Day 17 of My Python Learning Journey

🚀 Day 17 of My Python Learning Journey

Comments
1 min read
Part 4: MySQL vs PostgreSQL - Transaction Processing and ACID Compliance

Part 4: MySQL vs PostgreSQL - Transaction Processing and ACID Compliance

1
Comments
10 min read
A Polished, Read‑Only Cloudflare D1 Explorer (Express + Vanilla JS)

A Polished, Read‑Only Cloudflare D1 Explorer (Express + Vanilla JS)

Comments 1
2 min read
Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Enforcing Row Level Security in Supabase: A Deep Dive into LockIn's Multi-Tenant Architecture

Comments 4
8 min read
Implementing Efficient Database Caching Strategies for High-Traffic Web Applications

Implementing Efficient Database Caching Strategies for High-Traffic Web Applications

Comments
15 min read
🔒 Database System Design: Transaction Isolation Levels

🔒 Database System Design: Transaction Isolation Levels

3
Comments
2 min read
🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡

🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡

18
Comments 10
7 min read
How to Design a Multilingual Database Structure | A Practical Guide

How to Design a Multilingual Database Structure | A Practical Guide

2
Comments 1
7 min read
Part 3 - MySQL vs PostgreSQL: Features & Capabilities Comparison

Part 3 - MySQL vs PostgreSQL: Features & Capabilities Comparison

1
Comments
8 min read
Why Your Database Gives Up When Traffic Spikes (And What to Do About It)

Why Your Database Gives Up When Traffic Spikes (And What to Do About It)

1
Comments 1
6 min read
CRUD Operations in MongoDB for Beginners

CRUD Operations in MongoDB for Beginners

2
Comments
2 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
JOIN the data analytics race: Apache Doris vs. ClickHouse, Databricks, and Snowflake

JOIN the data analytics race: Apache Doris vs. ClickHouse, Databricks, and Snowflake

Comments 1
6 min read
Laravel app was slow. Here's how I fixed it

Laravel app was slow. Here's how I fixed it

5
Comments 1
1 min read
A Beginner’s Journey with PostgreSQL

A Beginner’s Journey with PostgreSQL

2
Comments
3 min read
DataPump : Disabling the Use of Symbolic Links When Creating a Directory

DataPump : Disabling the Use of Symbolic Links When Creating a Directory

Comments
2 min read
Amazon Athena: análises SQL diretas no S3 – quando usar, quanto custa e quais os limites

Amazon Athena: análises SQL diretas no S3 – quando usar, quanto custa e quais os limites

Comments
6 min read
Mastering Debugging why APIs Slow & How to Solve

Mastering Debugging why APIs Slow & How to Solve

Comments
3 min read
From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

Comments
4 min read
Handle Large PostgreSQL Schemas with a GUI Tool

Handle Large PostgreSQL Schemas with a GUI Tool

6
Comments
3 min read
SQLite dot commands: change directory command

SQLite dot commands: change directory command

1
Comments
1 min read
loading...