Database tab
Top  Previous  Next


Database for file annotations

CodedColor uses a local XML database in the standard version. For the professional version we are planning to integrate an open SQL database like Interbase or MS-Access, which can be installed on a network drive. The local XML database is stored in a compressed binary format. The location of the main database file is Workdirectory\Data\FILES.BIN, but you can export this to FILES.XML in order to view the data in the Internet Explorer or a simple text editor.

Storage

·Set the Autobackup option, if you are not doing manual backups regularly. This moves the old FILES.BIN to Workdirectory\Backup, before saving any changes from memory to disk. If anything goes wrong during storage (i.e. disk full), then you still have the backup file.  
·Set the Autosave option, if you are continuously adding annotations and keywords to your images. In the given time interval, the database FILES.BIN is written from memory to the folder Workdirectory\Data.  
·Press Save Database Now in the annotation dialog, while you are adding descriptions to your images.  

You should not use both Autobackup and Autosave at the same time, since a corrupted FILES.BIN could overwrite the healthy one in the Backup folder, without your chance of interaction. Read more in the Backup database topic.

Thumb database (Miniatures)

The thumb database is currently a directory containing thumb files. These are generated on-the-fly, when you open an Explorer window and view the contents of a directory. The thumb database (or cache) can be deleted, if you think that it is no longer synchronous with the annotation database. Use the Clear Cache button for this.

To learn more about the thumb database, open the newsgroup topic Why does it take long to browse a folder for the first time?

Options:  
 
·If you have limited disk space, uncheck the option Store large images in thumb database.  
 
·If you are worried about speed, decrease the Width of generated thumbs to less than 250 pixels, and increase the Thumb creation threshold to more than 100 kb.  
 
·Usually, you should Use thumb creation thread checked. Only turn off this option, if you experience problems with the display of thumbs on your system.  

icon_tipImportant Note
 
If the on-the-fly generation of thumbs slows down the browsing of folders, you have two useful options:  
 
1.You can create an Album for the folder and generate all thumbs immediately.  
2.You can enable a view option to generate all thumbs the moment you first visit a directory.  

icon_tipRelated Topics
 
·Why does it take long to browse a folder for the first time?  
·Are my images stored in the database?  
·Is the database compatible with other programs?  
·Why does the program stay active in the tray?  
·How do you handle broken links?  
·How stable is the database?  
·Search Database  
·Database Maintenance  
·Database Definition  
·Backup & Restore Database  

2004 © 1STEIN GmbH - CodedColor

CodedColor PhotoStudio by 1STEIN is a powerful and versatile photo organizer and image editing software for digital camera users. Features include photo editing & printing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF display, thumbnail generation, resize & resample images, jp2000, batch conversion, database keyword searching, red eye removal, color / sharpness / brightness & contrast correction, artefacts removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, gamma correction and screenshows with transition effects, panorama stitch, RAW, photo books and layouts, collages, histograms, white balance, PDF export, watermarks, etc. Please visit the CodedColor FotoStudio homepage to learn more or download a free copy!