Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
MySQL COUNT Scalar Subquery Optimization: The Complete Guide
Cover image for MySQL COUNT Scalar Subquery Optimization: The Complete Guide
rebooter_s profile

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

#sql #database #mysql #ai
Comments
4 min read
āĻāĻ•āĻœāĻ¨ āĻ¸āĻŋāĻ¨āĻŋā§ŸāĻ° āĻ‡āĻžā§āĻœāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ°ā§‡āĻ° āĻŽāĻ¤ā§‹ āĻ•āĻ°ā§‡ āĻ¸ā§āĻ•ā§‡āĻ˛āĻŋāĻ‚ āĻ•āĻ°ā§āĻ¨ (āĻ¸āĻžāĻ°ā§āĻ­āĻžāĻ°, āĻĄā§‡āĻŸāĻžāĻŦā§‡āĻ¸, āĻ˛ā§‹āĻĄ āĻŦā§āĻ¯āĻžāĻ˛ā§‡āĻ¨ā§āĻ¸āĻžāĻ°, SPOF)
junaaid96 profile

āĻāĻ•āĻœāĻ¨ āĻ¸āĻŋāĻ¨āĻŋā§ŸāĻ° āĻ‡āĻžā§āĻœāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ°ā§‡āĻ° āĻŽāĻ¤ā§‹ āĻ•āĻ°ā§‡ āĻ¸ā§āĻ•ā§‡āĻ˛āĻŋāĻ‚ āĻ•āĻ°ā§āĻ¨ (āĻ¸āĻžāĻ°ā§āĻ­āĻžāĻ°, āĻĄā§‡āĻŸāĻžāĻŦā§‡āĻ¸, āĻ˛ā§‹āĻĄ āĻŦā§āĻ¯āĻžāĻ˛ā§‡āĻ¨ā§āĻ¸āĻžāĻ°, SPOF)

#database #backend #systemdesign #softwareengineering
Comments
7 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill
jennythomas498 profile

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

#sql #bigdata #database
Comments
8 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL
kallileiser profile

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

#database #nosql #sql
1
Comments
7 min read
A Practical Guide to Kubernetes Stateful Backup and Recovery
igeadetokunbo profile

A Practical Guide to Kubernetes Stateful Backup and Recovery

#devops #database #tutorial #kubernetes
2
Comments 1
5 min read
SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)
Cover image for SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)
farhadrahimiklie profile

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

#sql #database #transactions #programming
Comments
4 min read
đŸĻ Database Magic: Automating Tasks with Cursor and Trigger ✨
prabavathy_balagurusamy_2 profile

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

#database #sql #data #tutorial
Comments
3 min read
py schema
query_filter_591122b53770 profile

py schema

#database #python #sql
Comments
2 min read
Database Normalization: From 1NF to 3NF
nahuleswaran_s24cb031_b4 profile

Database Normalization: From 1NF to 3NF

#sql #tutorial #database #computerscience
Comments
2 min read
Cursor +Trigger
nahuleswaran_s24cb031_b4 profile

Cursor +Trigger

#beginners #sql #tutorial #database
Comments
2 min read
🚀 ā¸—ā¸ŗā¸„ā¸§ā¸˛ā¸Ąāš€ā¸‚āš‰ā¸˛āšƒā¸ˆ Row-Level Security (RLS) āšƒā¸™ PostgreSQL āšā¸šā¸šā¸‡āšˆā¸˛ā¸ĸā¸—ā¸ĩāšˆā¸Ēā¸¸ā¸”
tanakritseangnet profile

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

#postgres #database #tutorial #security
Comments
1 min read
MySQL: Complete Architecture, Internals, and Practical Guide (With Code)
Cover image for MySQL: Complete Architecture, Internals, and Practical Guide (With Code)
farhadrahimiklie profile

MySQL: Complete Architecture, Internals, and Practical Guide (With Code)

#mysql #sql #database #programming
Comments
3 min read
Database Indexing Explained Like You're 5 (Then Like You're a Senior Dev)
Cover image for Database Indexing Explained Like You're 5 (Then Like You're a Senior Dev)
adhikareeprayush profile

Database Indexing Explained Like You're 5 (Then Like You're a Senior Dev)

#systemdesign #beginners #database #tutorial
2
Comments
7 min read
Building Reliable Legal AI: Never Missing a Supreme Court Case
Cover image for Building Reliable Legal AI: Never Missing a Supreme Court Case
pascal_cescato_692b7a8a20 profile

Building Reliable Legal AI: Never Missing a Supreme Court Case

#ai #python #database #dataengineering
3
Comments
26 min read
ACID Properties in DBMS
nahuleswaran_s24cb031_b4 profile

ACID Properties in DBMS

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