Every day we offer FREE licensed software you’d have to buy otherwise.

DBGallery Giveaway
$49.95
EXPIRED

Giveaway of the day — DBGallery

Photo data is typically under-appreciated and is not used efficiently - DBGallery changes that!
$49.95 EXPIRED
User rating: 151 (19%) 635 (81%) 42 comments

DBGallery was available as a giveaway on May 30, 2011!

Today Giveaway of the Day
$19.99
free today
Not interested in snooping presets in Windows 10?

DBGallery is a tool for organizing and quick search of the photos. Photo data is typically under-appreciated and is not used efficiently - DBGallery changes that!

Key features:

  • IPTC support. Just about all IPTC data fields are supported. Picks up existing IPTC data (as photos are added to the database), and write to the file directly as well.
  • Data search. Search is based on keywords, subject, author, notes, and description, aperture, ISO, country, photographer, etcetera...over 50 fields altogether.
  • Setting geographical location data for a photo is known as GeoTagging.
  • Logical views. A physical view of photos is how they are physically stored in folders (the old way of trying to find photos), whereas logical views are views of photos organized by photo data. They may be organized by camera, year, month, ISO, number of views, and dozens more.
  • eMailGallery offers an extremely quick and convenient way to email photos.
  • WebGallery generates a website of selected images.
  • and more...

System Requirements:

Windows 7, XP, or Vista (x32 or x64); Screen resolution: 1024 x 768 or higher

Publisher:

GRR Systems

Homepage:

http://grrsystems.com/

File Size:

21.2 MB

Price:

$49.95

GIVEAWAY download basket

Developed by CyberLink Corp.
Developed by PhotoInstrument
Create, manage, copy and edit custom images.
Developed by Mirillis Ltd.

Comments on DBGallery

Thank you for voting!
Please add a comment explaining the reason behind your vote.
#42

Perhaps I wasn't clear enough in my comments about facial recognition. I find that XP fanboys know nothing about Vista+, and seem incapable of reading help files (Windows Help and Support has been available in Windows probably forever, certainly in XP+) and online documentation. Like thinking that you have to create and carefully configure and manage some database, or that computers are incapable of facial recognition. Here's a portion of the facial recognition features in Windows Live Photo Gallery 2011, for people incapable of following the links. It's a simple video, for those who can't read. Oh, that's right, XP users can't use Windows Live Photo Gallery 2011, Microsoft isn't developing software for XP anymore. Imagine that! OK, you can try the facial recognition features in CyberLink MediaShow 5, which still supports XP (gag). Another nice video. CyberLink claims that it can process 1000 photos in 8 minutes, but your hardware may be faster or slower (almost certainly much slower if you're still running XP).

Reply   |   Comment by Fubar  –  11 years ago  –  Did you find this comment useful? yes | no (-4)
#41

Personally, I use Win7 for all my photo search needs. I have 2x 750GB drives ( I use C: for OS and programs, and D: for photos, videos, games, and music etc.) I have many, many folders and sub folders, covering my art, portfolio, 2D textures, renders, reference pics, wallpapers, porn (I'm not gonna lie), humourous, family and many more. I've found that using well thought out file/folder names really helps locate things easily. I have a temporary folder titled "UNSORTED" for pics that don't fit other groupings, and move them when I have a few relevant pics for a new folder. It also helps to stay on top of things and not accumulate too many unsorted pics as it can be a daunting task to sort thru tens of thousands of pics at a time. Trust me, I've done it, NOT a lot of fun. But I now have a VERY organized HDD with 40000+ pics, I can locate in less than 15 secs. As for back-ups I have 1TB drive for that purpose, and have been meaning to add another for redundancy. You could use DVD's of course or go for a smaller drive.(100GB for $20-30)

A couple tricks you may find useful for sorting:

1. Open multiple windows -ie a window for the folder containing the images , and another for the folder you are moving the images to. This way you can use drag and drop easily. You can also select multiple pics at once.

2. You can add categories (ie date added, date modified, etc) to sort by in the DETAILS view (as opposed to THUMBNAIL view). These carry over when you change the view. For instance, if you change to DETAILS view and then sort by "date added", if you change back to THUMB view, the pics are STILL sorted by " date added".

On a side note, I'm not sure what all the griping about Win7 is from. Call me un-informed but I don't get it. Considering that MS is trying to please a couple billion users, in 100's of different countries, using millions of different programs on hundred's of thousands of different machines with a billion different configurations, and it WORKS... that to me, is simply amazing. If it's missing one feature I would have liked, I'll get over it. I prefer to use Win7 as it can also organize my PAINT.NET and GIMP files, which aren't traditional JPEG's etc. I have many versions of some images and not all are 'finished' jpeg/png versions. I also have many pics in other various formats such as GIF, TGA, TIFF etc.

I'm not saying everyone should do things a certain way, as everyone's needs are unique, but this is what works for me. I think today's giveaway is too complex for my current needs, as I just want to organize. I don't need to create a Web site, or e-mail or anything else. I just need to find what I want easily, and I can do that already with Win7.

Reply   |   Comment by D  –  11 years ago  –  Did you find this comment useful? yes | no (+1)
#40

Go here to download MySQL http://dev.mysql.com/downloads/
Then install MySQL before DBGallery

Then install of DBGallery but skip 1. in the setup.

Reply   |   Comment by Ron  –  11 years ago  –  Did you find this comment useful? yes | no (+4)
#39

just_passing_by. Can you tell me what other database your using. i have used imageaxs since 95 days and have over 70k images keyworded and tagged. its no longer supported and won't run on vista without work arounds and forget win 7. has many issues with that op sys. i have not found anything that has worked as well, but my xp computer will not last forever so i'm looking to migrate. i don't think DBgallery is what i'm looking for.

Reply   |   Comment by Ron  –  11 years ago  –  Did you find this comment useful? yes | no (-3)
#38

Yeah, I got an error and now I can't use the program... Details here:
http://www.giveawayoftheday.com/forums/topic/9821

Reply   |   Comment by Soulflare3  –  11 years ago  –  Did you find this comment useful? yes | no (0)
#37

I have to say, these guys have an odd taste for GUI design. It's not nonfunctional, it's just that it doesn't look like most Windows programs. And couldn't they have used the original MySQL installer on unattended instead of their own version? I can see many things going wrong with the customized route.

Reply   |   Comment by GMMan, A+, Game Modder  –  11 years ago  –  Did you find this comment useful? yes | no (0)
#36

Ben #19, couldn't have said it better. Since the first versions of Windows I've complained that Microsoft needed to learn what is an OS and what isn't, and to keep the functions separate, concentrating on producing a good OS and letting others provide the applications. Still they haven't learned. In trying to be all things to everyone, they may achieve world domination someday, but along the way they've hurt the productivity of many who use the computer as a tool and not a toy.

One thing that really bothers me is when people constantly jump in to say "you don't need that program because Win X does it already." In many cases, Windows didn't do it ALREADY, the other software was doing it before MS saw it and decided to incorporate it. I've never trusted MS to keep features around indefinitely, because they're only interested in what helps their market share at any particular moment. A friend used Win XP Explorer's photo properties to add notes to all her photos, but they got lost when the photos were edited with some other MS software -- another reason not to trust some of their added features.

I kept hearing how Win 7 was so good, and now that I've experienced it with a new laptop, I'm definitely unimpressed. It has been two months, and I'm still trying to undo some of the damage they've created with their "improvements." My productivity has decreased dramatically and I often boot up my fragile old Win XP laptop to get something done, praying that it holds on a little bit longer.

In spite of not wanting to use Windows to organize my pictures, I decided not to try this GOTD offering because of the database issues some have reported. I'm just not ready to add something like that to this new laptop when I've only got a day to deal with it. It would have been nice if the developer had participated here as some developers have, because it would increase my confidence in the product. It does sound promising. I keep my photos on an external drive, but I do not lug it around with me, and I really need tagging/searching for when I do look for something. I stopped using Picasa last year because I found it had made additions/changes/deletions to the EXIF data without my knowledge, and have been watching for a good alternative. This looks like a possibility someday.

Reply   |   Comment by Terri  –  11 years ago  –  Did you find this comment useful? yes | no (+3)
#35

#19, Ben, #23, OldScotty, #24, just_passing_by, I always find the XP-crowd arguments to be totally illogical. Just what needed to be "undone" in Win7? Could it be that you never bothered to learn all of the capabilities of Win7? Oh, that's right, you'd rather use dozens of add-on utilities to give you a tenth of the functionality. The Windows Search database is built on-the-fly by Windows, you don't transfer it and you can rebuild it at any time (that's done in the background, without any user intervention). The DRM in Vista+ is mandated by the laws which the US Congress passes, Microsoft has no choice in the matter. If you don't understand that, I suggest you read the laws. No, Vista+ don't degrade audio or video as long as the entire playback path supports DRM (or goes to analog). I've always been opposed to DRM, the Copyright laws were sufficient, but again, that's a legislative issue. Ultimately, it's your fault if you elect corrupt bozos to Congress. The example searches I gave were extremely simple examples to show that every property is indexed in indexed folders and files (except for some IE-related properties which Microsoft abandoned). Like I said, I don't have anywhere near enough photos to give live examples of useful searches, but I can give an example of the syntax. This is with natural language queries and partial matching enabled.
size >500kb water (jack or jill) type jpeg created this year
--will return files >500 KB in size of type JPEG created this year and having Water (or words beginning with water, like waterfall) and (Jack or Jill) in the name, path, or any tags or property values.
As I've stated, a number of programs, including free ones from Microsoft, will do face tagging. Of course you have to verify each photo, just as you have to tag individual elements in the photo if you want useful searching later. While you can do batch face tagging, normally you do this when you import the photos. At some point, you have to look at your photos, otherwise, why take them? As with everything else, Windows Search is very much quicker with an SSD, which only Win7 supports. You'd be surprised what Windows Search indexes, every property covers far more than you'd think. For example, I can just hit the Windows key and type "cr res" to create a restore point, or "un prog" if I want to uninstall a program. Uninstall links don't belong in the Start, Programs menu, period. Win7 is smart enough to suggest the name of new programs rather than their uninstallers (if incompetent developers put them there) in the Start menu. Windows Search isn't going to disappear. Ifilters have been around forever, data which was indexed in the past will be indexed in the future. Microsoft can always change the UI. Win7 added visual content display, similar to Google. Some people will love the GUI assistance. I don't care for it and rarely use it, you can specify complex queries and Windows Search will return results swiftly, but if you wait for it to build a list of all possible filters for a given property across a large number of files, that can take a very long time. Vista+ have Superfetch, among numerous other improvements, which stomps XP performance. Especially if you have 64-bit Win7 with lots of RAM. The XP crowd can't figure out that performance isn't just about how fast a program executes, its about how fast it launches. Superfetch not only learns what programs you use and what data they need, it learns when you use them, and loads the relevant files into memory in advance so that Windows is very responsive. People who think that they're testing Windows performance aren't, you're not going to see the benefits of Superfetch if you just run some artificial test, launching the same program over and over in XP and Win7 and timing them, thinking that you're benchmarking performance. I can't stand XP, slow as molasses, no features, no security, no self-protection. As always, if you have an underpowered computer, you're not going to get all of the benefits of Win7.

Reply   |   Comment by Fubar  –  11 years ago  –  Did you find this comment useful? yes | no (+1)
#34

I use the program and it works great. Many of the negative comments on here are full of poo poo. People seem to be asking questions and others are beating them up over it.

Reply   |   Comment by Boarder dude  –  11 years ago  –  Did you find this comment useful? yes | no (-4)
#33

@just_passing_by #24

Agreed! A well maintained photo database is a very handy thing. DBGallery does more than just search. For those taking a lot of photos it offers Data Templates for instantly adding many fields of data to as many images as you wish to add data too. The QuickView cards offers loads of data, sales, and map location at your finger tips. Logical views, allowing exploring by Keywords, City, Timeframe, etc. etc. is great for exploring a large collection. Emailing is a breeze and can include any data available. The reports aren't necessary, but very nice to have.

The database is useful but DBGallery stores data in the file as well (which is optional, but on by default). So you get the advantages of a database, and if you ever decide to move to other software then the data is there in the files...for ever and ever.

At this stage of digital photo tools, the only way to find images in a large collection is by using data. Finding a good data tool beyond the basics Microsoft offers is an investment in time well worth the effort and pays for years to come.

- Photo collection time is like geological time...hard to get your head around and accept, and the timeframes longer than is easy to accept. Think years!

Reply   |   Comment by Glenn Rogers  –  11 years ago  –  Did you find this comment useful? yes | no (+3)
#32

[confused look] @#14 Glenn Rogers-

goodgotd,

MySql is hardly monolithic!


Isn't a MySQL database one file? As opposed to InsideCAT where each record [cataloged disc] is a separate file...

I guess I oughta catch up then...

Reply   |   Comment by goodgotd  –  11 years ago  –  Did you find this comment useful? yes | no (+1)
#31

Unable to install the mysql segment. Unable to even uninstal the partial installation.

Reply   |   Comment by krb  –  11 years ago  –  Did you find this comment useful? yes | no (-1)
#30

DBGallery installed and ran with no problems on my Win 7 system. I'm still exploring it but I love being able to see all my photos by year. Very clever and that is sufficient to get a thumbs up from me. Thank you DBGallery and GOTD!

Reply   |   Comment by John Saunders  –  11 years ago  –  Did you find this comment useful? yes | no (-4)
#29

Between Lightroom and PicaJet not much need for another image organizer. For really good organization of photos for those who need it but do not want to spend the money on Lightroom, snag PicaJet! Inexpensive and a fantastic organizational tool! I used it solely until Adobe tossed me an offer on Lightroom that I could not turn down, $99 full version, lol.

Reply   |   Comment by DigitalDevo  –  11 years ago  –  Did you find this comment useful? yes | no (-1)
#28

As a semi-pro photographer (I make some of my income from pix, some from writing) I believe this programme may be very useful to me, as I have thousands of pix scattered across various hard disks. IF this programme is able to keep track of them and locate the one I want, when I want it, I would probably find it very useful. But after reading quite a number of negative comments here, I am wondering if I should bother to install it.

Still, the proof of the pudding is in the eating -- so I guess I'll have to bite the bullet, and give it go. If it fails to perform well enough to make it useful, I won't continue to give it houseroom... Still, at least it should be a learning experience -- if this is at least halfway decent, it will have introduced me to such programmes, and I will go looking for a better one.

So, even "awkward" or problematic programmes can have their uses!

P.S. To Just_passing_by #24 -- "Searching for photos by resolution (size or dpi) doesn’t get you anywhere, as all photos shot with the same camera will have the same resolution."

Sorry, you should have spotted this mistake yourself -- most cameras can SET the quality of the pix you shoot -- often you have a choice of 3-4 levels. But generally it makes no sense to shoot in anything other than the highest resolution -- you can always compress more later, but you can't make a silk purse out of a sow's ear: You can't ADD resolution (information) that has been thrown away.

If you shoot at the lowest resolution, you'll save on storage space (but it is so CHEAP nowadays!) but you'll never be able to print high-definition images.

Reply   |   Comment by Tranmontane  –  11 years ago  –  Did you find this comment useful? yes | no (0)
#27

I have never had any version of MySql on my system previously.
I installed this today and it worked fine on launch. I then uninstalled it using the Add/Remove Control Panel. Everything appeared to have been successful.

I later re-installed the software but this time it will not launch.
I get two error windows with messages (reprinted below) and then the program closes itself out.

All I did was uninstall then re-install and it will never work again.
I suspect it removed something from my system that it shouldn't have, or it left something there that it's not cleaning up. Searching the hard drive and the registry for files left behind did not prove to be successful. I don't like the fact that something is skewed in my system as a result of this, and I really don't know what to do about it. I have repeated the install/uninstall/re-install process five times with the same result every time (the error reprinted below):

------------------------------------------------------
Error during modification to database schema. Reason:

Unknown database 'dbgallery'
------------------------------------------------------
DBGallery lost it's database connection and cannot continue.

Potential causes:

- The database connection timed out because DBGallery has been left idle for too long.
- MySql Service isn't running
- .Net Data Provider for Mysql not installed
- User Id or Pw isn't set correctly


>>> The Connect Error Mesage :
>>> Unknown database 'dbgallery'

DBGallery will now close.
------------------------------------------------------

Reply   |   Comment by Jonathan  –  11 years ago  –  Did you find this comment useful? yes | no (0)
#26

I have several photo editors and catalogue programs on my Win 7 computer. Windows Search works only if you have some idea of what you are looking for and have given the file a name that you can remember. Most of us just download our photos after we take them and tell ourselves that we'll edit and rename them later. But we never do - at least not all of them. So I have thousands of photos in different places and on different hard drives that still are named with the default name given to them by my camera. This program lets me gather them all into one database without it making copies of the photos and further bloating my computer. It is quick and easy to use. Just drag a folder at a time onto the corresponding 'online' or 'offline folder in the program and let it do its job. And for procrastinators like me, you still don't have to do any renaming until you want to - just gather all the photos and go back to the program later when you feel up to the task.
As I stated earlier, I have several programs that I use for various reasons: Adobe Bridge when I need to VIRIN and catalogue photos for the US Army because it works seemlessly with all the other Adobe products I use. Olympus ib works great as well for cataloguing, with face recognition and it will even download photos from social media site like facebook. I use ZonerPphoto Studio for quick edits. Sometimes I even use Picasa.
But today's give away is perfect for what it does and I recommend anyone with photos on their computer to download and install it. Just remember that the more photos you have the longer it will take to import them all. Aaaah, technology!

Reply   |   Comment by Dan McCormick  –  11 years ago  –  Did you find this comment useful? yes | no (-1)
#25

Actually there is very good Help. Backup is explained in full at 6.5 Database Backup and Restore - "... To backup your database the program to use is the popular MySql Administrator..."

Reply   |   Comment by KK  –  11 years ago  –  Did you find this comment useful? yes | no (0)
#24

@Fubar #3

Most of the time I enjoy reading your comments because they seem well-founded but today my feeling is you should better not have said anything. First off, if you don't have a large collection of photos, you will not understand the need for a good photo database. Searching for photos by resolution (size or dpi) doesn't get you anywhere as all photos shot with the same camera will have the same resolution. Searching by camera make or model is ridiculous for a photographer as they will have thousands of photos shot with the same camera. Face tagging would be a great thing if I could tell the program 'Here, this is the face of my brother John. Now go search all my thousands of photos and tag all appearances of my brother's face with his name.' You believe it can be done? No, it can't. Anyway, even if the program pretended, it had accomplished the task I still would have to go through all the photos just to make sure...

Maintaining a photo database is a tedious job, but if the tool is any good, it's well worth the effort. (As I am using another DAM tool which I am quite happy with, I will not install this one, though.) Even Windows 11 search will not be of much assistance in this unless something drastic happens, such as the camera automatically stores the names of people's faces in some metadata. Might well be, if Google extend their street view to "people's living rooms/bedrooms view" or some such thing.

Reply   |   Comment by just_passing_by  –  11 years ago  –  Did you find this comment useful? yes | no (+18)
#23

Ben #19
Well said I totally agree with you, as far as I am concerned XP is the best version of Windows yet, Vista was a disaster and W7 left me too little control. Another aspect of versions of Windows post XP caused a deal of controversy before Vista was released. It is that if protected audio or video was run the operating system deliberately degraded the quality, done not to please the purchasers of the product, but the music and film industry to stop high quality being ripped. As far as I am aware this was carried through to the finished product, i.e. Vista and W7.

Reply   |   Comment by OldScotty  –  11 years ago  –  Did you find this comment useful? yes | no (-1)
#22

for some reason it won't install on my Win XP Sp3 system, I get this message: "MySqlInstaller.exe has encountered a problem and needs to close".
There's no uninstall option if you ignore this and continue, it has to be removed via control panel. (It didn't work after ignoring and continuing the install). I tried uninstalling then re-installing and get the same massage.

Reply   |   Comment by gurutj  –  11 years ago  –  Did you find this comment useful? yes | no (-2)
#21

Well, it looked like it'd be pretty handy, and the SQL stuff installed without problems. Then it claimed that it ran out of memory (got a dialog SEVERAL times saying System.OutOfMemoryException) and it couldn't continue. I've got 4 gigs of RAM so I know it's not a hardware issue, and one error dialog should be plenty (there were at least 3 identical ones before a larger one popped up with the same info). The initial run was supposed to be about 46k images. I don't know what the programming issue is, but I bet it really slows things down to display each image as it's processed. That should be optional.

Oh, and the Win 7 Explorer window I dragged the images folder from was completely unusable (treated as a "child" window and blocked my screen) during the entire 20-30 minute process before it crashed. I don't think this one's quite ready for prime time.

Reply   |   Comment by Dean  –  11 years ago  –  Did you find this comment useful? yes | no (+2)
#20

Once again I'm puzzled at the negative ratings for what looks to be a very powerful and useful TODAY FREE program for those who have an extensive collection of photos on their computer or other offline computer media like CD/DVD/BlueRay. The user interface is straightforward, the program offers a wide variety of ways in which to view the images for ease of reference and finding them, and there are tutorials that help learn the program's features, though they could be a little better narrated. If you sell your images, it has a feature for submitting and maintaining data on stock images submitted to various image services. It can create a web gallery of a selection of photos, and you can email a gallery of photos. It's definitely worth trying, if you have a quantity of photos and you'd like a better method of finding them when needed.

Reply   |   Comment by Winifred  –  11 years ago  –  Did you find this comment useful? yes | no (+2)
#19

@Fubar, #12

I'm aware of your W7 advocacy but I use XP-Pro on all but one of my computers. The netbook I bought last year came with W7 and frankly I'm not particularly impressed with it. I already used third party utilities for some of the functions it adds (like Find And Run Robot for instance - http://tinyurl.com/farrobot ). Before that I had already tested it on a desktop machine. I was and am however frequently annoyed by it and had to put time and effort into undoing some of the 'improvements' Microsoft made.

Microsoft has the nasty habit of making or breaking Windows functionality as they see fit, causing the annoyances I just mentioned. I don't want to be dependent on any Windows search feature since I don't want to find myself in a position where in some future version of Windows their next decisions about what I according to them should 'want' or 'need' renders years of making a database of my photos useless. No thank you. That database function should be independent from the Windows OS features.

I frankly don't understand why software developers don't recognise the power of being able to use photo management software as a plug-in from within other software. Software like Neat Image or Focus Magic are also much more convenient to use as a plug-in. The makers of these utilities apparently did understand that.

Reply   |   Comment by Ben  –  11 years ago  –  Did you find this comment useful? yes | no (+11)
#18

Thumb Up from me. I have installed Zoner Photo Studio Free just for options to organize pictures by keywords plus comments. DBGallery have many more possibilities for that.

But.. I can't find the way to backup database or export in any format(except exporting Reports in PDF or .xls).
Or may be have to backup the folder \Program Files\MySql ?

Reply   |   Comment by KK  –  11 years ago  –  Did you find this comment useful? yes | no (0)
#17

Away from today's Software Debate (in a strict sense) - I have noticed that some People who are simply asking questions are being severely "bashed" around their heads with unbelievable hostility!

If You don't find their asking for Help relevant to Your situation - at least have courtesy (and mercy) not to judge. That's my plea. Thanks to Those who look beyond thumbs down, see BETTER! - and take their time to help.

Reply   |   Comment by fran  –  11 years ago  –  Did you find this comment useful? yes | no (+19)
#16

Here are some sample Windows 7 Search capabilities, typed into the Zoner 13 editor open dialog (simple searches, I only have a handful of photos}:

A couple of dimension values typed in, Windows Search matches values across all properties, when there are multiple values, the default is AND. The properties for the first photo are shown. For the second photo, 1600x1200 is part of the name, but that's a single string and partial matching only matches the leading part of the string, so it matches the 1600 but not the 1200. The 1200 matches the Height property.
Just typed in the property "Dimensions", and Windows 7 GUI assistance computed the available filter values.
Typed in "Camera" and Windows computed the available filters for both Camera Maker and Camera Model. If you use just one word of a property name, it needs to be the first word.

Reply   |   Comment by Fubar  –  11 years ago  –  Did you find this comment useful? yes | no (+3)
#15

@Fubar, #12- I'm disabled and budget-bound. also *not* a fan of magnetic media for reliability reasons, unless I can use triple-copy or better redundancy. HDD failure is far too fickle.

I ceased using *CD-R's* years ago for much the same reasons, only worse. DVD-r is currently the best compromise I can afford. I'm going to stick with WinXP as long as I can.

150 clams is over 3 month's disposable income, and is booked well in advance, mostly for more survival-oriented needs.

so your methods simply would spell disaster for me.

If I could afford BD-R, I'd be willing to try it as there would be room for Reed-Solomon data recovery files [see ICE ECC at http://www.ice-graphics.com/ICEECC/IndexE.html] for recovery if needed.

Reply   |   Comment by goodgotd  –  11 years ago  –  Did you find this comment useful? yes | no (+16)
#14

goodgotd,

MySql is hardly monolithic! Also, DBGallery ships with a minimalist install of MySql so there is no fluff at all.

The product supports Offline storage so they do not need to be 'live', or connected all the time. Simply drag D:\ (assuming that's your CD drive) onto the Offline node!

Reply   |   Comment by Glenn Rogers  –  11 years ago  –  Did you find this comment useful? yes | no (+5)
#13

#5, goodgotd, I don't put anything on DVDs anymore (not for years). Currently, 3TB external USB 2.0 drives are available in the US for $120, taxes and shipping included (that's $40/TB). Windows Search will keep disconnected external drives indexed for a while (at least if they have unique drive letters), but you'll need to attach them occasionally. I prefer to keep external drives connected, but occasionally USB gets messed up, and I have to power things off and back on.

Reply   |   Comment by Fubar  –  11 years ago  –  Did you find this comment useful? yes | no (+11)
#12

#9, Ben, any software which uses a modern Windows file open dialog box has access to the full power of Windows Search on Vista+ via the Search box in its upper-right. If you have Zoner Photo Studio 13, a previous giveaway, it supports EXIF and GPS data, including via Google Earth, and when you open an image, you can select it using Windows Search (if you know the syntax for your search settings). That's why I can't get excited about these various multimedia applications which have their own database, Windows Search already handles photos, videos, music, documents, etc. If a developer wants to support new metadata or a new file format, all they have to do is write an iFilter (indexing filter), they've been around forever. Windows 7 not only has a vastly improved Windows Search which pops up relevant GUI assistance as you type search strings (I normally prefer to type what I want rather than use the GUI assistance), it has far better automatic indexing settings than earlier versions of Windows.

Reply   |   Comment by Fubar  –  11 years ago  –  Did you find this comment useful? yes | no (+11)
#11

Thought this would be ideal for correcting the embedded GPS data as the camera seems to take up to 20 minutes to locate itself and hence most of my photos show an incorrect location.

It should be very simple, as it lets you drag the locator on Google Maps to the new point. Unfortunately as soon as you "grab" the location pointer, the map shoots off sideways making it almost impossible to do this.

The search and database functions may (or may not) be very good, but I'm afraid that what I have seen so far would indicate this is not a very professionally written piece of software.

Reply   |   Comment by Steve  –  11 years ago  –  Did you find this comment useful? yes | no (+4)
#10

I seem to get the feelong this program is connected to the Web and can be accessed from another place without me knowin it.

Reply   |   Comment by kEN  –  11 years ago  –  Did you find this comment useful? yes | no (-17)
#9

I can't find any reference to the possibility to use this program not just as a standalone application but also as an Adobe 8BF plug-in.

I'm only going to put effort into organising my photo's when I find a program that lets me use the database functions from within any photo viewer/editor/other photo-apps that can handle these plug-ins but any decent piece of software can. Irfanview for instance supports these plug-ins. Since this program does not seem to support this it is not going to be the program I will use for this purpose.

If anyone knows of any (preferably open source) software that offers this feature please let me/us know.

Reply   |   Comment by Ben  –  11 years ago  –  Did you find this comment useful? yes | no (-7)
#8

Well thought out install screen attempting to make sure that connecting to a database goes well, from, my own programming experience it can be a real hassle. However even so a connection to MySql could not be established, even thought it was on my machine initially.
To overcome this problem both DBGallery and MySql were uninstalled and then re-installed and it all worked perfectly.
Trying to fix a bad connection is not worth the effort, better to start from the begging as long as uninstalling MySql is an option.

Reply   |   Comment by OldScotty  –  11 years ago  –  Did you find this comment useful? yes | no (-2)
#7

Thank you C.C.Charlie!

I really appreciate the heads-up
gonna follow those leads as you suggested...
please accept a big MegaPowerful "YES" in usefulness of your comment!

:)

Reply   |   Comment by Fresco  –  11 years ago  –  Did you find this comment useful? yes | no (-29)
#6

This does not provide an option to create a desktop icon so you have to do that manually if you want one.

I am a bit stumped as to what this is for. At first glance it appeared to be a way to organize and find pics on my PC. According to the 'What Is DBGallery' section of their site: http://www.grrsystems.com/what-dbgallery - This is a shared photo database and tool allowing everyone in an organization to quickly access digital photo assets. The error message I get as soon as I open it leads me to believe that this is for people who have websites with SQL Hosting.
-Am I way off base?
-Could someone dumb down what this product is?
-Is the error I am getting unique to me? What is the resolution?

This is the error message I get as soon as I launch the application:

Error Message: Unable to connect to any of the specified MySQL hosts.

DBGallery has not yet been initialized (likely the first time it's been run) and a database connection cannot be made.
The most likely cause is that MySql was already installed on your system prior to loading DBGallery.
If this is the case the resolution is to choose the 'Advanced Configuration' button below and key the relevant database connection info.

Other possibilities...
MySql wasn't installed. Resolution: run DBGallerySetup.exe and install MySql from there.
The database isn't reachable. Potential Resolution: Connect to the database server via another means and choose the 'Retry' button.

- I appreciate and help understanding this.

Reply   |   Comment by standing8  –  11 years ago  –  Did you find this comment useful? yes | no (+20)
#5

First, what is given away here is the personal version- you need to get a quote to find out about multiuser/enterprise use. Not a big deal for me, I do my own thing.

Second, this appears to use a monolithic database- SQL gets installed first. gonna take a while to search if you have a lot of photos.

Third, this appears to assume you have all your photos 'live' in direct-attached or networked storage. At least that's what it looks like to me.

That kills it for me, as I offload to DVD-R for long-term storage, and using InsideCat's [www.insidecat.biz] thumbnail feature in offline mode is lots faster- and I can search/sort by all the metadata once cataloged.

And on the side I get a fast disc catalog program that allows me to keep track of metadata on multimedia, data files, etc.- for a lower price.

About $10 less base, much faster, and more features.

For a print or media company, this sounds like it might be better in some ways. but not at $50 I bet.

For a single user, unless they're a professional and want to keep massive banks of photos on hard drives... I don't think it's going to be all that useful.

Just my opinion. I could be wrong. As usual.

Reply   |   Comment by goodgotd  –  11 years ago  –  Did you find this comment useful? yes | no (+39)
#4

Fresco the pro features look as if those features are more tailored to what your asking. Check out the website for this GOTD and click on the features and check out the professional ones. A webgallery feature is what I believe your asking for.

You are also correct about not needing to know how to code in html, flash, xml whatever to make your own webpage. There are MANY wysiwyg web editors. One I used to use is Aurora Web Editor Professional, a company located out in Australia and priced for the average user. If you want some more helps just ask away.

Reply   |   Comment by Chocolate Chip Charlie  –  11 years ago  –  Did you find this comment useful? yes | no (-10)
#3

I'm simply not going to have time to evaluate this until much later. It certainly has many useful features, but there's also considerable duplication of features which are in recent versions of Windows, which they acknowledge. It's difficult to cover the issues concisely. DBGallery's ITPC/XMP fields may be finer-grained than native Windows support in Vista+. The GeoTagging via Google Maps looks handy, but many photo editors/viewers do that. The database is redundant in Vista+, where Windows Search, especially in Windows 7, provides even more power, especially with natural language queries and partial matching enabled. Windows Explorer in Vista+ can display numerous fields, just right-click a column heading in Details view to see what's available, and of course, sorting and filtering is available. Right-clicking a photo in Windows and selecting Properties, Details shows many basic fields, most of which are editable. Windows Vista+ supports saved searches, Windows 7 supports Libraries. Notably DBGallery is lacking face tagging, which is available in the free Windows Live Photo Gallery 2011, along with numerous other features, including all sorts of grouping, filtering, batch tagging/editing, single-picture editing (more features than batch), searching (but less powerful than Windows Search in Windows Explorer), etc. On the web pages, the headings are live, and generally have photos or videos describing the main features. CyberLink MediaShow 5 has face tagging, and supports Intel Core processors, ATI Stream, and nVidia CUDA (more of its features support CUDA than the others). DBGallery is also weak in its file sharing abilities compared to the others, especially Windows Live Photo Gallery 2011. However, DBGallery can be used in conjunction with other tools or features of Windows. Microsoft abandons many of their products. DBGallery mentions Microsoft Photo Info, which no longer appears to be available, although it remains compatible even with Window 7x64. Photo Info appears to have been superseded by Microsoft Pro Photo Tools 2.2, which is also obsolete. The subject of Windows Search is far too complex to delve into. With natural language queries and partial matching, it supports boolean operations and parentheses in a normal fashion. Comparison and ranges (look up the syntax) are available. It always matches property values. Property names must be fully spelled out (just a word will do), and it matches against those before values, so it's best to leave off the last letter of common words if you want a value match, as there's a high probability that those are a property name. I'd like DBGallery better if it were more integrated with recent versions of Windows, without its own database.

Reply   |   Comment by Fubar  –  11 years ago  –  Did you find this comment useful? yes | no (+60)
#2

Tempted to use this, thanks GRR Systems...
and thank you for all the great offerings GOTD!

Would this be a good way to publish photos in a way to simulate a fancy-shmanzy website? My server provides a so-so utility to create a website on my domain name, but it frigging bites. Its beyond bad.

I don't know how to create a basic site, and these days... do we really have to? There has to be some way that a noob like me, can create a web presence with plenty of bells and whistles... any suggestions would be deeply appreciated.

Thanks in advance... and thanks again, GOTD!

Reply   |   Comment by Fresco  –  11 years ago  –  Did you find this comment useful? yes | no (-75)
#1

Download and install successfully on my windows 7, the interface looks good and easy to use, i like it, thx GOTD!

Reply   |   Comment by perter  –  11 years ago  –  Did you find this comment useful? yes | no (-85)
Add a comment

iPhone app giveaways »

Maha Laxmi Mantra With Audio Giveaway
Listen to Maha Laxmi Mantra.
$3.99 ➞ free today
BGH - Bear's Good Habits Giveaway
Create a good habit with Tom!
$0.99 ➞ free today
Om Namah Shivay - Listen To Aarti and Mantra Audio Giveaway
Om Namah Shivay. You can listen to Om Namah Shivay aarti dedicated to Lord Shiva with this app.
$4.99 ➞ free today
The Busy Lumberjack Giveaway
This is a fun and engaging puzzle game.
$1.99 ➞ free today
Easy Auto Call Recorder Number Giveaway
Easy Auto Call Recorder allows to record any phone call easily.
$2.99 ➞ free today

Android app giveaways »

Merge Mon VIP - Idle Puzzle RPG Giveaway
Merge your monsters with simple puzzles and create stronger monsters.
$0.99 ➞ free today
Famous Quotes Guessing Game PRO Giveaway
Play entertaining guessing game or browse through hundreds of best famous quotes of all time!
$1.99 ➞ free today
Trivia Master - Quiz Games Giveaway
Trivia master is a multiple choice quiz game.
$4.49 ➞ free today
LeagueMon VIP - League Monster Defence Giveaway
A simple Defence RPG game!
$1.99 ➞ free today
Plurals Test & Practice PRO Giveaway
Plurals Test & Practice PRO is a new educational word game in which you will practice knowledge of English words.
$1.99 ➞ free today