4 ms·
That’s fun, but I think I'll just use an SQLite foreign data wrapper instead.
by Apreche 2y ago
That’s fun, but I think I'll just use an SQLite foreign data wrapper instead.
- frectonz 2y agoThat's the sensible option but not the fun one.
- michelpp 2y agoThen you need one wrapper per database, with this approach you can have one database per row.
- ellisv 2y agoBut can I have one row that holds all the databases?
- frectonz 2y agoyes you can CREATE TABLE crime_against_humanity ( databases SQLITE[] );
- michelpp 2y agoWith the expanded datum api you can also work with subscriptable array types to only expand elements lazily as needed. It might already works if you try it, but support for it might be hardwired only to nested stock arrays, something to look into.