SQLite Forum

can I insert an 8GB file into sqlite?
Login
First you asked,

> > when the size of the DB gets so big that it takes days and days to transfer, what happens when there's an interruption?

So I answered, then new requirements appeared about copying the database whilst write transactions are going against it. Not everybody needs that, but a filesystem-independent solution lies in driving [SQLite's online backup API](https://sqlite.org/backup.html) in a background thread, then transfer the consistent backup. No doubt one can come up with yet-unstated requirements that won't work for, but, we've covered a lot of ground already!

> > Node.js JIT-compiles your script into native machine code.

> Ah, that explains why VSCode feels about as fast as 4.3 BSD vi over a 9600 bps VT220 connection, then.

9600bps is an order of magnitude faster than vi was designed for. =)