SQLite Forum

Table and index in separate files
I have never understood why one might want to have separate files for that. In fact, I still hate Shapefiles for being a collection of about ~10 different files which is horror to me when having to copy them.

Using a single file for all is one of the most lovely things of SQLite!👍