• Mac OS X,  Mac Security,  Mass Deployment

    sqlite3 and Address Book.app from the Command Line

    The Mac OS X program, Address Book uses sqlite3 to store information.  The actual database is located in each users Library/Application Support/AddressBook directory and called AddressBook-v22.abcddb.  In order to interfaces with Address Book.app you can use the sqlite3 command followed by the path to the database itself.  For example, the following command will simply dump you into a sqlite interactive command line environment: sqlite3 ~/Library/Application Support/AddressBook/AddressBook-v22.abcddb Once in the environment you can view databases, manually work with the data, etc.  The basic information about a contact is stored in the ZABCDRECORD table.  You can view the contents of this table using the following command: select * from ZABCDRECORD If you…