Reply to thread

Message

Hi,

Just saw this thread and since I have been playing with SQLite I thought I would add what I have found.

If the switch was to System.Data.SQLite (http://sqlite.phxsoftware.com)

When handled properly threading is not a problem.
The only restriction is a reader cannot read while the database is being
written to and the reverse (It has built-in retries).
Renamed it is a drop-in replacement for the standard sqlite dll file.
And it has other enhancements when programming with .Net such as
parameterized queries that can greatly increase speed.

Just my 2 cents

patrick

<blockquote data-quote="patrick" data-source="post: 138625" data-attributes="member: 12502">Hi,Just saw this thread and since I have been playing with SQLite I thought I would add what I have found.If the switch was to System.Data.SQLite (<a href="http://sqlite.phxsoftware.com" target="_blank">http://sqlite.phxsoftware.com</a>)When handled properly threading is not a problem. The only restriction is a reader cannot read while the database is being written to and the reverse (It has built-in retries).Renamed it is a drop-in replacement for the standard sqlite dll file.And it has other enhancements when programming with .Net such as parameterized queries that can greatly increase speed.Just my 2 cents <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />patrick</blockquote>

[QUOTE="patrick, post: 138625, member: 12502"] Hi, Just saw this thread and since I have been playing with SQLite I thought I would add what I have found. If the switch was to System.Data.SQLite ([url]http://sqlite.phxsoftware.com[/url]) When handled properly threading is not a problem. The only restriction is a reader cannot read while the database is being written to and the reverse (It has built-in retries). Renamed it is a drop-in replacement for the standard sqlite dll file. And it has other enhancements when programming with .Net such as parameterized queries that can greatly increase speed. Just my 2 cents :) patrick [/QUOTE]