3 ms·
Great packaging - simple interface. This is built on top of Cloudflare D1 as it clearly states but there are few things that I don't like about Cloudflare D1:
by wg0 2y ago
Great packaging - simple interface.
This is built on top of Cloudflare D1 as it clearly states but there are few things that I don't like about Cloudflare D1:
You cannot download your SQLite database as is. All you can do is dump an SQL file and when your database sizes are clocking at few GBs (let's say 5), that option is probably not going to work because the query/API also has a time out limit of 30 seconds and that data dumped as SQL (text) takes up way more space than it is in its binary form on disk.
This essentially means that you can kiss your data a goodbye and it is locked in there forever with no hope of getting it back ever as a whole.
For smaller databases, to do lists, note taking, personal expense tracker etc - probably you can live with those limitations.
- jgrahamc 2y agoI'll ask the team to add this as a feature.
- yoeven 2y agoOhh try out our dump API, it lets you pick specific tables with schema only or data only, etc. Right now for 10GB dbs, it should be ok but again haven't tested for that specific use case. The goal is eventually to provide a way for resumable downloads so you can download chunks at a time even for backups. We'll be launching a backup dashboard soon to download your db backups!