Thank you, Singapore. See the photos from our Agentic Patterns workshop at GovTech STACK 2026.

Supertype Notes

Databases & BigQuery

Getting databases and warehouses to be fast, queryable, and ready for analytics.

5 articles in this topic

Optimizing queries in Postgres and BigQuery
Optimized Analytics Applications · Part 1

Optimizing queries in Postgres and BigQuery

BigQuery has no EXPLAIN. Read its execution graph and dry runs, use EXPLAIN ANALYZE in Postgres, and see how much an index speeds up a lookup.

SC
Samuel Chan
14 min read

Databases & BigQuery

Introduction to NoSQL

A general introduction to NoSQL databases and their use cases.

VC
Vincentius C. Calvin
10 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
The Enterprise AI Agentic Stack
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.

Building agents that build your business
Learn it live with our engineers

Building agents that build your business

A two-evening workshop on designing and shipping AI agents that do real work for your business: from the agentic patterns that keep them reliable, to a working multi-agent system that researches, drafts and reports on your behalf.

December 9, 2026Zoom Conferencing (Online)

Save your seatSeats from Rp490.000 (about $27)

Related topics

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

We do not resell your data. We respect your privacy and trust.