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.
Snapshots & Data-RESTORE: Vector-Database: Qdrant-Cluster

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

Comments
7 min read
MSSQL Encryptions, Certificates, A-Symmetric Keys and more (Vol 1)

MSSQL Encryptions, Certificates, A-Symmetric Keys and more (Vol 1)

Comments
5 min read
Inside SQLite Backend: Virtual Machine, Storage, and the Build Process

Inside SQLite Backend: Virtual Machine, Storage, and the Build Process

12
Comments
3 min read
Inside the SQLite Frontend: Tokenizer, Parser, and Code Generator

Inside the SQLite Frontend: Tokenizer, Parser, and Code Generator

21
Comments
4 min read
SQL Server Indexes Explained: Column Order, INCLUDE, and the Mistakes That Taught Me

SQL Server Indexes Explained: Column Order, INCLUDE, and the Mistakes That Taught Me

3
Comments
14 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
[Simple SNS Project] Step 4. Search Implementation & Logging Strategy

[Simple SNS Project] Step 4. Search Implementation & Logging Strategy

Comments
1 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
We’re Launching Vizora (Private Beta) — Paste Your DB Schema, Understand It Instantly

We’re Launching Vizora (Private Beta) — Paste Your DB Schema, Understand It Instantly

1
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

25
Comments 1
3 min read
SQLite Limitations and Internal Architecture

SQLite Limitations and Internal Architecture

21
Comments
4 min read
Log Databases Done Right

Log Databases Done Right

Comments
5 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.