SQLite As Application File Format

Page 33 of 41
[prev] [next]

Consider using SQLite to store application data instead of XML or ad hoc text. Examples:
- Spreadsheet-like applications
- Single-user financial programs
- Vector graphics programs
- Presentation graphics
- Help viewers
- Planning and decision support tools
- Anything that has a data focus (not a text focus) and has File/Open and File/Save items on the main menu.

No need to write a parser and formatter

Updates are atomic and durable

Application data can be queried and changed using an external SQLite command-line client

Simplifies sharing of application file format among several different programs - Each program only deals with those parts of the file it cares about