gwibber stores data in XDG_CONFIG_HOME directory

Bug #734917 reported by James Hunt
26
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Gwibber
New
Medium
Unassigned
gwibber (Ubuntu)
Triaged
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)

Tags: sqlite
Revision history for this message
James Hunt (jamesodhunt) wrote :
Omer Akram (om26er)
Changed in gwibber:
importance: Undecided → Medium
Changed in gwibber (Ubuntu):
importance: Undecided → Medium
Revision history for this message
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.

Revision history for this message
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

Revision history for this message
Victor Vargas (kamus) wrote :

great news, thanks Ken!

Changed in gwibber (Ubuntu):
status: New → Triaged
Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.