TOPIC:

Hello,
I continue my CT exploration
I used Absolute Database Multiuser in my old time with delphi.
I'd like to find an equivalent with CT i.e. a single file database with SQL support.
I can not use mysql/firebird or else because they often being in use on computers where i deploy my apps. So i need to be independent from them.
Sqllite seems to be a good choice but it is not multiuser. isn't it ?
Thanks for reading and maybe answer.
Bye.

Sir
I think Sqllite3 is a good choice
please read here for multiuser ability

(5) Can multiple applications or multiple instances of the same application access a single database file at the same time?
Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.
....
....

I often use file databases, because many customer does not allow the installation of a sql-server.
I make every access to the database in following scheme:
-Connect
-Query, Insert or Update
-Disconnect
Caution is particularly in UPDATE important, INSERT and SELECT is not the problem.

You can develop server application with SQLite or embedded Firebird, and then develop clients that talk to this application and not to database directly. It used to be hard and time consuming, but now it's not that hard thanks to Mormot .

This might also be worth a look, to be aware of what choices are available:
wiki.freepascal.org/Lazarus_Database_Overview

So much answers, thanks you all, guys.
Sqllite seems to be the lead to follow. Ok then.
I'm going to study all those links... Thanks you very much.