Optimized Analytics Applications · Part 1
Optimizing queries in Postgres and BigQuery
Read query plans in Postgres and BigQuery, then make queries faster with indexes, partitioning, clustering and fewer scanned columns.
SC
Samuel Chan
14 min read
Meet us in Singapore: Samuel Chan is speaking at GovTech STACK 2026, Marina Bay Sands on 3 November.
Supertype Notes
Databases & BigQuery
Getting databases and warehouses to be fast, queryable, and ready for analytics.
5 articles in this topic
Databases & BigQuery
Introduction to NoSQL
A general introduction to NoSQL databases and their use cases.
VC
Vincentius C. Calvin
10 min read
Data Warehouse Modernization w/ BigQuery
A detailed documentation on building a modern data warehouse in BigQuery featuring storage and performance optimization.
SA
Stane Aurelius
15 min read
Databases & BigQuery
Optimized Analytics Applications · Part 2
Optimizing full text search in Postgres and BigQuery
A discussion on full text search and indexing strategies in Postgres and BigQuery (part 2 of 2)
SC
Samuel Chan
13 min read
Databases & BigQuery
Optimized Analytics Applications · Part 4
Querying JSON data in Postgres
Filter rows on values inside a JSONB column with @>, ->> and ILIKE, and unpack nested arrays with jsonb_array_elements. Examples use real IDX company data.
SC
Samuel Chan
4 min read
From the Supertype shelf
Going deep on Databases & BigQuery? We wrote the book.
The same thinking runs all the way through this 12-chapter guide, written by Samuel Chan and ready to read in an afternoon.
Learn it live with our engineers
Claude for Market Analysis
A hands-on workshop for building a personal market-monitoring system with Claude: screen IDX and SGX stocks, set up alerts in plain English, and build a live dashboard with an analyst built in. Beginner-friendly.
October 28, 2026Zoom Conferencing (Online)
Save your seatSeats from Rp490.000 (about $27)
Related topics
Data Engineering
Pipelines, orchestration, and the plumbing that moves data reliably at scale.
Streaming Data
Real-time architectures with Kafka, Spark, and the open source streaming stack.
Data Science in Industry
Field reports on applying machine learning to messy, high-stakes real-world problems.
Sentiment Analysis
A deep learning journey through social sentiment, from raw tweets to deployed insight.
Keep reading
This is one slice of the catalogue. Browse every topic on the notes index, or subscribe and we will send the next piece your way.
All Supertype Notes
The latest in AI and Enterprise Analytics