Re: [sqlite] Converting in-memory sqlite database to char array

On Thu, Nov 29, 2012 at 02:39:49PM +, Black, Michael (IS) scratched on the wall: > I thought a backup was using a snapshot and locking the database? No... the source DB remains available. That's largely the point of the API. In fact, the full name is the "Online Backup API." The fact

Re: [sqlite] Converting in-memory sqlite database to char array

on Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Jay A. Kreibich [j...@kreibi.ch] Sent: Thursday, November 29, 2012 8:37 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Converting in-memory sqlite d

Re: [sqlite] Converting in-memory sqlite database to char array

On Thu, Nov 29, 2012 at 02:05:02PM +, Black, Michael (IS) scratched on the wall: > And if you want to improve latency you can use fifo's on Unix or > anonymous pipes on Windows and run a thread to send your data > while it's writing since those methods are synchronous. I would not assume th

Re: [sqlite] Converting in-memory sqlite database to char array

writing to a file is indeed the easy way, but I would rather not involve the filesystem if possible. yet, I guess that will be the way I will choose at the end. I also had a look at VFS, but an easier method would have been better of course. On Thu, Nov 29, 2012 at 2:53 PM, Eric Minbiole wrote:

Re: [sqlite] Converting in-memory sqlite database to char array

behalf of Eric Minbiole [eminbi...@gmail.com] Sent: Thursday, November 29, 2012 7:53 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Converting in-memory sqlite database to char array As a first (simple) approach, I might use the standard backup API to back up to a temp fi

Re: [sqlite] Converting in-memory sqlite database to char array

As a first (simple) approach, I might use the standard backup API to back up to a temp file, then stream that file byte by byte over the communication protocol. I'm sure there may be other more direct-to-memory approaches, perhaps using a custom VFS. However, this approach should be simple and ea

[sqlite] Converting in-memory sqlite database to char array

Hi all, I have an in-memory sqlite database which I want to convert to a simple char array, to send over a communication protocol. I want to do this preferably without using any serialization library. Basically I want to do what backup api calls does, but instead of copying database to another da