History Database

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;