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.
How I Cleaned a Hacked WordPress Database in 5 Minutes

How I Cleaned a Hacked WordPress Database in 5 Minutes

Comments 1
5 min read
Postgres tuning using feedback loops

Postgres tuning using feedback loops

5
Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
MySQL COUNT Scalar Subquery Optimization: The Complete Guide

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

Comments
4 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Comments
8 min read
āĻāĻ•āϜāύ āϏāĻŋāύāĻŋ⧟āϰ āχāĻžā§āϜāĻŋāύāĻŋāϝāĻŧāĻžāϰ⧇āϰ āĻŽāϤ⧋ āĻ•āϰ⧇ āĻ¸ā§āϕ⧇āϞāĻŋāĻ‚ āĻ•āϰ⧁āύ (āϏāĻžāĻ°ā§āĻ­āĻžāϰ, āĻĄā§‡āϟāĻžāĻŦ⧇āϏ, āϞ⧋āĻĄ āĻŦā§āϝāĻžāϞ⧇āĻ¨ā§āϏāĻžāϰ, SPOF)

āĻāĻ•āϜāύ āϏāĻŋāύāĻŋ⧟āϰ āχāĻžā§āϜāĻŋāύāĻŋāϝāĻŧāĻžāϰ⧇āϰ āĻŽāϤ⧋ āĻ•āϰ⧇ āĻ¸ā§āϕ⧇āϞāĻŋāĻ‚ āĻ•āϰ⧁āύ (āϏāĻžāĻ°ā§āĻ­āĻžāϰ, āĻĄā§‡āϟāĻžāĻŦ⧇āϏ, āϞ⧋āĻĄ āĻŦā§āϝāĻžāϞ⧇āĻ¨ā§āϏāĻžāϰ, SPOF)

Comments
7 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

1
Comments
7 min read
Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Comments
4 min read
SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)

SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)

Comments
4 min read
A Practical Guide to Kubernetes Stateful Backup and Recovery

A Practical Guide to Kubernetes Stateful Backup and Recovery

2
Comments 1
5 min read
đŸĻ Database Magic: Automating Tasks with Cursor and Trigger ✨

đŸĻ Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
py schema

py schema

Comments
2 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
🚀 ā¸—ā¸ŗā¸„ā¸§ā¸˛ā¸Ąāš€ā¸‚āš‰ā¸˛āšƒā¸ˆ Row-Level Security (RLS) āšƒā¸™ PostgreSQL āšā¸šā¸šā¸‡āšˆā¸˛ā¸ĸ⏗ā¸ĩāšˆā¸Ē⏏⏔

🚀 ā¸—ā¸ŗā¸„ā¸§ā¸˛ā¸Ąāš€ā¸‚āš‰ā¸˛āšƒā¸ˆ Row-Level Security (RLS) āšƒā¸™ PostgreSQL āšā¸šā¸šā¸‡āšˆā¸˛ā¸ĸ⏗ā¸ĩāšˆā¸Ē⏏⏔

Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.