You are not logged in.
Is it allowed to have multiple TRestServerDB instances in one Process?
The TRestServerDB instances are created using:
FServer := TRestServerDB.Create(FSQLModel, SQLITE_MEMORY_DATABASE_NAME, False, '');
Offline
OK- it seems fine based on SQLite documentation:
https://www.sqlite.org/inmemorydb.html
"Opening two database connections each with the filename ":memory:" will create two independent in-memory databases."
Offline
You can create as many TRestServerDB as you need.
And not only for in-memory databases, but also for files.
On a SaaS-like solution, I usually create a DB file per client organization, with a simple TRestServerDB cache for a few minutes. The idea is to have each organization having its own data folder. Easy to backup (or not), and move to another instance.
Offline