Ubuntu QA:
BlogBrainstormPackage status
Log in
Ubuntu QA
The Ubuntu community has contributed 15752 ideas, 77802 comments, 1421719 votes

Idea #1886: Use SQLite For Big Config Files



up
-30
down
Written by doan the 29 Feb 08 at 22:19. Category: System.
Related to: Nothing/Others. Status: New
Description
Use SQLite for big data files instead of xml files. This could be a huge improvement. Only config files should be saved as xml. Xml-parsing is very slow and the biggest bottleneck.
Edit: I meant data files such as file history instead of preferences.
Tags: (none)

Attachments
No attachments.


Duplicates


Comments
tchernobog wrote on the 29 Feb 08 at 22:24
I'm sorry, but I don't think it's such a big win. Moreover, XML is human readable, a binary database is not.
XML is easily changeable, a binary db isn't.

ximen wrote on the 29 Feb 08 at 22:28
> XML is easily changeable, a binary db isn't.
XML (especially BIG XML) is NOT easily changeable or readable. Plain text in such case much better.

ToyKeeper wrote on the 29 Feb 08 at 22:36
FWIW, ignoring human-readability, binary databases have some drawbacks not yet mentioned. You can't, for example, rsync a bdb file from a x86 system to a ppc64 system and expect it to work. It requires a dump and reload, instead. It also is more likely to fail when restored from backup, if the backup occurs while the database is open.

I'm not a huge fan of XML, but moving to sqlite seems like a step in the wrong direction.

ronin wrote on the 29 Feb 08 at 22:42
so maybe YAML, it is human readable, but i don't know how about performance

doan wrote on the 1 Mar 08 at 13:24
Edit: I meant data files such as file history instead of preferences.
I can't change the text.


Post your comment