Comment by russellthehippo

Thanks! yeah it's definitely slow, but compared to other options it's quite fast:

- Neon startup is 500ms+

- a Fly Machine with a SQLite database on a volume takes 150ms+ to start up at minimum

- restoring a db from S3 with Litestream can take multiple seconds depending on how long from the last snapshot and how large the database is

- downloading a whole .sqlite file from S3 can be faster than Litestream restore but you still have to download the whole db file.

- One similar option is, you could save each table in a separate database and only download the db files for tables you need for a given query, then ATTACH. But this is an awkward setup even though it's simple