bnmoch3

[Note] Creating a DuckDB Table Function Extension

Alternatively: A DuckDB Table Function Extension Starter Code

[Note] PostgreSQL to Iceberg Snapshot Sync (Using DuckDB)

Query PG using DuckDB, copy table data into iceberg

[Note] Arrays, Constraints & Immutable Functions

Tightening what kinds of values array columns can hold using constraints and immutable functions

Fine-grained Authorization with Row Level Security in PostgreSQL

Tutorial on RLS

Multi-Tenancy Models in PostgreSQL

Overview of various approaches for multi-tenancy implementation in Postgres

PostgreSQL: Managing Roles, Attributes and Privileges

Using roles for permissions and authorization for users and groups in PG

Timeseries and ASOF Joins

Pairing up timeseries data when the timestamps don’t match exactly (in Pandas, Polars, DuckDB, Postgres & QuestDB)

Archiving Time-Series Data from PostgreSQL into Parquet

Keeping your database lean

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