A Personal Lens Register Database for photography aficionados
Posted: Wednesday 3rd March 2021 11:00am
A Personal Lens Register
The program oranises all sorts of lenses, lens makers, mounts and it is aimed for photography aficionados. It comes with a set of 9 lenses and you are able to add whatever lenses you want or own.
Organising means: you can add specific details of lenses and - if you own one of them - you are able to add details about the purchasing process. It supports Drag'n Drop of images (if you have one) into the program. Once you get sick of a lens and want to sell it: all the information about the selling process can be added as well. There are (simple) reports of a) what you own and didn't sell, b) what you purchased, c) what you sold and d) what's on sale at the moment.
Lens maker provide a lot of information of their lenses. I organised the information into a couple of categories: Focal Specifics, Overview, Technical Data, Misc Serial No Ranges, and CLA (Clean, Lubricate, Adjust) with an IconPanel which looks pretty cool imho.
The Personal Lens Register uses a sqlite database. Full-text search (similar to Google seach) is available. It is implemented as FTS5 in sqlite. It can be enabled or disabled in one of the forms with a checkbox. If you are interested in FTS there is a script in directory Data/SqlRefFiles/ which rebuilds the FTS index. FTS allows to search case-independent across almost all columns in the database without the risk of full table scans across the whole database. You can use the asterisk (*) as a postfix token. So the program is able to handle hundreds and thousends of lenses and you are going to find them all;)
Also, very important is the ability to export the added lens data and import them after a new version has been deployed.
This is my first Gambas program and I developed it with the help of Quincunxian. He gave me advice how to handle databases, classes etc in Gambas. I am afraid I screwed up his structured and well written code. The program is fully functional but it is still a beta version. There is an enormous need to improve and pimp up the code. Have fun.
The program oranises all sorts of lenses, lens makers, mounts and it is aimed for photography aficionados. It comes with a set of 9 lenses and you are able to add whatever lenses you want or own.
Organising means: you can add specific details of lenses and - if you own one of them - you are able to add details about the purchasing process. It supports Drag'n Drop of images (if you have one) into the program. Once you get sick of a lens and want to sell it: all the information about the selling process can be added as well. There are (simple) reports of a) what you own and didn't sell, b) what you purchased, c) what you sold and d) what's on sale at the moment.
Lens maker provide a lot of information of their lenses. I organised the information into a couple of categories: Focal Specifics, Overview, Technical Data, Misc Serial No Ranges, and CLA (Clean, Lubricate, Adjust) with an IconPanel which looks pretty cool imho.
The Personal Lens Register uses a sqlite database. Full-text search (similar to Google seach) is available. It is implemented as FTS5 in sqlite. It can be enabled or disabled in one of the forms with a checkbox. If you are interested in FTS there is a script in directory Data/SqlRefFiles/ which rebuilds the FTS index. FTS allows to search case-independent across almost all columns in the database without the risk of full table scans across the whole database. You can use the asterisk (*) as a postfix token. So the program is able to handle hundreds and thousends of lenses and you are going to find them all;)
Also, very important is the ability to export the added lens data and import them after a new version has been deployed.
This is my first Gambas program and I developed it with the help of Quincunxian. He gave me advice how to handle databases, classes etc in Gambas. I am afraid I screwed up his structured and well written code. The program is fully functional but it is still a beta version. There is an enormous need to improve and pimp up the code. Have fun.