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  

2010 © 1STEIN GmbH - CodedColor

CodedColor PhotoStudio by 1STEIN is a Windows photo viewer and editor to organize, edit, resize, reformat, correct, compare, sort, watermark, annotate and print digital images, and to edit EXIF and IPTC data in digital photos. You can rename multiple images, remove scratches, create panorama pictures (stitch), convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), send images via Skype, send photo SMS, burn digital watermarks, correct colors, run a screenshow, convert and correct JPEG images in a batch process, rename fields, open pictures and image folders from the Explorer, generate a webalbum in HTML and compress JPG images. The CodedColor full version is not free, but during registration you can choose the Freeware edition, in which some functions are deactivated. After the download you can try the PhotoStudio shareware for 30 days without any restrictions. The CodedColor software interface looks very similar to ACDSee, is easier to use than Photoshop and more versatile than Picasa and Irfanview, but still contains editing and correction features as effective as Paintshop. Have a look at our Before / After tutorials, in order to get an idea of the powerful editor capabilities. The software comes with a detailed handbook and a fast database to store EXIF / IPTC data and color informationen. CodedColor PhotoStudio is a powerful and versatile photo organizer and image editing software for digital camera users. The user friendly interface includes features like photo editing & printing, web & flash album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor and display, GPS tagging, perspective correction, barrel distortion, effects, 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, transparency (alpha channel), gamma correction, print ordering and screenshows with many transition effects, watermark text, image annotations, panorama stitch & animation, video capture, PDF album export, photo layouts, collages, frames, shadows, histograms, automatic white balance, skype photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, and all current RAW formats. Visit the CodedColor FotoStudio homepage to learn more and download a free copy! Includes BYNGO MMS messenger and CodedColor Publisher, a versatile photo layout and DTP tool, from which you can order individual photobooks through KODAK.