Search code examples
databasesqlitedatabase-partitioning

SQLite database partitioning

I want to create sqlite partition structure, I created 3 databases, I attached those 3 databases to another database which will be parent with

ATTACH DATABASE '1.db' as 1
ATTACH DATABASE '2.db' as 2
ATTACH DATABASE '3.db' as 3

after i .quit the parent database the database attachments detach, How can I keep them attached even if I quit the database? Thanks.

Solution

  • Attachments are never permanent.

    Every program that opens the database needs to make any attachments it needs.

    If you really think you need partitioning, using another database might be a better idea.