gwibber stores data in XDG_CONFIG_HOME directory

Bug #734917 reported by James Hunt on 2011-03-14
26
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Gwibber
Medium
Unassigned
gwibber (Ubuntu)
Medium
Unassigned

Bug Description

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)

James Hunt (jamesodhunt) wrote :
Omer Akram (om26er) on 2011-03-14
Changed in gwibber:
importance: Undecided → Medium
Changed in gwibber (Ubuntu):
importance: Undecided → Medium
Ken VanDine (ken-vandine) wrote :

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) wrote :

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

Kamus (kamus) wrote :

great news, thanks Ken!

Changed in gwibber (Ubuntu):
status: New → Triaged
Per Ångström (autark) wrote :

re comment #4: see bug #799356.

tags: added: sqlite
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers