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
Optimizing queries in Postgres and BigQuery
Optimized Analytics Applications · Part 1

Optimizing queries in Postgres and BigQuery

A whirlwind tour of query optimization strategies ft. query plans, index scans, and BigQuery-specific optimizations (part 1 of 2)

SC
Samuel Chan
15 min read

Databases & BigQuery

Optimized Analytics Applications · Part 4

Querying JSON data in Postgres

Combining the flexibility of JSON with the robustness of a relational database in Postgres.

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 Your Personal Finance Terminal
Learn it live with our engineers

Building Your Personal Finance Terminal

A 5-hour workshop across two evenings on building a personal finance terminal from scratch: AI-powered Telegram wired to IDX and SGX market data through the Sectors API.

September 24, 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.