gwibber stores data in XDG_CONFIG_HOME directory

[James Hunt]

Binary package hint: gwibber

Gwibber appears to use an SQLite3 database to store the following details, each in its own database table:

(1) account details
(2) streams
(3) searches
(4) messages

The problem is that it places this database in ~/.config/gwibber/gwibber.sqlite. This directory equates to $XDG_CONFIG_HOME, but the use of this directory is invalid since (4) above is not "configuration". Admittedly, (1)-(3) inclusive *are* configuration, but on my system I have the following breakdown in rows / table:

accounts: 1 row.
searches: 4 rows.
streams: 24 rows.
messages: 61651 rows (!)

As a result, my gwibble.sqlite is 121MB and 99.952% of these rows equate to "data", not "configuration".

I would propose that gwibber either stores (1)-(3) in a simple .ini file, or as a simpler change, create two SQLite databases: one (tiny one!) for configuration in $XDG_CONFIG_HOME and the other for data in $XDG_DATA_HOME.

ProblemType: Bug
DistroRelease: Ubuntu 11.04
Package: gwibber 2.91.91-0ubuntu1
ProcVersionSignature: Ubuntu 2.6.38-5.32-generic 2.6.38-rc6
Uname: Linux 2.6.38-5-generic i686
Architecture: i386
Date: Mon Mar 14 15:43:29 2011
InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Alpha i386 (20110119)
ProcEnviron:
 LANGUAGE=en_GB:en
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
SourcePackage: gwibber
UpgradeStatus: No upgrade log present (probably fresh install)

[Ken VanDine (ken-vandine)]

I plan to move it to XDG_DATA_HOME as well as improve storage. Right now we store a bunch of json data uncompressed inside the database. I have a branch I am working on that compresses that, which saves a significant amount of space.

[Laura Czajkowski (czajkowski)]

Upgrading to natty, and gwibber is running but causing fans to keep spinning and not stopping.
czajkowski 725M 2011-03-14 19:17 /home/czajkowski/.config/gwibber/gwibber.sqlite

[Victor Vargas (kamus)]

great news, thanks Ken!

[Per Ångström (autark)]

re comment #4: see bug #799356.