[Digikam-users] Same again: impossible to run Digikam 2.x

[Marie-Noëlle Augendre]

Thank you for this information.

Digikam is the only SQLite-based program I use; I'm much more at ease with
MySQL that I use with many other programs.

However, I would very much like not to need to learn the commands for each
language (regarding Digikam, I'm an "end-user"). In Piwigo for example, the
interface provides a simple menu option to check and/or repair the
database, so that the user can run it as often as he wants too, without
having to look for commands syntax he'll only use a couple of times a year.

I think this kind of function will be a very useful addition to Digikam. So
not every photograph using Linux will need to become some DB specialist.

Marie-Noëlle

2011/12/17 Jean-François Rabasse <jean-francois.rabasse at wanadoo.fr>

>
> Marie-Noëlle,
>
> apart from Digikam itself, you can check integrity of your SQLite DB via
> the sqlite3 command line tools, e.g. :
>
>  sqlite3 digikam4.db 'pragma integrity_check;'
>
> If your database is corrupted (in a SQL way), sqlite3 will complain.
> If sqlite3 says your DB is fine, and Digikam complains after an upgrade,
> this may indicate the new versions has some slight modifications in its
> DB schema and compatibility isn't assumed.
>
> Anyway, a useful practice when upgrading DB applications, or DB management
> system, e.g. a newer version of the libqlite3, is to do export /import of
> the DB under SQL format. SQL format will be a text file with all required
> SQL commands to rebuild the whole DB. Thus, the operation is supposed to
> be independent of the binary internal representation of the DB.
>
> SQL export, before upgrade :
>  sqlite3 digikam4.db .dump > dk-dump.sql
>
> SQL import, after upgrade :
>  sqlite3 digikam4.db < dk-dump.sql
>
> Another advantage of doing such export  /import, is that the export file
> will contain only pertinent data informations, not garbage, deleted images,
> etc. So, after import you're supposed to start with a fresh and clean DB.
>
> Regards,
> Jean-François
>
>
> NB: same kind of operation, SQL export, SQL import, can be done with any
> RDBMS, SQLite3 of course, but also Oracle, MySQL, PostgreSQL. One has just
> to check proper syntax in the RDBMS manual.
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>


-- 
Une galerie photos, un blog ... pourquoi pas ? Webmaster en
herbe<http://www.webmaster-en-herbe.net/>

Parcourez les Cévennes à ma façon : Cévennes
Plurielles<http://www.cevennes-plurielles.com/>

Et toutes mes autres publications à partir de ma page d'accueil
générale<http://www.marie-noelle-augendre.com/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20111217/4f21efd8/attachment.html>