SQLite As Application File Format - Third Approach

Page 36 of 41 [prev] [next]

Features:

• File/Open menu option creates an in-memory database then copies the disk database into the in-memory database
• File/Save copies the in-memory database back to disk
• Use the SQLite ATTACH command to do the copying efficiently

Advantages:

• Similar to the traditional application metaphor and hence more familiar to both users and programmers
• Changes can be abandoned at any time

Disadvantages:

• Requires enough memory to hold the entire application file
• Work might be lost following a crash or power failure
• Slower operation of File/Open and File/Save due to the need to copy the entire database