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.
SQL vs NoSQL for SaaS Platforms Which One to Choose

SQL vs NoSQL for SaaS Platforms Which One to Choose

Comments
4 min read
БД5 Практ (View)

БД5 Практ (View)

Comments
1 min read
How Databases Give Structure to Data

How Databases Give Structure to Data

15
Comments
4 min read
Data Security in SQL: Encryption, Roles, and Permissions

Data Security in SQL: Encryption, Roles, and Permissions

Comments
2 min read
Stop Querying Production DBs for Analytics (Build a Warehouse)

Stop Querying Production DBs for Analytics (Build a Warehouse)

Comments
1 min read
map

map

Comments
1 min read
I Built a Tool Because I Was Tired of Guessing Database Schemas

I Built a Tool Because I Was Tired of Guessing Database Schemas

7
Comments 1
2 min read
Quantum Leaps in Transactional Databases: Navigating the Future of Data Integrity

Quantum Leaps in Transactional Databases: Navigating the Future of Data Integrity

Comments
2 min read
Como Suportar Busca Não Estruturada em Banco de Dados Relacional Usando LLM

Como Suportar Busca Não Estruturada em Banco de Dados Relacional Usando LLM

1
Comments
4 min read
SQL 을 조금 더 알아보자

SQL 을 조금 더 알아보자

Comments
1 min read
Part 1: What a Backend Really Is (A Gentle Introduction)

Part 1: What a Backend Really Is (A Gentle Introduction)

Comments
4 min read
SeaORM 2.0: Nested ActiveModel

SeaORM 2.0: Nested ActiveModel

Comments
10 min read
Mandatory Profile in Oracle Database

Mandatory Profile in Oracle Database

Comments
3 min read
Snapshots & Data-RESTORE: Vector-Database: Qdrant-Cluster

Snapshots & Data-RESTORE: Vector-Database: Qdrant-Cluster

Comments
7 min read
1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
Junior Me: ‘I’ll just add a class_group_id to enrollment’ Future me looking at 2023 data: ‘why is this broken’

Junior Me: ‘I’ll just add a class_group_id to enrollment’ Future me looking at 2023 data: ‘why is this broken’

Comments
2 min read
The Empty Box Problem in Laravel Migrations (And why I stopped using default strings)

The Empty Box Problem in Laravel Migrations (And why I stopped using default strings)

Comments 4
2 min read
How to Backup and Restore a Single PostgreSQL Table with pg_dump

How to Backup and Restore a Single PostgreSQL Table with pg_dump

Comments
5 min read
Dataverse Capacity Migration Checklist (2025 Update)

Dataverse Capacity Migration Checklist (2025 Update)

Comments
2 min read
PostgreSQL DBA Path: Setup, Table Creation, and Database Maintenance Labs

PostgreSQL DBA Path: Setup, Table Creation, and Database Maintenance Labs

Comments
2 min read
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

15
Comments 1
3 min read
Log Databases Done Right

Log Databases Done Right

Comments
5 min read
LSM-Trees, NVMe SSDs, and Modern Storage Realities

LSM-Trees, NVMe SSDs, and Modern Storage Realities

10
Comments
3 min read
Optimizing a 40-Year-Old Government Database: From 3s to 30ms

Optimizing a 40-Year-Old Government Database: From 3s to 30ms

2
Comments
2 min read
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

10
Comments
3 min read
loading...