https://sqlite.org/c3ref/deserialize.html https://sqlite.org/c3ref/serialize.html
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Mohd Radzi Ibrahim >Sent: Tuesday, 28 May, 2019 21:23 >To: SQLite mailing list >Subject: Re: [sqlite] Making blob as a sqlite database. > >Hi Don, >I am working on sales and stock management systems where all outlets >run on >it's own local database. I was thinking of a solution for all outlets >to >backup to central server and perhaps thru web interface do some >queries on >the backup database. I know postgres has binary interface that allow >read/write to blob record which is quite promising to have a vfs >system >that can just store database in that record. > >But it seems that the blob in SQLite could not do that. > > >On Tue, Apr 30, 2019 at 10:44 PM Don V Nielsen ><donvniel...@gmail.com> >wrote: > >> Sorry to bother, Mohd. What is your use case? I mentioned this to >> developers around me and they are intrigued. You are storing a >database >> file as blob in a database? We are curious as to the application. I >am >> assuming the database being stored is a collection of sensor or >event data? >> >> On Fri, Apr 26, 2019 at 5:48 PM Mohd Radzi Ibrahim ><imra...@gmail.com> >> wrote: >> >> > Hi, is there a vfs that could be used to open a blob column as a >> database? >> > >> > >> > thanks. >> > >> > Radzi. >> > _______________________________________________ >> > 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 >> >_______________________________________________ >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
