Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases (Indexes (Principles and Optimization of 5 PostgreSQL Indexes…
Databases
Indexes
Principles and Optimization of 5 PostgreSQL Indexes (btree,hash,gin,gist,and brin)
When to use PostgreSQL Full Text Search and Trigram Indexes
Principles and Applications of the Index Types Supported by PostgreSQL
Postgres derailed indexes. Part 1
Indexing and B-Trees — Applications in Postgres
How To Not Be Stumped By Trees
Postgres Indexes Under the Hood
: :star:
DB Engines
A Busy Developer’s Guide to Database Storage Engines — The Basics
The State of the Storage Engine
The State of the Storage Engine
Some study on database storage internals
How to write a simple toy database in Python within minutes
Locking (Race condition)
Pessimistic vs Optimistic Locking in Laravel
Scaling SQL: #1 Optimistic locking
Scaling SQL: #2 Filtering results
Optimistic Commands Locking: Our Experience
Designing the most performant Row Level Security schema in Postgres
NoSQL
Why you should build your own NoSQL database
Why are NoSQL Databases Becoming Transactional?
MongoDB queries don’t always return all matching documents!
What is a NoSQL Database? Learn By Writing One In Python
Data Modeling
Data Modeling Basics — PostgreSQL vs. Cassandra vs. MongoDB
Docker, Kubernetes and the Rise of Cloud Native Databases
How Does Consensus-Based Replication Work in Distributed Databases?
Design Your Own Database
Concept to Implementation
or How to Design a Database Without Touching a Computer
CAP Theorem
A for apple, B for ball, C for “CAP theorem”
You Can’t Sacrifice Partition Tolerance
Please stop calling databases CP or AP
Relational DBs
Relational Database 101
Dealing with significant Postgres database bloat — what are your options?
ACID
A beginner’s guide to ACID and database transactions
Base: An Acid Alternative
Redis
Using Redis API as a True Distributed, Fault-Tolerant Database