![]() ![]() Note: a windows 64 bits executable cross-compiled under Linux as static program is. To convert blob data from digiKam database, just pass the PGF blob extracted from the digiKam database to the cli tool. Select the MySQL item from the Type drop-down list. To extract PGF thumbnails blobs from digiKam database, look the bash script 'exportthumbnails.sh'. If you’ve just installed digiKam, and you haven’t yet added any collection to it, choose Settings -> Configure digiKam, and switch to the Database section. There are two ways to switch digiKam from SQLite to MySQL. The simplest method is to click one of the rotate icons on the thumbnail or the preview or to click with the right mouse button for the context menu and select Rotate and then pick the direction of rotation needed. And before you proceed, note the database connection information such as MySQL server address, user name, and password - you’ll need it when configuring MySQL settings in digiKam. digiKam provides two ways to get your photographs the right way up. This tool is perfect to play common photographer workflow previously configured by end-user. Finally, digiKam include also a queue manager to batch operations on a set of images. It runs without digiKam images database support, but provides all Image Editor functions. Stack Exchange Network Stack Exchange network consists of 182 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. A stand-alone image editor version named ShowFoto is also available. ![]() ![]() You also have to create two MySQL databases: one for storing photo metadata (e.g., digikam) and the other for storing thumbnails (e.g., thumbnails-digikam). When I try to open Digikam, it returns: Failed to update the database sch. Apparently this contains thumbnails data. Kudos to the digikam developers - the database schema is quite self-explanatory thumbnails-digikam.db. Everything that is not in the other databases is in here. The setup requires that the database files are stored on a local drive which is fine except that the digiKam manual suggests I save the database on /var/local/lib/digiKam. Exiv2 already operate with database in separated threads without problem. Obviously, to use digiKam with MySQL, you need a MySQL server. Important: Do not access the SQLite database files while digikam is still running. digiKam maintenance tool to synchronize files metadata and database crash in. You can also use MySQL tools to back up and analyze digiKam’s data. This way, you can use multiple digiKam installations (e.g., on your notebook and desktop machine) to access and manage your photo collections. Of course, you might wonder why you’d want to switch to MySQL when SQLite already does a good job of managing the data? Using MySQL as digiKam’s database back-end allows you to store the data on a remote server. But the photo management application also provides support for the popular MySQL database engine, and it comes with a database migration tool that can help you to move your data from SQLite to MySQL. Transcribed from Dmitri Popov's blog, 15 October 2010īy default, digiKam uses SQLite as its back-end for storing important metadata and thumbnails. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |