I have been looking for years after a good data system for my 20,000+ pictures and have now found it.
Frequently Asked Questions
I have been looking for years after a good data system for my 20,000+ pictures and have now found it.
- Is there a place for a good "What is DBGallery" description?
- Is there a place which explains all the fields DBGallery supports?
- Does DBGallery work with DropBox?
- Can read-only permissions be set in DBGallery?
- Which image file formats does DBGallery support?
- Can Linux be used as the server for photos?
- Can multiple users share DBGallery's database?
- Which file formats does DBGallery write data to?
- May charitable organizations purchase DBGallery tax free?
- How can I rename a Handy Collection?
- How old a version can I upgrade from?
- Is it possible to use multiple databases?
- Isn't having a MySql database a little complex for most people?
- Why are JPG files not rotated when viewed?
- Can multiple images be rotated at once?
- Any tips for resolving client connection issues to the database?
- Can DBGallery import IPTC data from an existing MySql database?
- How do I move from a single-user to a multi-user setup?
- Can older versions run with the latest database?
- Can a port other than MySql's default 3306 be used?
- How do we upgrade the web server plug-in?
- How do we update each user's license when upgrading to DBGallery 6.5?
- What is the resolution for Runtime Error (at 27:1728)?
- What is DBGallery's Storage Limit?
- How to add a user?
- Where can I find a database creation script?
- Any tips for installing DBGallery?
- How do I search within the current results?
- Can DBGallery run on a Mac?
A document was recently written to answer that question: What is DBGallery?
Yes. PhotoMetaData.org has an excellent guide: http://www.photometadata.org/META-Resources-Field-Guide-to-Metadata. DBGallery supports the standard IPTC/XMP metadata fields, hence their field descriptions match DBGallery's.
Yes. Using DropBox, or similiar such tools such as SugarSync, you can store all your images in the cloud (i.e. in your DropBox). This is a great way to share images with others using DBGallery, where everyone who shares a DropBox sees shared photos in their instance of DBGallery. Each time any person adds images or updates data on their system, it gets sync'd with the DBGallery on all other computers!
Using DropBox is a great way to use the internet as the location of DBGallery's shared photo collection.
UPDATE: There is now a DBGallery YouTube Channel video on sharing images with DBGallery and DropBox:
After posting this video it's been asked if DBGallery works with SugarSync. It does! There is basically no difference in DBGallery itself as to whether it's working with DropBox or SugarSync folders. I.e. Both work equally as well from DBGallery's perspective.
Yes! Version 5.0 now supports permissions, including the setup of users with read-only access. Learn more here.
The following image formats are supported. If a format you require support for isn't listed here please let us know at Support@GRRSystems.com. Adding new formats is often just a matter of knowing they're required!
Adobe Digital NeGative (.DNG)
Adobe Illustrator Artwork (.AI)
Casio Digital Camera
Computer-aided Acquisition and Logistics Support (.CALS)
Digital Picture Exchange Format (.DPX)
Eastman Kodak Photo-CD
Encapsulated PostScript (.EPS)
GIMP's eXperimental Computing Facility (.Xcf)
Graphics Interchange Format (.GIF)
Joint Photographics Experts Group (.JPEG)
Kodak Digital Camera
Kodak Professional Digital Camera
Leica Digilux 2 RAW
Microsoft HD Photo
Paint Shop Pro Image
Portable Network Graphics (.PNG)
Radiance Picture File Format
SGI Image File Format
Sony Digital Camera Format (.PMP)
Tagged Interchange File Format (.TIFF)
X Windows Dump
Video - QuickTimeMOV
Yes. The only stipulation is that the tool used to drop the photo directories onto DBGallery, such as Windows Explorer, uses backslashes ( \ ) instead of forward slashes ( / ).
Yes. DBGallery has a multi-user client/server version. This version allows the client (DBGallery), the database(MySql), and the photo files to all reside on seperate computers. This works due to DBGallery's multi-tier architecture. There is a video on this as well as more detail on the Enterprise page.
The following are supported for writing of IPTC/XMP data directly to the file. (Note: all formats can have IPTC/XMP data written to the database (for searching and all other DBGallery funcationality), but not necessarily to the image file itself. That full list of supported formats can be viewed here.)
Most Camera RAW Formats
DNG (Digital Negative)
GIF (Graphic Interchange Format)
PNG (Portable Network Graphics)
TIFF (Tagged Image File Format)
AI (Adobe Illustrator Artwork)
EPS (Encapsulated PostScript)
Please Note: For audio, video, and pdf files, not all files belonging to each extension can be written to. Various factors come into play for these file types, such as version, codec, etc.
Video - QuickTime
Yes. The RegNow purchase option on the order page facilitates this. Let RegNow know you are wish to place a tax free order and they will create one for you. Your company's tax-free organization papers will be required at time of purchase. Contact GRR Systems via it's contact page if you require additional info or assistance.
1) Right-click on a Handy Collection
2) Choose Properties
3) Type the new name if the Name field
4) Press OK
Any version. Even if 1.0 is installed its ok to upgrade to the latest version.
Actually its also ok to downgrade. The database evolved by 'adding only', making it possible to move up or down versions. For example, if you upgrade to 6.0 and don't like it for some reason, you can downgrade to 5.9. Then if you want to try 6.1, you can go from 5.9 to 6.1.
Yes, if using the Enterprise version.
Using Multiple Databases
Sometimes it can be useful to run multiple databases. An example being completely unrelated image collections. While doing this is currently a little awkward it is quite easy and takes just a couple minutes. To use multiple databases follow these three steps...
From the main menu, select Settings & Help | Application Settings, then go to the Advanced Configuration tab. On that screen key the name of the desired database in the Database Name edit box. If you expect the database to already exist, press the Test Connection button to verify access, then press OK, at which point DBGallery will restart and use the that database. If the goal is to create a new database, simply press OK after keying the database name and IGNORE warnings that says the database doesn't exist. Keep pressing OK until DBGallery is restarted, at which point the new database will be automatically created.
Most people using DBGallery never have to know there is such a sophisticated database in the background. They can use DBGallery for many useful years without needing to know whats running in the background. And MySql takes up little memory and almost no resources when not being used by DBGallery.
So why such a major database system? Flexibility! When required, companies make good use of that powerful database. Photo data is an organizational asset. So there are two main reasons for the chosen database and DBGallery's architecture:
1) When keyed inside DBGallery and stored in the database, data is accessible by many other systems and applications. For example, data may be extracted by other applications and presented on the web via an organization's systems' development department.
2) Multiple people in an office environment can all access the same database and photos. In this case, the database resides on a central server with DBGallery running on everyone's machine. This is often called a client-server or multi-tiered environment.
About half of the usage of DBGallery is in these types of sophisticated setups. For more on this see the Enterprise/Office page here, or the video on this type of setup here.
But to repeat, for those wanting a simple but powerful system they never have to know this powerful database and architecture is included with DBGallery.
Only some file types (like RAWs) are auto-rotated by default. These are images which can't be rotated and saved to file.
JPG files may be set to rotate automatically. To do this add the extension(.jpg) to the "auto-rotate these file types" at the bottom of the Application Settings dialog. Neither DBGallery nor programs such as FastStone actually auto-rotate the file to disk. It's simply viewed upright. Both programs do of course rotate to file when manual rotation is chosen. So the only difference between DBG and FS is that DBG doesn't have jpgs set to auto-rotate.
Yes. Select all the thumbs to be rotated in one direction (this can be done by pressing the Ctrl key while thumbs are clicked with the left mouse button). Right click on all of the selected thumbs. Then choose one of the rotation options at the bottom of the context menu.
1) Always start by ensuring the client computer has access to the database computer. Do this by using a program such as Windows Explorer to go to the database machine. E.g. Type \\CorpDBServer into Explorer's address bar and press enter.
2) Using the same machine name or ip address used in the previous step and copy/paste it into the hostname field of the Advanced Configuration dialog in DBGallery. Copy/paste is recommend to avoid typing mistakes during these trouble moments. The \\ isn't required in the hostname, but if it's used DBGallery will strip it. Example of hostnames are CorpDBServer and 192.168.10.13
[Before moving to the next steps you will need the MySql GUI Tools. They are available at http://dev.mysql.com/downloads/gui-tools. Alternatively the MySql command line may be used for those who understand how to use that tool.]
3) Try connecting from the client to the database server using MySql Administrator. If using the default MySql install shipped with DBGallery use the following: Hostname=; Username=root; Password=dbg
4) The next logical thing to do is to ensure there are privileges in MySql for the client machine. This step is often required if using a MySql other than the one shipped with DBGallery (i.e. there was already a MySql installed). To do this use MySql Query Analyzer and do one of the following:
To grant privileges to all computers with access to the internal network, use:
GRANT ALL PRIVILEGES ON DBGallery.* TO root@'%' IDENTIFIED BY 'dbg';
[NOTE: DBGallery install defaults are used here. 'DBGallery' being the database name, 'root' being the username, and 'dbg' being the password. Change these for you environment if not using DBGallery's defaults.] To grant privileges to specific computers , use the following for each computer requiring access. This is a high security but fairly high maintenance but option each new client starting to use DBGallery will require this command to be executed:
GRANT ALL PRIVILEGES ON DBGallery.* TO root@'<machine name or ip>' IDENTIFIED BY 'dbg';
DBGallery has fairly simple table structures. A script could easily be written to copy data from your tables to DBGallery's. For example: Description is a varchar in StdAttrs. Copyright is a varchar in ImagesIPTCMetadata, as are about 30 other IPTC attributes. Any tool you might currently be using, such as MySql Administrator, would show the table structure once DBGallery was installed.
This question comes up in scenarios such as having used DBGallery on only one machine at home or the office and you're decided to add additional users.
There are two steps:
1) Perform configuration changes as detailed below. Don't be daunted by amount to text, it's really not all that difficult.
2) If not already done, purchase one additional copy of the DBGallery client for each machine it will be used on. Note that the database does not get installed on each machine.
Configuration changes required:
Below is the query to run to set things up to move to a shared database. Essentially it's just changing the database to have each image point to a network path instead of a local drive letter. This is required because a local drive such as C: doesn't mean much on other's computers, and the photos were likely initially added by dragging and dropping them from a local drive. Unless of course the photos were added from a network drive in the first place. If that is the case everything below won't be required. But if the photos were added from a local drive read on...
I've bolded the areas in the SQL below requiring change. In what's currently there win2k3-photo is the name of the computer and PhotoDisk is the a 'share' setup to provide access to photos on the network computer.
>>> These commands would be copy/pasted into the MySql Query Browser.
update images set img_loc = concat('\\\\win2k3-photo\\PhotoDisk', (select right(img_loc, (select CHAR_LENGTH(img_loc)-2)))) where (select left(img_loc, 2)) = 'C:';
update folders set folder_fullpath = concat('\\\\win2k3-photo\\PhotoDisk', (select right(folder_fullpath, (select CHAR_LENGTH(folder_fullpath)-2)))) where (select left(folder_fullpath, 2)) = 'C:';
Please backup your database before executing the query. See the Database Backup section of the User Guide here for help with that.
Two other things to note:
1. Write privileges are required for the share so IPTC/XMP data can be written to the files.
2. What might be seen on other's computers is 'Image Not Found' in the main thumbs view of DBGallery. That indicates that they don't have access to the share. There's a few options here: have users log onto the machine manually (not a great option), run DBGallery and a Net Use command from a batch file (e.g. "net use \\192.168.1.101\DriveD MyPassword /user:MyUserID", or use various other means to supply access to the share. Contact us direct via contact form if there are any issues with this.
There's also a short video on adding photos in a multi-user environment which has useful information to ensure photos added later are visible on each users' computer (watch it here). There's also a good look at a multi-user photo database setup in the video here.
Yes. Older versions of DBGallery can run on the latest version of the database. This is because the database tables are only every appended to. I.e. If there are five versions of DBGallery running around the office (or your home) which all hit the same database any one of them can be upgraded to the latest version. The others will continue to work as usual.
Yes. In the Advance Configuration options of the Enterprise version append the Database Server entry with “;port=XXXX” (without the quotes). E.g. “photoServer; Port=4306”.
If your company shares images over the internet via DBGallery's web server plug-in, download the latest version at http://dbgallery.com/download/DBGalleryWebServerPluginUpgrade.zip. Copy all files to your current web server folder, overriding existing files. Web.config and other configuration files are not included in the upgrade package and therefore will not override your local configuration setttings. Note that this upgrade will not work unless placed in a web server already running the DBGallery web server plug-in.
As you may know, your existing license keys will no longer work with DBGallery version 6.5. If you are on our maintenance plan or have a subscription the upgrade is free; simply email email@example.com to request your new keys or if you are unsure if you purchased the maintenance plan). Alternatively, upgrades may be purchased using the Software Upgrade section of our purchase page.
Once you have new license keys, there are three possible ways to have each user's computer updated and new license keys entered for each:
- For each computer where DBGallery is installed, update the desktop software. When the new version is first run, a message will appear with a warning that an old key is currently in use, followed by a dialog to enter the new key.
- For each computer where DBGallery is installed, update the desktop software. Then log into any DBGallery as an administrator and use the license manager to enter a new key for each machine.
- Email each existing DBGallery user their new license key with instructions to install the software update on their local computers.
If your company uses DBGallery's web server plug-in and wish to upgrade it as well, see its FAQ entry.
This error can occur during installation when not logged into Windows as an Administrator. To resolve this, login to Windows as an Administrator to install DBGallery. Afterwards any non-Administrator or Administrator login will work to run DBGallery.
Drive Space Limit
DBGallery doesn't store the images in it's database, they're stored on your drives. So the size limit is dependent on the amount of disk space available.
Database Record Count Limit
In it's database, there is a record for each image. Hence it's the database storage limit which comes into play, and since we're using MySQL as the database, the limit is very large. A number of factors determine the maximum number, but the worse case would be in the millions.
The first storage limiting factor most customer come across with DBGallery is performance beyond some number of images. This is dependent on the process, disk and network speed. For example, a fast and new 2013 computer (I7 3rd generation, 16 GB ram) on the same kind of server, performance degradates at as you head towards 1 million images.
A User is added from the Help | Application Settings | Permissions and Connections tab. Press User Permissions followed by Add New User. Enter the basic user information and select which role the user belongs to. Note that all users are assigned a role. For full instructions, including easy to follow screenshots, see our Permissions Tutorial (PDF).
A database creation script can be downloaded from here: http://www.dbgallery.com/download/DBGallery_6.3_DatabaseCreation.txt (right-click and choose Save Link As, naming it with a .sql extension).
This creation script can be used for DBGallery 6.3 and greater versions. Any version of DBGallery that runs after the database has been created will automatically make any required database table changes.
For an enterprise-level photo database system, DBGallery is exceptionally easy to install. Getting up an running with multiple computers connecting to the photo database usually takes less than an hour, rarely more than an hour or two. An overview of the steps are:
- Download DBGallery
- Install Step 1 of the setup program on the server
- Install Step 2 on computers connecting to the database
- On those computers, run DBGallery and enter the server name in the Database Server entry field when the Advanced Config dialog option appears.
- Finally, use either the Wizard to add photo locations which DBGallery will manage, or drag and drop those folders onto the program at any time later. Important: locations need to be a network location such as "\\server name\Photo Folders", or be a common shared drive letter, such as everyone having access to "P:\Photo Folders".
Beyond photos, also supported are videos, sound files, and PDFs.
Web server plugin
The web server plugin enables access to the DBGallery system from the internet using web browsers. Meant for those with technical webserver knowledge, download and install instructions for the plugin are here.
Installing DBGallery for personal use is extremely easy. Simply download the personal version of DBGallery and run the setup program. Then to add image folders, either use the wizard or drag and drop image folders onto DBGallery at any time.
Turn on the Advanced Query Options (Step 1 below) and then select the In checkbox (Step 2 below) after performing a search. This comes in handy in situation such as:
- Searching for images of an author(photographer) using a specific camera.
- Looking for all empty fields of all images added today.
Step 1: Turning on Advanced Query Options in DBGallery's Application Settings:
Step 2: Choose the In checkbox after performing an initial search, select another criteria and press Set Filter again.
DBGallery's primary interface is Windows only. There are 3 options for Mac users:
1. Parallels and VMWare Fusion can be used to run DBGallery on a Mac.
The image files and database may also reside on a Mac, or DBGallery can connect to the database and file servers running on Windows or Linux. Often there is one or two Mac users connecting the the same database as a larger number of users on Windows.
VMWare Fusion's Unity feature allows Windows applications to run on Mac desktop's. Run DBGallery as a Unity window and it appears DBGallery is running natively on a Mac! See how cleanly Unity run Windows applications in this YouTube video: http://www.youtube.com/watch?v=JIApJMzGzDQ
2. Use DBGallery's web server plugin so Mac users may seach and export via a browser.
DBGallery has an option to access the collection using a web browser but it cannot be used for organizing the collection or tagging images. It is excellent for users who are consumers of images, those who would search for and potentially export those images.
3. Use our cloud-based service.
Use the fully hosted solution where your images and the database reside in the cloud (we use Amazon cloud servers). The DBGallery Windows desktop is then accessed via RDP (Remote Desktop) or Amazon's WorkSpaces.