SQLite Channel

[hupili]

Enable simple SQLite storage is easy. What we want is a unified schema there. Say can store raw json associate with each status for future retrieval; store common fields in a flat manner, e.g. platform, status_id, time, content, etc.

This depends on the Restructure of status class. Should come after Issue #14.

[hupili]

checkout 3d9743c for a workable version. sqlite3 is prerequisite. Have not developed error-tolerance code when sqlite3 is not present.

[hupili]

It's now working stable for one day.

[hupili]

There are encoding problems with SQLite.

For other platforms, the update() method can deal with utf-8 encoded str or unicode. For SQLite, it has problem dealing with utf-8 encoded str.

The workaround is, do this before passing to update():

console_input(text)

This is what we did in snscli.py.

[hupili]

Close to clean issue.

If there is some problem, we can bring it up again.

It can be used to do backup or easily relay messages between multiple instances of snsapi locally.