3 ms·
They /tmp file mechanism sounds like a bit of a hack, is that definitely necessary? It may be possible to create a SQLite in-memory database instead and then l
by simonw 2y ago
They /tmp file mechanism sounds like a bit of a hack, is that definitely necessary?
It may be possible to create a SQLite in-memory database instead and then load the binary blob data into it using the backup API or some kind of trick with VACUUM INTO.
- michelpp 2y agoI think the right approach would be to store the sqlite database as a varlena type that can be TOASTed and then "expanded" using the Expanded Datum API so that it's a live open database connection for the life of the transaction: https://www.postgresql.org/docs/17/xtypes.html#XTYPES-TOAST https://www.postgresql.org/docs/17/xtypes.html#XTYPES-TOAST https://github.com/postgres/postgres/blob/master/src/include/utils/expandeddatum.h https://github.com/postgres/postgres/blob/master/src/include...
- deleted 2y ago[deleted]