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.