So a handful of tweaks and upgrades for today. First, the Stingray data is still coming in. The site has about 40% of the 2023 Stingray data, so that is moving along nicely. But tonights changes:
- The vehicle list pages are no longer limited to the most recent 100 added to the database. You can now view all of the cars in the database. The list is paginated and displays 100 vehicles per page. You can go thru the pages or jump to the page of your choice.
- The vehicle list pages have a new Search by VIN function to replace the old search. It is exactly what it sounds like. You can search by a full or partial VIN and it will return the results.
- The individual vehicle pages no longer list the 'unknown' options.
As the database of vehicles gets bigger, it is exposing areas where I need to do a little work. In particular, the dashboards. There are a lot of database queries running on that page. While most are simple, the "daily production estimate" chart is a bit of a task for the site to generate on the fly. I think I am going to have to do some data caching so that the data isn't being generated on the fly, but instead have it generated on the back end and cached. That way the dashboard will just be able to grab the cached data without having to do any of the processing of the data. This will speed up the performance of the site. I hope to have this done in the next week or so.. its a new thing for me, so I'm sure it'll be a bit of an adventure.