lucacerone
lucacerone

Reputation: 10119

SQLite attach all databases in a directory

Hi I have an sqlite database called 'main.db' where I attach all the databases that are in the directory 'db' (e.g. 'db/db1.db' , 'db/db2.db' and so on).

I would like to know if there is a way to save 'main.db' so that the attachements are remembered across sessions.

Also when in 'main.db' how can I create a new database 'db/db3.db' and have it attached automatically when I open 'main.db'?

I usually use the sqlite3 shell for my databases maintenance.

Upvotes: 0

Views: 259

Answers (1)

CL.
CL.

Reputation: 180080

Attachments are not stored in the database; they are local to a connection.

Any attachments must be done explicitly by the application that has opened the database.

Upvotes: 1

Related Questions