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- >[email protected]] 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 ><[email protected]> >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 ><[email protected]> >> wrote: >> >> > Hi, is there a vfs that could be used to open a blob column as a >> database? >> > >> > >> > thanks. >> > >> > Radzi. >> > _______________________________________________ >> > sqlite-users mailing list >> > [email protected] >> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users >> > >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users >> >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
