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

2019-04-29 Thread Lullaby Dayal
join"); } #if 0 /* * select using the convencience wrapper sqlite3_exec() (exec uses a callback function) */ int callback(void *arg, int argc, char **argv, char **colName) { int i; for(i=0; i wrote: > On Mon, 29 Apr 2019 at 0

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

2019-04-28 Thread Lullaby Dayal
, 9:07 PM Jens Alfke wrote: > > > > 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

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

2019-04-25 Thread Lullaby Dayal
Hi all, Amending the previous email: We are using sqlite3_open() API to open the database. Thank you Lullaby On Fri, Apr 26, 2019, 2:09 AM Lullaby Dayal Hi all, > > We use sqlite3 in an embedded automotive system based on QNX hypervisor > running multiple virtual machines.

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

2019-04-25 Thread Lullaby Dayal
Hi all, We use sqlite3 in an embedded automotive system based on QNX hypervisor running multiple virtual machines. Software is architectured in a service oriented way. We are using C programming language. Multiple services (involving multiple threads) are using APIs in a single service to access

Re: [sqlite] Database corruption check.

2019-04-15 Thread Lullaby Dayal
running in QNX on an ARM board. Thank you! Lullaby On Sun, Apr 14, 2019, 5:38 PM Richard Hipp On 4/14/19, Lullaby Dayal wrote: > > > > For Sqlite database, as per my understanding, implementing pragma > > integrity_check won't guarantee all errors to be detected. > >

[sqlite] Database corruption check.

2019-04-14 Thread Lullaby Dayal
Hi, We are using sqlite for our embedded automotive system based on QNX. We have a requirement to check whether database is corrupted on start-up and replace it with default database if such a scenario happens. For Sqlite database, as per my understanding, implementing pragma integrity_check