Applications that use SQLite databases

Which applications use SQLite to store program data?
Many applications on Mac OS X use SQLite to store information - including Apple's own Safari and Mail applications. You can use the Actual ODBC Driver for Open Source Databases to import the information stored in the database into an ODBC-ready application, such as Excel, FileMaker Pro, or even a PHP web page.

Here is a partial list of applications which use SQLite. If you are a developer and would like your application listed here, please e-mail us at support@actualtech.com.

NOTE: you should never modify an application's data outside of the application, unless instructed to by the application's developer. We only recommend using the driver to read data from the database (using the SELECT SQL statement). You should not use the driver to modify the database - doing so may make the file unusable by the application.

Contacts
The addresses in the Mac OS X Address Book are stored in a SQLite database. The database is located at /Users/account name/Library/Application Support/AddressBook/AddressBook-v22.abcddb

Calendar
The iCal application in Mac OS X stores calendar information in a SQLite database. The database is located at /Users/account name/Library/Calendars/Calendar Cache

Safari
Apple's Safari web browser stores RSS articles in a SQLite database. The database is located at /Users/account name/Library/Syndication/Database3

Mail
Apple's Mail application stores extensive information in SQLite, including e-mail addresses and message data. The database is located at /Users/account name/Library/Mail/Envelope Index

iPhoto
iPhoto introduced the use of a SQLite database to store information about the pictures stored in the iPhoto library. The database is located at /Users/account name/Pictures/iPhoto Library/iPhotoMain.db

Yojimbo
Yojimbo is an organizer application that lets you store and search for information such as passwords, serial numbers and web articles. Yojimbo stores its information in a SQLite database located at /Users/account name/Application Support/Yojimbo/Database.sqlite

VoodoPad
VoodooPad is a free form organizer application. Nearly any kind of information can be entered and searched, including text and sketches. Each VoodooPadd document has its own SQLite database associated with it. Using the Finder, select the ".vpdoc" file and "Show Package Contents". The SQLite database is named store.vpsqlite.

... more to come.