On Tue, Jul 19, 2011 at 4:31 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 19 Jul 2011, at 5:17am, Glenn McCord wrote: > >> Hi. I've been trying to find out the best way of loading an sqlite >> database from memory. Basically I'd like to be able to save a small >> sqlite database as meta data to an audio file, i.e. an mpeg4 >> container. I'd then be able read, modify then write it back to the >> file. > > You can use the SQLite backup API to transfer an entire database from or to > memory: > > http://www.sqlite.org/backup.html > > However, I'm not sure of the wisdom of saving data in this way. The SQLite > file format is not simple or easy to inspect, and uses up a lot of space > because it has to hold indexing information. Would it not make more sense to > encode your data as XML or JSON and save this (or a .zipped version of this) > in your MPEG4 instead ? >
I was thinking the same thing, but some of the guys around the office are pretty keen on the idea of using sqlite. I'm just doing the required research and weighing up the options. Using JSON seems like a good idea. Thanks for the link. > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
