Esto es a lo que me refiero: (viene del sitio oficial de SQLite3):
We are aware of no other embedded SQL database engine that supports as much concurrency as SQLite. SQLite allows multiple processes to have the database file open at once, and for multiple processes to read the database at once. When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds. Other processes just wait on the writer to finish then continue about their business. Other embedded SQL database engines typically only allow a single process to connect to the database at once.
Y la pagina es:
http://www.sqlite.org/lockingv3.html
Y la pregunta especifica es: Alguien lo ha logrado con aplicaciones Delphi? Y de ser asi, con que componentes?