Work on the new equipment database and module, which is going to be the highlight of 2021, is ongoing, and during September I worked very hard on this, making giant leaps forward in terms of progress. As mentioned, I don't think I've ever written this much code in such a short period of time ever, and as I look at it, I'm also very happy about the quality!
I have now pretty much completed the following parts for the Cameras/Sensors database tables:
A tool called "Equipment explorer" that allows everyone to find equipment items on AstroBin, with their technical details and product picture, and collectively maintain this database in a wiki-style, peer- reviewed, editing process.
A tool for the migration of the legacy items (which suffer from duplication and fragmentation) into the new consolidated equipment database. This tool also employs a peer-review process to minimize mistakes.
The following parts are a work in progress:
1. I'm collaborating with a community member who is performing string analysis on the legacy database in order to perform some initial consolidation and significantly alleviate the migration workload.
2. I have received product databases from πΊπΈ OPT and πΊπΈ High Point Scientific, and I will try to integrate them, again to alleviate the migration workload. π©πͺ Teleskop-Service has also offered to help and they are working on a data export. Please do show your appreciation for these companies: they don't just sell us stuff, but they actively care for the community.
The following parts are still on my todo list:
After the initial round of testing, I will extend the tool to include Telescopes, Mounts, Filters, Accessories, and Software.
After the legacy database has been run through an initial consolidation, and the new database has been built to some extent (e.g. the top 20% items that are featured in 80% of AstroBin's images), I will build a new equipment selection tool page in the uploader wizard.
After 80% of the items in the legacy database have been migrated to the corresponding defragmented items in the new database, I will build a tool so that everyone can apply the migrations to the items that they have used on their images. Consider this a 3rd peer-review step in the process. It is extremely important that this process has a zero-tolerance for false positives and mistakes: the number one priority is to not chage an image's equipment to something different than what the author of the image meant.
At this point, I can integrate the new equipment database in the search engine, and add new search filters that work on technical properties (e.g. telescope aperture or sensor pixel size).
At this point, I can build individual pages for every item in the new equipment database, with the goal of building communities around equipment items.
At this point, as some time has passed and the new equipment database is strongly in use, with the majority of AstroBin images using equipment items from this database, we can go crazy with tools such as equipment suggestions based on popularity (e.g. "This telescope is most often used with these cameras")
What's the expected timeline for all this?
By the end of October, I hope to have removed all bugs (I can't thank the volunteers who have been helping me test this enough!), that we have done a thorough test run, and that I have added support for all equipment classes.
In November, I hope to have deployed this code to the live AstroBin servers, and that the volunteers are working on the migration process for real.
In December, I hope that we have reached the 80% migration milestone.
In January, I hope that the actual merge happens, and that I have completed
work on the community pages for equipment items and the new search tools.