SQLite Attach Database

ATTACH DATABASE 'other.db' AS other; # attach database
.databases # list attached databases

SELECT * FROM other.users; # query attached database
INSERT INTO other.logs SELECT * FROM main.logs; # copy data

SELECT u.name, o.total
FROM main.users u
JOIN other.orders o ON u.id = o.user_id; # join tables from different DBs

DETACH DATABASE other; # detach database

ATTACH DATABASE '' AS temp; # attach in-memory database
ATTACH DATABASE 'file::memory:?cache=shared' AS mem; # shared memory DB