DSA Solution
β
Note Preview
04_dsa_solutions/leetcode_solutions
π Open Note
TOC
Sidebar
Graph
Focus
Tools
Top
Table of Contents
β
Exit Focus Mode
Platform & Reading Settings
β
Theme & Appearance
COLOR THEME
βοΈ Light
π Dark
READING TINT
Default
π Paper
π Warm
Reading & View Controls
π
Distraction-Free Focus
Toggle
πΊοΈ
Obsidian Global Graph
Graph
π
Platform Specs & Audit
Report
π§Ή
Reset Local Storage & Cache
Reset
π Platform Audit & Verification Report
β
360
Indexed Notes
5.0s
Build Time
100%
SPA Compliant
60 FPS
PixiJS Graph
Active Platform Features
β
Multi-Track Fast Dev
: Staging 2+ tracks in parallel with sub-5s full builds.
β
Obsidian Graph Engine
: Emerald (DSA), Indigo (Architecture), Amber (Languages), Pink (Cloud).
β
Directed Arrows
: GPU-accelerated triangular vectors indicating knowledge dependencies.
β
Lazy-Loaded Graph
: Zero initial memory/CDN overhead, hydrating strictly on viewport intersection.
β
Mobile TOC Drawer
: Touch-friendly bottom sheet highlighting active section headings.
β
Distraction-Free Focus
: Maximize reading canvas with 1-click floating exit trigger.
β
Resilient Storage
: Defensive JSON parsing preventing crashes across hard reload (Ctrl+Shift+R).
GraphMind
Dark mode
Light mode
Explorer
Home
β―
02_Technical_Skills
β―
01_theory_and_concepts
β―
12_Databases_and_SQL
12_Databases_and_SQL
Search
Search
25 items under this folder.
Aug 29, 2026
Database Sharding Patterns & Distributed Routing: Consistent Hashing, 2PC & Online Resharding
database-sharding
distributed-sql
consistent-hashing
horizontal-scaling
proxysql
citus
vitess
2pc
technical-skills
software-engineering
learning-note
Aug 29, 2026
SQL Master Review & Senior Interview Handbook: Query Mechanics, MVCC, Isolation Levels & Analytical Patterns
sql
sql-review
interview-prep
window-functions
recursive-cte
mvcc
transaction-isolation
relational-algebra
technical-skills
software-engineering
learning-note
Aug 29, 2026
SQL Query Optimization & Execution Plans: EXPLAIN ANALYZE, Access Paths & Index Engineering
sql
query-optimization
explain-analyze
indexing
postgresql
database-performance
query-planner
technical-skills
software-engineering
learning-note
Aug 29, 2026
SQL Table Partitioning & Partition Pruning: Declarative Range, List, Hash & Subpartitioning
sql
table-partitioning
partition-pruning
postgresql
mysql
database-performance
query-optimization
storage-engine
technical-skills
software-engineering
learning-note
Aug 21, 2026
Advanced PostgreSQL Features: JSONB, GIN/GiST, Full-Text & Foreign Data Wrappers
postgresql
jsonb
gin
gist
full-text-search
fdw
rls
advanced-sql
indexing
technical-skills
software-engineering
learning-note
Aug 21, 2026
B+Tree Page Layout, Node Splitting, Latch Crabbing & Buffer Pool Management
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
Database Buffer Pool Manager: Clock Sweep, LRU-K & Page Eviction Algorithms
database-internals
buffer-pool
clock-sweep
lru-k
page-eviction
storage-engine
memory-management
technical-skills
software-engineering
learning-note
Aug 21, 2026
Columnar Storage Formats: Apache Parquet, ORC, Dictionary Encoding & SIMD Vectorization
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
Complex SQL Engineering: Subqueries, Window Functions, CTEs & Set Theory
sql
complex-queries
window-functions
recursive-cte
relational-algebra
analytics
performance
technical-skills
software-engineering
learning-note
Aug 21, 2026
Relational Database Design: Normalization, Entity-Relationship Models & Anti-Patterns
database-design
normalization
er-modeling
relational-database
sql-schema
database-architecture
technical-skills
software-engineering
learning-note
Aug 21, 2026
Database Sharding, HA Clustering: Patroni, ProxySQL & Citus Architecture
database-sharding
patroni
citus
proxysql
high-availability
postgresql
distributed-sql
technical-skills
software-engineering
learning-note
Aug 21, 2026
Concurrency Race Conditions in SQL: Lost Updates, Phantom Reads & Locking Solutions
sql
race-conditions
lost-updates
select-for-update
optimistic-locking
concurrency
transactions
technical-skills
software-engineering
learning-note
Aug 21, 2026
Distributed SQL Architecture: CockroachDB & Spanner Multi-Raft Consensus, HLC & 2PC Mechanics
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
Elasticsearch Architecture: Inverted Index, FST, Segment Merging & Lucene Internals
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
SQL Filtering, Grouping & Aggregation Mastery: Relational Mathematics
sql
aggregation
filtering
grouping-sets
rollup
cube
relational-algebra
technical-skills
software-engineering
learning-note
Aug 21, 2026
LSM-Tree Architecture, LevelDB/RocksDB & Compaction Strategies
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
PL/pgSQL Programming: Stored Procedures, Triggers & Architecture
plpgsql
postgresql
stored-procedures
triggers
database-programming
procedures
spi
security
technical-skills
software-engineering
learning-note
Aug 21, 2026
PostgreSQL Administration: Backup (pg_dump/WAL-G), Replication & Tuning
postgresql
replication
backup
wal-g
pgbackrest
pgbouncer
performance-tuning
sysadmin
pitr
technical-skills
software-engineering
learning-note
Aug 21, 2026
Redis Cluster Internals: Sharding, Hash Slots, Gossip Protocol & Slot Resharding Mechanics
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
Database Security & Access Control: RBAC, Grants & Column/Row Encryption
database-security
postgresql
rbac
permissions
pgcrypto
encryption
access-control
rls
pgaudit
scram
technical-skills
software-engineering
learning-note
Aug 21, 2026
SQL Fundamentals: Relational Algebra, DDL, DML & Join Mechanics
sql
relational-algebra
sql-fundamentals
joins
ddl
dml
query-engine
three-valued-logic
technical-skills
software-engineering
learning-note
Aug 21, 2026
SSD, NVMe & Flash Storage Architecture: FTL, Trim & Write Amplification
nvme
ssd
flash-storage
ftl
write-amplification
database-storage
hardware
storage-engine
io-uring
rocksdb
technical-skills
software-engineering
learning-note
Aug 21, 2026
TimeSeries Database Architecture: TDEngine, InfluxDB TSM/TSI Engine, WAL & Gorilla Compression
databases
sql
engineering
technical-skills
software-engineering
learning-note
Aug 21, 2026
Database Transactions & Concurrency: ACID, Isolation Levels & 2PL
transactions
acid
concurrency
2pl
mvcc
serializability
ssi
write-skew
postgresql
database-internals
technical-skills
software-engineering
learning-note
Aug 21, 2026
Write-Ahead Logging (WAL) Architecture: ARIES Recovery & fsync Durability
database-internals
wal
write-ahead-logging
aries-recovery
lsn
durability
fsync
checkpoints
postgresql
technical-skills
software-engineering
learning-note