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

2019-04-25 Thread Simon Slavin
On 26 Apr 2019, at 2:09am, Lullaby Dayal wrote: > 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

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. Software is

[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] Read/Write cycle

2019-04-25 Thread Kees Nuyt
Hi, On Tue, 23 Apr 2019 11:54:07 +0530, you wrote: > Hi All, > > I'm new to the Database, In my application i want to update a particular > data in a database for every 10 sec. What is the maximum read/write cycle > for the above scenario? Nobody can give an answer to that, there are many

Re: [sqlite] Read/Write cycle

2019-04-25 Thread Clemens Ladisch
manojkumar schnell wrote: > What is the maximum read/write cycle? The database puts no limit on how often you can read or update data. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Will ROWID be required to be unique in contentless Full text search

2019-04-25 Thread Dan Kennedy
On 25/4/62 07:58, paul tracy wrote: My question is whether or not I can rely on my use of non-unique rowids in FTS5 contentless tables to remain unenforced into the future of SQLite or am I exploiting an oversight that may be resolved in the future? Details ... I have a key-value pair SQLite

Re: [sqlite] Multiple Independent Database Instances

2019-04-25 Thread Tommy Lane
Have you tried utilizing a RAMdisk in your pipeline? Before adding a database to the queue of work move/copy the file to somewhere in /tmp/ then point the worker thread at it. The accesses should be much faster. Hope you’re making progress. -Tommy On Apr 22, 2019, at 6:44 PM, Keith Medcalf

[sqlite] Read/Write cycle

2019-04-25 Thread manojkumar schnell
Hi All, I'm new to the Database, In my application i want to update a particular data in a database for every 10 sec. What is the maximum read/write cycle for the above scenario? -- With Regards, S. Manoj Kumar. +91-99948 57534. ___ sqlite-users

[sqlite] SQLITE_ENABLE_MEMSYS5 compile time option requires value

2019-04-25 Thread Kurt Cecil
In order to compile with the SQLITE_ENABLE_MEMSYS5 option, setting it to a value is required, eg., -DSQLITE_ENABLE_MEMSYS5=1. The documentation makes no mention of explicitly setting a value. Regards -- Kurt Cecil Senior Software Engineer 15000 W