virtual tables with zig-sqlite

last updated: Oct 20, 2023

https://rischmann.fr/blog/virtual-tables-with-zig-sqlite

Virtual tables let you expose almost anything as a SQL table: this is powerful because you can then use all the power of SQLite and SQL to exploit it. Ever wanted to join a CSV, a JSON file and a REST API? Virtual tables let you do that.

My goals for this feature were:

Today I want to talk about how I implemented it and I’ll also talk about a small demo I made.

The demo is a virtual table that actually hits an API instead of storing the data

↑ up