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.




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?




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





CodedColor PhotoStudio © 2023 1STEIN GmbH

CodedColor PhotoStudio by 1STEIN is an award-winning 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, stich panoramas, convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), burn digital watermarks, correct colors, batch convert and correct images and generate a web album in HTML5. The software is easier to use than Photoshop, but more versatile than ACDSee, Picasa, Irfanview or Gimp. Many magazines consider it to be the Swiss Knife of Image Editing. Have a look at our Before / After tutorials to get an idea of the powerful capabilities. The software comes with a detailed handbook and a fast database to store EXIF/IPTC data and color information. CodedColor PhotoStudio is the ideal image editing tool for every-day and professional digital camera users. The user friendly interface combines features like expert photo editing & printing, layer editing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor, GPS tagging, perspective correction, barrel distortion, effects, thumbnail generation, resize & resample images, batch conversion, database keyword searching, red eye removal, color/sharpness/brightness & contrast correction, artifact removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, transparency (alpha channel) and layers, gamma correction, screen shows 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, photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, HEIC, HEIF, AVIF and all current RAW formats. The installation includes our the CodedColor Publisher, a versatile photo layout and DTP tool to create individual and rich photo books.