3 ms·
I thought this sounded pretty cool: > It doesn't copy the data into it, it actually lets the SQLite engine use Excel tables as the data storage (I implemented
by rattray 9y ago
I thought this sounded pretty cool:
> It doesn't copy the data into it, it actually lets the SQLite engine use Excel tables as the data storage (I implemented something SQLite calls a virtual table - an adapter to let it work with custom data sources). This means you can run update/delete/insert statements directly on excel tables
(from the linked reddit post, I haven't finished the blog post)
I wonder if a similar sort of approach with FDW's could work with Postgres and Excel.
- tejasmanohar 9y agoYep, that's just what FDWs are for-- modular storage layer. Plenty of cool hacks :)