https://www.sqlite.org/c3ref/serialize.html might help.
On Mon, Oct 22, 2018, 11:31 AM Zoltan Demeter <dzo...@gmail.com> wrote: > Hello there, > > I am working on a small plugin for a bigger application. I am bound by > the in-house app framework, for example I cannot create arbitrary > files or use anything OS-specific directly. > > I am using SQLite with an in-memory DB to obtain sorted, filtered > lists of items. I am happy with the library. The only problem is, the > amount of data can be so huge, that it takes a considerable amount of > time to calculate some of the fields and build up the DB. > > Thus, I would like to save my tables, but the "normal" backup API > wants to use a file. Like I wrote, I cannot use an arbitrary file, my > load/save procedure must be integrated into the app framework so that > all data will be packed into the project data file(s). > > Basically, if I could obtain a byte array, I could save it to disk. > Load and save should work across bitness and OS barriers ... eg. > between 32-bit Windows and 64-bit Mac. > > Or if I could tell SQLite to use custom file I/O routines ... I could > mock fwrite() to just write to memory and then grab the data. > > A "simple" table dump, without indices etc. would be already be great. > > Any ideas please? > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users