bnmoch3
Enjoyer of Go, Rust, Python, Databases & SQL
Latest
Posts
-
DB-Enforced State Machines in PostgreSQL: State-Based vs Event Sourced
FSMs: Storing State vs Storing Events. Also invalid State Transitions shouldn’t reach your DB
-
JavaScript Inheritance from the Ground Up
Prototypes, Classes and Everything in Between
-
Fine-grained Authorization with Row Level Security in PostgreSQL
Tutorial on RLS
Notes
Featured
- Fine-grained Authorization with Row Level Security in PostgreSQL
Tutorial on RLS
- Graph Query Interfaces: A Comparison Between SQL and Cypher
Featuring DuckDB & KuzuDB
- Larger-Than-Memory Data Management
For when the database exceeds the main memory size
- DuckDB JIT Compiled UDFs with Numba
JIT compiling your vectorized UDFs with Numba. Plus pure SQL is plenty fast if you can figure out how to write it
- Logging in Go
Best practices, Logging levels, structured logging, Logging & Telemetry (Metrics, Tracing), Audit logs
- Parquet + Zstd: Smaller faster data formats
Often, parquet files have to be compressed. For fast compression, use LZ4 or Snappy. For the highest data compression ratio, use brotli. For both, zstd
- Back To Basics: The foundation of Joins in SQL
Writing SQL joins without using joins at all. A quick history of Database Models, Schemas, Constraints, Cross-products and everything in between