Dynamic Attach / Detatch [SQLite]

[keidrych]

SQLite has a powerful feature whereby multiple smaller databases can be aggregated as independent files behind schemas.

In terms of PII & Individual security a dynamic Attach / Detach is extremely beneficial see Give Each of Your Users Their Own SQLite Database

At this time, the on-connect.sql requires static databases defined in-advance; it is possible to attach a db when visiting a page, but detach is unavailable

In Confidential Computing its quite important to be able to dynamically attach & detach SQLite databases

Would be great to see this ability to attach & detach SQLite DB added to the already excellent SQLPage

[lovasoa]

Hi !
This would indeed be a very useful thing. Not only for sqlite, but connecting to multiple databases in general would allow many new usecases. This is tracked in #66

If anyone is ready to design and implement the feature, or finance its development, that would be very welcome !