Get the latest tech news
A faster way to copy SQLite databases between computers
Dumping a SQLite database to a text file can make it much smaller, which means you can download it faster.
I store a lot of data in SQLite databases on remote servers, and I often want to copy them to my local machine for analysis or backup. The indexes don’t store anything unique – they just duplicate data from other tables to make queries faster. I was thinking about ways to skip copying the indexes, and I realised that SQLite has built-in tools to make this easy.
Or read this on Hacker News