I'm porting some code to an environment in which files on disk are limited to 2GB per file, however the SQLite db is about 20x that size.
I know that I can use ATTACH DATABASE to have different tables in different db files, but what if a single table is larger than the file limit?
What options do I have to spread the database across multiple files?