Re: [sqlite] Making blob as a sqlite database.

On 4/26/19, Mohd Radzi Ibrahim wrote: > Hi, is there a vfs that could be used to open a blob column as a database? I think you probably want the sqlite3_deserialize() interface. https://www.sqlite.org/c3ref/deserialize.html -- D. Richard Hipp d...@sqlite.org

[sqlite] Making blob as a sqlite database.

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

Re: [sqlite] Regarding sqlite3 reliability in using in service oriented architecture

> On Apr 25, 2019, at 6:09 PM, Lullaby Dayal wrote: > > A single database connection is shared > among all these services. More than one service access the service API to > read/write database at the same time. No locking is implemented in our > service accessing the database. The one issue th

[sqlite] Custom collation of blobs

We are using SQLite blobs to store some structured values, and need control over how they are collated in queries, i.e. memcmp is not the correct ordering. We’ve registered a custom collating function, but unfortunately it doesn’t get called. According to the docs, collating functions are only u

Re: [sqlite] Debugging sqlite3.c

If I put this line at the top of sqlite3.c #define SQLITE_DEBUG 1 should that be the same as setting SQLITE_DEBUG? I’ve tried it and the IDE still doesn’t add debug info for the sqlite3.c file. From: x Sent: 26 April 2019 13:23 To: SQLite mailing list

Re: [sqlite] .expert output help

On 26/4/62 23:56, Jose Isaias Cabrera wrote: this query. If you try ".expert -verbose", it will tell you the other This is the output from --verbose sqlite> .expert --verbose sqlite> SELECT a.*,sum(b.AnnualDossier) as Dossier FROM Project_List AS a ...> LEFT JOIN Project_ABT_Budget AS b

Re: [sqlite] .expert output help

Dan Kennedy, on Friday, April 26, 2019 12:13 PM wrote... >On 26/4/62 21:30, Jose Isaias Cabrera wrote: >Hey! Somebody tried it out! Thanks! :) I have been using it for a while. ;-) I have been adding INDEXes for queries used a lot... >this query. If you try ".expert -verbose", it will tell you

Re: [sqlite] .expert output help

On 26/4/62 21:30, Jose Isaias Cabrera wrote: Greetings. sqlite> .expert sqlite> SELECT a.*,sum(b.AnnualDossier) as Dossier FROM Project_List AS a ...> LEFT JOIN Project_ABT_Budget AS b ON a.ProjID = b.ProjID ...> AND ...> b.InsertDate = ...> (SELECT MAX(InsertDate) FROM Pro

Re: [sqlite] Regarding sqlite3 reliability in using in service oriented architecture

> You will be hard-pressed to buy a new car these days that isn't > running either QNX or Android or both. Not my '73 Ford Maverick. :-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/li

Re: [sqlite] .expert output help

Simon Slavin on Friday, April 26, 2019 10:50 AM wrote... >On 26 Apr 2019, at 3:30pm, Jose Isaias Cabrera wrote: >Once you have defined those indices, execute the ANALZE command, then try >the .expert again. Thanks. >What led to you using WHERE 1=1 ? An apparent bug ? Long story. The app has ma

Re: [sqlite] Regarding sqlite3 reliability in using in service oriented architecture

On 26 Apr 2019, at 3:48pm, James K. Lowden wrote: > Am I the only one who reads a sentence like that and thinks, "I don't want to > drive that car"? Databases are used in black boxes (which every car has these days) and in infotainment and SatNav systems. It might not be involved in a safety

Re: [sqlite] Regarding sqlite3 reliability in using in service oriented architecture

On 4/26/19, James K. Lowden wrote: > On Fri, 26 Apr 2019 02:09:33 +0100 > Lullaby Dayal wrote: > >> We use sqlite3 in an embedded automotive system based on QNX >> hypervisor running multiple virtual machines. > > Am I the only one who reads a sentence like that and thinks, "I don't > want to dri

Re: [sqlite] .expert output help

On 26 Apr 2019, at 3:30pm, Jose Isaias Cabrera wrote: > -- On line 5 of the resulted output , > > SCAN TABLE Project_List USING COVERING INDEX Project_Name > > Why is it scanning the table using that INDEX if there is no "Project_Name" > referenced in the query? That is one of the fields of Pr

Re: [sqlite] Regarding sqlite3 reliability in using in service oriented architecture

On Fri, 26 Apr 2019 02:09:33 +0100 Lullaby Dayal wrote: > We use sqlite3 in an embedded automotive system based on QNX > hypervisor running multiple virtual machines. Am I the only one who reads a sentence like that and thinks, "I don't want to drive that car"? I hope the embedded automotive

[sqlite] .expert output help

Greetings. I want to search the DB for all projects owned by "jic" and I have queried the DB with the following: SQLite version 3.28.0 2019-04-16 19:49:53 Enter ".help" for usage hints. sqlite> .expert sqlite> SELECT a.*,sum(b.AnnualDossier) as Dossier FROM Project_List AS a ...> LEFT JOIN

[sqlite] Debugging sqlite3.c

Could anyone give me an idiot’s guide on how to do this in the rad studio 10 IDE? I’ve tried adding DEBUG_SQLITE to “Project | Options | C++ (Shared Options) | Conditional defines ... (for Debug configuration – 32 bit Windows platform)” but it doesn’t seem to work. Looked elsewhere in the Option

[sqlite] Bug report: Segfault in sqlite3_clear_bindings when statement is nullptr

Hi together, I want to report a (possible) bug in sqlite3. When sqlite3_clear_bindings is called with a nullptr argument, then a SEGFAULT occurs. From the behavior of the other methods which use statement as a parameter I expected the behaviour that sqlite3_clear_bindings with a nullptr argument