Réparer une base sqlite corrompue
Trés utile ;)

Via : http://www.librement-votre.fr/shaarli/?D3lHhg

So, something's broken.
I executed a query like "select * from {table}" for each table in the database and all of them was executed successfully except one. This one caused the exactly same error I saw before -"database disk image is malformed". But in spite of error I got data from this table.

So if I can read data then I can recreate my database.
I started searching for a way how to dump data from the database into a SQL-script with INSERTs. This post helped me a lot.
I needed to download SQLite shell. This tool allows to export data in many forms including INSERTs.
I run "sqlite3.exe storage.data" where "storage.data" is my corrupted database file.
The following script exports all content (as INSERTs) with schema into "dump_all.sql" file:

sqlite> .mode insert
sqlite> .output dump_all.sql
sqlite> .dump

Then exit (Ctrl-C, Ctrl-Z or ".exit") and run again: "sqlite3.exe storage.fixed.data", where "storage.fixed.data" is name of non-existing file for my resurrected database.
The following script reads commands from "dump_all.sql" script file and recreates all database.

sqlite> .read dump_all.sql

After this procedure I got a new database file with all content from the corrupted file.

Tiens je vais tester cette librairie ;)

via @seb : http://sebsauvage.net/links/?lPj1Ew

REFLECTION... il va falloir que je fasse mon propre moteur de flux RSS parce que la ca devient n'importe quoi tinytiny est lourd et rsslounge de même...

(une base sqlite peut etre ou alors une mysql mais avec une cron...)

http://magpierss.sourceforge.net/
http://www.presse-agrume.net/api-simplepie.html

Un logiciel permettant de gérer les bases de données SQLite, pratique ;)