SQLite As Application File Format - First Approach

Page 34 of 41 [prev] [next]

Features:

• File/Open menu option does sqlite3 db $filename
• All changes written directly to the disk file - there is no File/Save menu option

Advantages:

• Do not need to read in the whole file - only those parts in active use
• Little or no work is lost if there is a crash or power failure
• Allows multiple simultaneous edits of the same application file

Disadvantages:

• Different from what most users are familiar with
• No way to abandon changes - needs a good undo mechanism to compensate