A look at a small section of Curiosity's workspace in this composite image assembled from 4 Bayer reconstructed R-MastCam frames that were assembled in MS-ICE. The images are from December 27, 2023 (sol 4049) at site 105/1108 after a short drive/climb a few sols earlier. The rover is located at the head of Gediz Vallis (see map) I've also attached the drive data. Image credits: NASA/JPL-Caltech/MSSS/USGS/fredk)
@PaulHammond51
Since our discussion about the maximum number of digits in RMC drive numbers (max 4) a long time ago, I converted RMCs to fixed fractional numbers. My Mars2020 database (only metadata, no images) is now 700MB and it takes a second to return a result the first time I run a query after startup; a split second afterwards. It would take several seconds if the RMC was still text, as it appears in NASA's metadata, i.e. 105_1108 (text, NASA) instead of 105.1108 (float).
Sounds like you have built a really nice database there. I seem to recall (from the little training I had on databases, many years ago) that they processed numbers way better than text, so that was a smart move to convert the underscore to fractional numbers to run your queries :) Out of curiosity what database do you use, the training I had was using MS Access, but that was over 20 years ago, I'm sure it's moved on in leaps and bounds since then :)
@PaulHammond51@65dBnoise I immediately heard a movie gangster voice: "Sounds like you have built a really nice database there... It'd be a shame if something happened to it..." 🙂
@PaulHammond51
I need to redo the database, because I designed it initially to run directly in the browser without a web server, and work directly with NASA's API, but I ended up using a local web server for caching all data from NASA, instead. I expect it to shrink to less than 200MB after I convert more fields to floats.
#SQlite is what I use for almost everything I run locally, even for #QGIS map data. It's a one file db and very easy to work with.
Add comment