Based on the file modification dates, I went from using the Digikam SQLite database to using their embedded MySQL database in May 2018. I did it because at the time everyone was saying that for a large database it’s better to use SQL than SQLite. For a long time it seemed to work well enough like that. But, for the last few months, MySQL hasn’t quite been right. It’s been complaining about issues with InnoDB. Unfortunately, in my Googling I couldn’t figure out how to attempt to fix that issue with an embedded database. All the solutions seemed to involve using a “real” MySQL. So, sick of all that, I decded to go back to SQLite. Since launching Digikam (for the past two days) just causes my computer to go to a load average in the 50s and lead to an unending stream of SQL errors, I had to move the folder that contained MySQL and start from scratch. It was also an opportunity to do what they recommend and have the database reside on an SSD.

Back in October, I created a video showing my workflow with Digikam and RawTherapee. After spending lots of months working with both programs and tinkering to see what works best, I have updated my workflow. Based on the current versions of the programs, here is my updated workflow:

https://youtu.be/mnk_VzedqlU

Back in May I posted a video of my RAW Workflow in Adobe Lightroom. Now that I’m fully on the Linux photography bandwagon, here’s a video of my current workflow with Digikam and RawTherapee:

https://youtu.be/f9OjxDFE_Qo

Back when I was looking into doing all my photography on Linux I saw that whenever I would add a tag to a bunch of photos that it would crash Digikam. I filed a bug and was told it was a problem with Baloo that would be fixed in Digikam 5. I wanted my photos to have metadata that would be indexed in Dolphin and Baloo search, so I tried to deal with it as I moved to doing all my photography on Linux. But after it kept crashing as I worked on my July photos, I had enough. I turned off Digikam and Baloo integration and am no longer having crashes. Here’s what it needs to look like in the settings if you’d like to do this too:

I found one way around the situation involving a DNG going to RawTherapee and creating a JPEG image that’s missing the title and tags when read by Digikam’s Exiv2 library. It may not be perfect, or even the best way. But it’s one way around the issue that I was easily able to confirm with about 5 minutes of messing around today. First up you want to tell Digikam to make XMP files to go along with all files:

Last Fall I started considering moving away from Lightroom after having used it for nearly a decade. Back then I was making use of the student price to actually be able to afford it. Competition from Apple Aperture and other programs caused it to eventually drop to $150 per version. But Adobe seemed to be moving more and more towards a subscription-only model. Lightroom is still available standalone, but it appears the rest of the CS suite (including, for example, Photoshop) are on the treadmill now. While there are surely some benefits to being able to rent Photoshop and Adobe’s awesome video editing software when you need to do a project rather than for a thousand-plus fee, one way I’ve afforded Lightroom is not upgrading every year. So while it’s cheaper to pay monthly than buying outright (at the prices they had when they went subscription), I rarely found the upgrades worth is and so was able to save some money. I started considering alternatives. But I’d had Lightroom 5 on my wishlist and someone bought it for me for Christmas. So I figured I’d be a Lightroom user for a few more years.

As I’ve mentioned before on this blog, I’ve been into photography since I was five years old.  That’s when I got my first Kodak Instamatic camera and started shooting photos and creating photo albums.  I have about ten photo albums, with most of them coming from when I got to high school and could really afford film and developing.  Ever since I got my first digital camera in my second semester of college, the number of photos I’ve taken yearly has increased nearly exponentially.  Because I’m an organized person, I started off putting my photos into event-based folders.  Once I realized that’d quickly get unwieldy, I decided to put them in folders by date.  Eventually, software like Picassa, Lightroom, and digiKam came out which would have allowed me to continue to to organized my photos by event because they could read the metadata and reorganize them by date.  However, I’ve found that my system has two main benefits 1)my photos remain organized even if my descendants don’t have access to programs that can read the metadata on the photos.  2) it’s very easy for me to very quickly find a photo.  It would be somewhere like 2010->Jan 10->So and So’s Wedding.