Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
create database and delete it in PostgreSQL

create database and delete it in PostgreSQL

2
Comments
1 min read
POO con BBDD #1

POO con BBDD #1

1
Comments
3 min read
5 Strategies for Random Records from DB
Cover image for 5 Strategies for Random Records from DB

5 Strategies for Random Records from DB

8
Comments
4 min read
Redis Explained: The Secret Ingredient Behind Fast Apps & Smooth DevOps
Cover image for Redis Explained: The Secret Ingredient Behind Fast Apps & Smooth DevOps

Redis Explained: The Secret Ingredient Behind Fast Apps & Smooth DevOps

2
Comments
3 min read
The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

The Card Whisperer: Predicting Database Query Costs... Without Data by Arvind Sundararajan

Comments
2 min read
Chinese DBA’s Story:Xu Ji — From a programmer to a database expert

Chinese DBA’s Story:Xu Ji — From a programmer to a database expert

Comments
8 min read
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
Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Comments
18 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
Your ORM is Lying to You About SQL (CTEs Explained)
Cover image for Your ORM is Lying to You About SQL (CTEs Explained)

Your ORM is Lying to You About SQL (CTEs Explained)

5
Comments
8 min read
Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?
Cover image for 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
🏦 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
Understanding SQL Databases

Understanding SQL Databases

1
Comments
1 min read
ACID Properties in DBMS

ACID Properties in DBMS

Comments
1 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

Comments
1 min read
INDEXING - HASHING - AND -QUERY

INDEXING - HASHING - AND -QUERY

Comments
1 min read
Understanding Records in PL/SQL: Benefits and Limitations

Understanding Records in PL/SQL: Benefits and Limitations

1
Comments
3 min read
CRUD Operations in MongoDB — Student Management System

CRUD Operations in MongoDB — Student Management System

Comments
3 min read
loading...