2 ms·
One of my favorite sqlite features is the vtable mechanism: https://sqlite.org/vtab.html https://sqlite.org/vtab.html It makes it possible to expose a custom,
by microtherion 9y ago
One of my favorite sqlite features is the vtable mechanism: https://sqlite.org/vtab.html https://sqlite.org/vtab.html
It makes it possible to expose a custom, application specific database format as a sqlite table, and suddenly you can run SQL queries on your data!
- masklinn 9y agoPostgres also has that concept, though calls it Foreign Data Wrappers: https://wiki.postgresql.org/wiki/Foreign_data_wrappers https://wiki.postgresql.org/wiki/Foreign_data_wrappers And it goes beyond single tables e.g. PG-Strom uses FDW to implement GPGPU scans, joins, aggregations & projections (and provides a pg/CUDA while at it)
- chrisweekly 9y agoYes, this! Vtables are how [lnav](http://lnav.org http://lnav.org) works its magic. Embedded SQLite makes so much sense for such use cases.