Problems with SQLite transactions

[stcarrez]

SQLite has limited support for database transactions.

• Unlike Mysql and PostgreSQL, the whole database is locked when a transaction is in progress where MySQL and PostgreSQL will lock only the table or even the row that is used by the transaction.
• ADO 2.3 and earlier is using a single SQLite database instance that can be shared by several threads. It was done that way to solve database transaction issues and SQLite limitations.
• this single SQLite instance makes the database transaction support incorrect in the ADO library.