2 ms·
You can attach to databases dynamically in queries and join across them. I probably wouldn't (in an ordinary data model) do per-user, but I would consider it fo
by tptacek 3y ago
You can attach to databases dynamically in queries and join across them. I probably wouldn't (in an ordinary data model) do per-user, but I would consider it for different functional areas.
- simonw 3y agoThere's a limit on how many databases you can attach to the same connection (SQLITE_LIMIT_ATTACHED), it defaults to 10.
- samatman 3y agoWorth noting that this limit can be raised up to 125 (as I'm sure Simon is aware). I would say that if one needs to query across more SQLite files than that, it's definitely time for a different data policy.