Build Databases on Palm Device with Pilot-DB
Productivity Sauce
I love the technology of yesteryear. That's why I prefer to shoot with my trusty Nikon F-501 film SLR. Film photography can be a great learning experience, but the lack of EXIF data makes mastering the basics more tricky. After all, knowing what aperture and shutter speed values were used in a specific situation can come in rather handy. To solve the problem I enlisted the help of another vintage device: Sony Clié PEG-NX73V. When launched almost a decade ago, it was mind-boggingly expensive, but I bought mine on eBay for peanuts. This Palm OS-based device from Sony features a swanky design, it runs for weeks on a single charge, and it's reasonably fast. More importantly, there are many excellent open source apps available for Palm OS, including my all-time favorite Pilot-DB database. This is a simple yet versatile database app that can be used for a variety of purposes: from maintaining lists and tracking tasks, to building more advanced databases. I used Pilot-DB to maintain a simple database (I named it RollDB) for storing key information (aperture, shutter speed, focal length, lighting conditions, etc.) for each film exposure.
Pilot-DB is capable of handling several field types, including Interger, String, Float, Date, and Time. In addition to that, the app supports more advanced field types like Calculated, Link, and List. The latter type is particularly useful, as it allows you to specify a list of values the user can select from, which can significantly speed up entering data. In RollDB, lists are used to quickly specify aperture, shutter speed, and lighting conditions from a list of predefined values. Pilot-DB also supports user-defined list views. Each list view can contain selected fields, and you can specify each field's size. The ability to duplicate the currently viewed record is a great time-saver which makes it easier to create records containing similar data. For example, when I shoot several frames at the same aperture and shutter speed, I can simply duplicate records instead of entrering them from scratch.
Once a film roll has been finished and developed, I import the digitized photos into digiKam and use it to add key EXIF values to selected images. I also use the Java Pilot-DB desktop application to view and manipulate data stored in the RollDB database. The application is written in Java and it doesn't seem to work with OpenJDK Java 7 Runtime, but it does run fine under OpenJDK Java 6 Runtime.
For your convenience, I made the Pilot-DB and Java Pilot-DB application along with the RollDB database available for download. You can grab them from https://www.box.com/s/miwqtc8hgjli549zqzdf
comments powered by DisqusSubscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Juno Computers Launches Another Linux Laptop
If you're looking for a powerhouse laptop that runs Ubuntu, the Juno Computers Neptune 17 v6 should be on your radar.
-
ZorinOS 17.1 Released, Includes Improved Windows App Support
If you need or desire to run Windows applications on Linux, there's one distribution intent on making that easier for you and its new release further improves that feature.
-
Linux Market Share Surpasses 4% for the First Time
Look out Windows and macOS, Linux is on the rise and has even topped ChromeOS to become the fourth most widely used OS around the globe.
-
KDE’s Plasma 6 Officially Available
KDE’s Plasma 6.0 "Megarelease" has happened, and it's brimming with new features, polish, and performance.
-
Latest Version of Tails Unleashed
Tails 6.0 is based on Debian 12 and includes GNOME 43.
-
KDE Announces New Slimbook V with Plenty of Power and KDE’s Plasma 6
If you're a fan of KDE Plasma, you'll be thrilled to hear they've announced a new Slimbook with an AMD CPU and the latest version of KDE Plasma desktop.
-
Monthly Sponsorship Includes Early Access to elementary OS 8
If you want to get a glimpse of what's in the pipeline for elementary OS 8, just set up a monthly sponsorship to help fund its continued existence.
-
DebConf24 to be Held in South Korea
Busan will be the location of the latest DebConf running July 28 through August 4
-
Fedora Unleashes Atomic Desktops
Fedora has combined its solid distribution with rpm-ostree system to make it possible to deliver a new family of Fedora spins, called Fedora Atomic Desktops.
-
Bootloader Vulnerability Affects Nearly All Linux Distributions
The developers of shim have released a version to fix numerous security flaws, including one that could enable remote control execution of malicious code under certain circumstances.