[sqlite] convert zip to sqlar file

2020-04-15 Thread Peng Yu
Hi, I'd like to convert zip files to sqlar files. Is there a command line tool that I can help with the conversion? Thanks. -- Regards, Peng ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailm

[sqlite] Troubleshooting corrupt indexes

2020-04-15 Thread Jens Alfke
We've found a few database instances with index corruption, and I'm unsure how to troubleshoot it. The symptom is SELECT queries failing with SQLITE_CORRUPT. I've looked at the database files, and `pragma integrity_check` spits out five "row missing from index" errors on one index, and "wrong #