CSV Imports into Google Cloud BigQuery
A simple Postgres-to-BigQuery workflow using CSV exports and Google Cloud Storage for OLAP-style reporting.
Browsing tag: databases
Book Review: Designing Data-Intensive Applications
My review of Designing Data-Intensive Applications as a practical survey of what changed, and what still matters, in data systems.
Looking at PostGIS intersects queries
A closer look at how PostGIS represents geometries and handles intersects queries for area-of-interest searches.