← Back to context

Comment by 6gvONxR4sf7o

5 years ago

I used to advocate for this, then tried opening a sqlite file I'd been using on another computer and it said it was corrupted. I took it back to the original computer and it opened just fine. So there was something going on that made it more complex and less portable than something simple like json, which is super frustrating because otherwise it's a really useful format for datasets, and now I can't really trust it.

6 comments

6gvONxR4sf7o

Reply
curiousmindz  5 years ago

If you use certain new features of SQLite, the database file gets "upgraded". At that time, you must use a version of SQLite that understands these new features.

So, the other computer you used was probably running an older version of SQLite. Just update it to make it work.

  • 6gvONxR4sf7o  5 years ago

    I think the computer it worked on was one with an older version of SQLite rather than a newer one, but I’m not certain. It was a while ago. I thought I’d checked for the upgrade issue, but my memory is shit.

  • bollockitis  5 years ago

    That’s a good catch. I’d there any way to tell which version of SQLite created the file? Aside from trial and error, I mean?