On: Show HN: Embed an SQLite database in your PostgreS...

[ellisv]

But can I have one row that holds all the databases?

[frectonz → ellisv]

yes you can

CREATE TABLE crime_against_humanity ( databases SQLITE[] );

[michelpp → frectonz]

With 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.