More than one sqlite file connection

1

This might be obvious to experienced database programmers.

Can a desktop app be connected to more than one sqlite database file at the same time in the desktop’s document folder?

2

Yes, of course. You can connect to as many SQLite databases as you like. *

You can even have multiple connections to the same database file.

  • The OS may limit the count of open files to a few thousand.
3

and you can have multiple SQLite databases connected to the same connection

4

Yes, and what Dave is talking about is SQLite’s ability to attach other databases to the one you’re currently connected to so you can perform cross-database queries. If you’re using Xojo, you can use AddDatabase to make these attachments.

5

That was not my experience with Xojo 2015r1 running Windows 11 (or was it Windows 10 ?): crash all around.

It started to work when I Open / Read or Write / Close on need. I stopped to leep ONE reference to the Open SQLite DB used in the Display / Read / Write windows…

Now, it may be something else I changed when modifying the original (and working code)