Build a Go Analytics Database with SuperSQL and Unified JSON
Learn to build a Go analytics database using SuperSQL. Master vectorized runtimes, structured type systems, and unified JSON processing for high-performance data.
Best quote from Build a Go Analytics Database with SuperSQL and Unified JSON
The big breakthrough is that 'schema-less' doesn't have to mean 'type-less.' In this super-structured model, every piece of data carries its own 'passport'—a precise, dynamic type definition that travels with it, allowing the engine to treat nested JSON with the same structural awareness as a standard SQL row.
Generated by Patrick
Build a Go analytics database that unifies JSON and relational tables in one engine. Design a super-structured type system: every value is strongly and dynamically typed, eliminating schema inference and JSON columns entirely. Implement three wire formats — SUP (text), BSUP (binary), CSUP (columnar). Build a vectorized runtime and type-based query compiler powering SuperSQL, SQL extended with pipe syntax. Expose a CLI for local queries and a lake engine for persistence.
Frequently Asked Questions
SuperSQL is an extension of standard SQL that introduces a pipe-based syntax to streamline complex data transformations. By integrating with a type-based query compiler, it allows developers to query unified JSON and relational tables within a single engine. This approach eliminates the need for traditional schema inference, providing a more predictable and efficient way to handle diverse datasets while maintaining the familiarity of SQL-like structures.
The vectorized runtime is a core component of this Go analytics database designed to boost performance by processing batches of data at once rather than row-by-row. This architecture leverages the structured type system to minimize CPU overhead and maximize throughput during complex analytical queries. By combining this runtime with columnar data formats, the engine can execute high-speed operations across large-scale datasets, making it ideal for modern lake engine environments.
These three wire formats define how data is transmitted and stored within the system. SUP is a human-readable text format, BSUP is a compact binary representation for efficient transport, and CSUP is the columnar data format optimized for analytical processing. Together, they support a super-structured type system where every value is strongly and dynamically typed, ensuring consistency across the CLI and the persistent lake engine without relying on standard JSON columns.
A super-structured type system treats every value as both strongly and dynamically typed, which removes the performance penalties associated with schema inference and unstructured JSON columns. In this Go analytics database, this design allows the query compiler to optimize execution plans based on known types. This results in faster query execution and more reliable data integrity, as the engine unifies relational and semi-structured data into a single, cohesive type-aware framework.
From Columbia University alumni built in San Francisco
"Instead of endless scrolling, I just hit play on BeFreed. It saves me so much time."
"I never knew where to start with nonfiction—BeFreed’s book lists turned into podcasts gave me a clear path."
"Perfect balance between learning and entertainment. Finished ‘Thinking, Fast and Slow’ on my commute this week."
"Crazy how much I learned while walking the dog. BeFreed = small habits → big gains."
"Reading used to feel like a chore. Now it’s just part of my lifestyle."
"Feels effortless compared to reading. I’ve finished 6 books this month already."
"BeFreed turned my guilty doomscrolling into something that feels productive and inspiring."
"BeFreed turned my commute into learning time. 20-min podcasts are perfect for finishing books I never had time for."
"BeFreed replaced my podcast queue. Imagine Spotify for books — that’s it. 🙌"
"It is great for me to learn something from the book without reading it."
"The themed book list podcasts help me connect ideas across authors—like a guided audio journey."
"Makes me feel smarter every time before going to work"
From Columbia University alumni built in San Francisco
"Instead of endless scrolling, I just hit play on BeFreed. It saves me so much time."
"I never knew where to start with nonfiction—BeFreed’s book lists turned into podcasts gave me a clear path."
"Perfect balance between learning and entertainment. Finished ‘Thinking, Fast and Slow’ on my commute this week."
"Crazy how much I learned while walking the dog. BeFreed = small habits → big gains."
"Reading used to feel like a chore. Now it’s just part of my lifestyle."
"Feels effortless compared to reading. I’ve finished 6 books this month already."
"BeFreed turned my guilty doomscrolling into something that feels productive and inspiring."
"BeFreed turned my commute into learning time. 20-min podcasts are perfect for finishing books I never had time for."
"BeFreed replaced my podcast queue. Imagine Spotify for books — that’s it. 🙌"
"It is great for me to learn something from the book without reading it."
"The themed book list podcasts help me connect ideas across authors—like a guided audio journey."
"Makes me feel smarter every time before going to work"
"Instead of endless scrolling, I just hit play on BeFreed. It saves me so much time."
"I never knew where to start with nonfiction—BeFreed’s book lists turned into podcasts gave me a clear path."
"Perfect balance between learning and entertainment. Finished ‘Thinking, Fast and Slow’ on my commute this week."
"Crazy how much I learned while walking the dog. BeFreed = small habits → big gains."
"Reading used to feel like a chore. Now it’s just part of my lifestyle."
"Feels effortless compared to reading. I’ve finished 6 books this month already."
"BeFreed turned my guilty doomscrolling into something that feels productive and inspiring."
"BeFreed turned my commute into learning time. 20-min podcasts are perfect for finishing books I never had time for."
"BeFreed replaced my podcast queue. Imagine Spotify for books — that’s it. 🙌"
"It is great for me to learn something from the book without reading it."
"The themed book list podcasts help me connect ideas across authors—like a guided audio journey."
"Makes me feel smarter every time before going to work"
"Instead of endless scrolling, I just hit play on BeFreed. It saves me so much time."
"I never knew where to start with nonfiction—BeFreed’s book lists turned into podcasts gave me a clear path."
"Perfect balance between learning and entertainment. Finished ‘Thinking, Fast and Slow’ on my commute this week."
"Crazy how much I learned while walking the dog. BeFreed = small habits → big gains."
"Reading used to feel like a chore. Now it’s just part of my lifestyle."
"Feels effortless compared to reading. I’ve finished 6 books this month already."
"BeFreed turned my guilty doomscrolling into something that feels productive and inspiring."
"BeFreed turned my commute into learning time. 20-min podcasts are perfect for finishing books I never had time for."
"BeFreed replaced my podcast queue. Imagine Spotify for books — that’s it. 🙌"
"It is great for me to learn something from the book without reading it."
"The themed book list podcasts help me connect ideas across authors—like a guided audio journey."
"Makes me feel smarter every time before going to work"
