Database
DB Design Tips
Don't use business related field as primary key business related fields examples: individual tax...
Database Indexes
B-Tree Index Pros: fast read, fast range query no limit on number of keys Cons: slow writes ...
Database Replications
Sync vs Async replication sync ensures strong consistency, but slower writes async ensures faste...
Elastic Search Cheatsheet
What is it? a convenience wrapper around Lucene to allow for fast searching in a distributed sys...
GORM CheatSheet
Import import ( "gorm.io/driver/mysql" "gorm.io/driver/postgres" "gorm.io/gorm" ) func mai...
PostgreSQL CheatSheet
PostgreSQL is: open sourced supports both relational and non-relational (JSON) queries for dynam...
Redis Cheatsheet
Key Points in-memory, key-value store supports string, int, hash(map<string, string>), list, set...
MongoDB Cheatsheet
Feature easy to use, well documented similar to SQL B-Tree ACID Transactions Single Leader R...
Cassandra Cheatsheet
ref: Jordan Key characteristics WideColumnStore Eventual Consistency Tunable ACID LSM Tree Index...
Database Comparisons
SQL Databases relational normalized data (minimum duplicate data) Uses B Tree or B+ Tree inde...