Breaking down Tweetdeck configuration and storage.

Posted on | March 14, 2009 | 1 Comment

I decided to look at the possibility of eventually exporting the configuration data contained in TweetDeck:

You can find the groups, friends, and columns settings in a SQLite database file in a path like:
C:\Documents and Settings\{USERNAME}\Application Data\TweetDeckFast.{some hideously long hex string}\Local Store\td_{version?}_{twitter username}.db

I used SQLite database browser to look at this file. (I copied it first, of course.) The data storage is pretty simple.

 SQL |   copy code | ?  
1 CREATE TABLE COLUMNS (cID INTEGER PRIMARY KEY, cName TEXT, cOrder INTEGER, cType INTEGER, cTerm TEXT);
2 CREATE TABLE friends (fUserID INTEGER PRIMARY KEY, fName TEXT, fScreenName TEXT, fScreenNameHTML TEXT, fLocation TEXT, fDescription TEXT, fProfileImageURL TEXT, fUrl TEXT, fProtected TEXT, fFollowers INTEGER);
3 CREATE TABLE groups (gID INTEGER PRIMARY KEY, gCID INTEGER, gUserID INTEGER);
4 CREATE TABLE queue (qID INTEGER PRIMARY KEY, qText TEXT);
5 CREATE TABLE sinceID (sID INTEGER PRIMARY KEY, sService TEXT, sType TEXT, sTerm TEXT, sTID INTEGER);

The columns table actually defines the groups, group names, and group displays.

The groups table provides the linkage between the columns and friends tables.

There is a preferences_{username}.xml in this same directory as well, for colors, positioning, etc...

Share and Enjoy:

Comments

One Response to “Breaking down Tweetdeck configuration and storage.”

Thomas Powell
March 14th, 2009 @ 7:58 pm
Is COLUMNS a legal table name in more heavy duty SQL implementations?

Tech Space

Experiencing Tech as a Professional Techie

Breaking down Tweetdeck configuration and storage.

Comments

Feed links

Tags

Pages

Archives

Acknowledgements and Links

About Me

Blogroll

Feed links

Tech Updates

Recent Posts

Recent Comments

1	CREATE TABLE COLUMNS (cID INTEGER PRIMARY KEY, cName TEXT, cOrder INTEGER, cType INTEGER, cTerm TEXT);
2	CREATE TABLE friends (fUserID INTEGER PRIMARY KEY, fName TEXT, fScreenName TEXT, fScreenNameHTML TEXT, fLocation TEXT, fDescription TEXT, fProfileImageURL TEXT, fUrl TEXT, fProtected TEXT, fFollowers INTEGER);
3	CREATE TABLE groups (gID INTEGER PRIMARY KEY, gCID INTEGER, gUserID INTEGER);
4	CREATE TABLE queue (qID INTEGER PRIMARY KEY, qText TEXT);
5	CREATE TABLE sinceID (sID INTEGER PRIMARY KEY, sService TEXT, sType TEXT, sTerm TEXT, sTID INTEGER);