3 ms·

For anybody using sqlite, they have good documentation about this very question: https://www.sqlite.org/intern-v-extern-blob.html https://www.sqlite.org/intern-

• bvinc 10y ago
  Is this really the same thing? This page compares storing blobs in sqlite vs in a separate file. I think a better sqlite page about the concept of serializing things in your database is the fact that sqlite has json support. https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html
  • distances 10y ago
    That's with a loadable JSON1 extension, which one won't find e.g. in Android. Though checking now for this, someone has packaged a later version of SQLite with this extension [1]. I wonder if there is any possible performance advantage when using a system provided SQLite vs. one installed with the application? [1] https://github.com/requery/sqlite-android https://github.com/requery/sqlite-android
    • distances 10y ago
      Note to self: should have read the whole project description, there's a performance chapter answering this exact question.