Can sqlite load individual tables from separate files?

Question

I heard that SQLite can do this (to avoid synchronization issues in heavy traffic scenarios), is that true? If so, how do I do this with PDO in PHP?

Answer 1

Will you look for ATTACH and DETACH sqlite commands? You can invoke them by querying any SQLite PDO object.

Commands allow you to attach a separate database file to the current session. An example is:

$connection->query('ATTACH DATABASE blog_entries.sqlite AS BlogEntries;');

, , (: SELECT * FROM entries), . , (: SELECT * FROM BlogEntries.entries)

: SQLite

Answer 2

( , DSN PDO sqlite: memory:) .