History Database

Blink stores the history of sessions and chat messages in a Sqlite database. The location of the database is:

~/Library/Containers/com.agprojects.Blink/Data/Library/Application Support/Blink Pro/history/history.sqlite

If for any reason the database becomes corrupted, which may manifest itself by errors reported graphically by Blink itself or in the Console application you may work around the problems in several ways.

First, backup your database in case you need the uncorrupted data in the future. You can do this by copying the history.sqlite file to another location. The file can be opened in Terminal application using sqlite3 program. You can dump the old data in the corrupted database as follows:

#:~/Library/Containers/com.agprojects.Blink/Data/Library/Application Support/Blink Pro/history$sqlite3 history.sqlite
SQLite version 3.7.7 2011-06-25 16:35:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from sessions;
sqlite> select * from chat_messages;

Restore Procedure

Try the following in this order to solve a data corruption problem:

  • Clear the session history table, go to menu History->Clear History. The session table will be emptied and the chat messages are not affected. Restart Blink.
  • Stop Blink. Remove history.sqlite file, the history database will be recreated at start time. Use the backup file for reading the old data using the sqlite3 command line utility.