Re: [sqlite] Open and query sqlite db in a buffer

> > I see Richard already pointed out that you can create a connection to a > strictly in-memory DB which doesn't touch a file, and then Deserialize to > it. Just to emphasize, if you can make that work, it is definitely worth > it. From my experience, making the VFS will easily sink around 30 hou

Re: [sqlite] Open and query sqlite db in a buffer

> > > Do what you want, but remember you can always create a valid database > connection using sqlite3_open(":memory:", &db) and then do the > sqlite3_deserialize(). > > Thank you Richard, I didn't know that it can be done this way. ___ sqlite-users maili

Re: [sqlite] Open and query sqlite db in a buffer

On 2018/05/18 6:27 PM, Lloyd wrote: Only https://www.sqlite.org/draft/c3ref/deserialize.html comes to mind, and that's brand new and assumes the buffer comes from the companion serialize. Not sure it's release in 3.24 yet. Google finds it in the Draft only. --DD Deserialize cannot solve my pro

Re: [sqlite] Open and query sqlite db in a buffer

On 5/18/18, Lloyd wrote: > > Deserialize cannot solve my problem as it needs a valid db connection. As > suggested by Ryan vfs can solve my problem. Thank you DD Do what you want, but remember you can always create a valid database connection using sqlite3_open(":memory:", &db) and then do the sq

Re: [sqlite] Open and query sqlite db in a buffer

> > Only https://www.sqlite.org/draft/c3ref/deserialize.html comes to mind, > and that's brand new and assumes the buffer comes from the companion > serialize. Not sure it's release in 3.24 yet. Google finds it in the Draft > only. --DD Deserialize cannot solve my problem as it needs a valid db c

Re: [sqlite] Open and query sqlite db in a buffer

> > > But I imagine you had a more specific question in mind - please ask > exactly what you would like to know, and make sure to include all the > details what we need to know to be able to give answers or advice that > somewhat resemble the truth. > > (Is the buffer a queried cursor? a part of th

Re: [sqlite] Open and query sqlite db in a buffer

On Fri, May 18, 2018 at 12:02 PM R Smith wrote: > On 2018/05/18 11:50 AM, Lloyd wrote: > > I have a "buffer" containing data read from a file-based sqlite database. > > Is there any possibility for processing this "buffer" to query the data? > > But I imagine you had a more specific question in m

Re: [sqlite] Open and query sqlite db in a buffer

On 2018/05/18 11:50 AM, Lloyd wrote: Hi, I have a "buffer" containing data read from a file-based sqlite database. Is there any possibility for processing this "buffer" to query the data? Yes. But I imagine you had a more specific question in mind - please ask exactly what you would like to

Re: [sqlite] Open and query sqlite db in a buffer

On Fri, May 18, 2018 at 11:50 AM Lloyd wrote: > I have a "buffer" containing data read from a file-based sqlite database. > Is there any possibility for processing this "buffer" to query the data? > Only https://www.sqlite.org/draft/c3ref/deserialize.html comes to mind, and that's brand new and

[sqlite] Open and query sqlite db in a buffer

Hi, I have a "buffer" containing data read from a file-based sqlite database. Is there any possibility for processing this "buffer" to query the data? Thanks, Lloyd ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists