sqlite可以从单个文件加载单个表吗？

Question

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

Answer 1

Would you be looking for the ATTACH and DETACH sqlite commands? You can call these with a query to any SQLite PDO object.

The commands allow you to attach a separate database file to the current session. An example would be:

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

You can then refer to the tables located in the attached database by their name (eg: SELECT * FROM entries) if there is no duplicate tables. If there is a conflict then they need to be namespaced with the database alias (eg: SELECT * FROM BlogEntries.entries)

Reference: SQLite Manual