((Your post misses a detail which changes the answers to your questions:
are these threads each using their own connection or do they share one
connection ? ))
Please find my test program below. I haven't used any such advanced
features in my code unless it is already configured in my prebuilt
On Mon, 29 Apr 2019 at 01:22, Lullaby Dayal
wrote:
>
> Considering all this, I have written a test application running on Linux
> with sqlite3 library in serialized mode. My test application has 200
> parallel threads in which 100 threads are executing SELECT * operation from
> a table and 100
On Thursday, 25 April, 2019 19:10, 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.
Interestingly, the default "database" service in QNX is (or at least was
On Sunday, 28 April, 2019 11:23, Lullaby Dayal asked:
To answer your specific questions:
>So my questions are:-
>1. In auto-commit mode in serialized threading mode, how command
>queueing works?
auto-commit and transactions are an attribute of the connection and have
nothing whatsoever to
...@mailinglists.sqlite.org] On Behalf Of Lullaby Dayal
>Sent: Sunday, 28 April, 2019 11:23
>To: SQLite mailing list
>Subject: Re: [sqlite] Regarding sqlite3 reliability in using in
>service oriented architecture
>
>Thank you for your valuable suggestion.
>
>As you mentioned, th
On 28 Apr 2019, at 6:22pm, Lullaby Dayal wrote:
> SQLite supports an unlimited number of simultaneous readers, but it will only
> allow one writer at any instant in time.
Please note that this is a statement about how one journal mode (WAL) works.
Are you telling us that you're using that
Thank you for your valuable suggestion.
As you mentioned, the possibility of a concurrent transaction with
auto-commit transaction is already handled in our design using some flag
variables.
I would like to understand some points discussed in sqlite3 documentation
in detail.
1. Compile time
> 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
> 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
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
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
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
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
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
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
15 matches
Mail list logo