Database & Data Engineering Tutorials¶

PostgreSQL & PostGIS¶

PostGIS Geometry Indexing - Optimize spatial queries in PostGIS
PostGIS Raster Indexing - Efficiently manage and query raster data
Raster–Vector Workflows - Combine raster and vector data for advanced analysis
Alembic Migrations - Master database schema evolution with Alembic
PostgreSQL Pooling (PgBouncer + FastAPI) - Optimize database connections for high-concurrency applications
Solr + Postgres JSONB Search - Supercharge relational data with Solr's facets, suggesters, geo, and highlighting—using JSONB as source
Auditing PostgreSQL with PgAudit and PgCron - Complete audit trail setup with log rotation, activity views, and automated maintenance

parquet_s3_fdw with Local, MinIO, Vast, and AWS - Query Parquet directly from object storage
Building a Postgres Lakehouse Image with pg_lake and parquet_s3_fdw - Single Docker image with pg_lake (Iceberg + DuckDB) and parquet_s3_fdw for unified lakehouse operations
GeoParquet with Polars - High-performance spatial analytics with Polars

Generating Dark OpenMapTiles for the Entire US at Zoom Level 12 - Complete pipeline for generating dark-themed vector tiles covering the United States using OpenMapTiles, Docker, and tileserver-gl
Real-Time Data Processing - Implement Kafka and TimescaleDB for streaming data
Kafka + TimescaleDB IoT Streaming - Stream simulated IoT telemetry into TimescaleDB
Pulsar → Flink → Pinot (Realtime OLAP) + Superset - A clean, fast streaming stack with sub-second analytics
H3 + Tile38 + NATS + DuckDB - Real-time geofences with hex aggregation and offline analytics
H3 Raster to Hex - Converting geospatial rasters to hexagonal grids for spatial analysis
IPFS + SurrealDB + Meilisearch + NATS + Deno + Svelte - Content-addressed knowledge with verifiable blobs and fast search

Go-Glue OSM → PostGIS → Tiles Pipeline - A realistic Go CLI that orchestrates fetching OSM, loading PostGIS, generating tiles, and publishing to object storage

Apache Spark Mastery - Master distributed data processing with Apache Spark
Apache Iceberg Mastery - Build, break, and bend ACID tables in the data lake

Graph vs Vector Databases - When relationships meet similarity in modern data applications
Geospatial Knowledge Graph - Build intelligent location-aware systems with PostGIS + Neo4j
DuckDB Parquet Data Quality - Inspect and validate Parquet files for data quality issues