Hacker News Reader

Does that preserve the indexes? As the TFA mentioned, the indexes are why the sqlite files are huge.

You're right. It does. I never thought about it until you asked.

I think it won't preserve the index but it will recreate the index while running the text sql.