Does that preserve the indexes? As the TFA mentioned, the indexes are why the sq... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

gwbas1c on May 1, 2025 | parent | context | favorite | on: A faster way to copy SQLite databases between comp...

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

M95D on May 1, 2025 [–]

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

4silvertooth on May 1, 2025 | [–]

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

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact