SQLite has a great feature for managing large volumes of data: multi-database apps. In this chapter, you'll see that by creating and attaching multiple databases to the same connection you can improve disk I/O performance and reliability.
Here are the topics covered:
Overview of the ATTACH function
Detaching databases using DETACH
Multi-database limits
Creating joins
Working with ATTACH AND DETACH in Swift
The ATTACH Statement
SQLite 3 provides the ATTACH DATABASE statement for multi-database queries. Although you could manage multiple database connections via an Objective-C ...
