The small parts of the Mars Rovers (MER) I worked on or worked with didn’t use SQLite. It was too early in SQLite’s history for it to be used on MER. MER also used VxWorks which probably didn’t have a lot in the way of POSIX support at the time. I remember other devs telling me the fun they had supporting 1553 bus on “such a new RTOS”.
Wikipedia say MSL used VxWorks as well.
I’d have to ask a buddy still doing Mission Ops Support at JPL but I’d think the answer is no SQLite on MER or MSL missions. The OSes were fairly custom, non-POSIX builds. The ESA folks might have tried though on their missions.
No worries. Been meaning to investigate VxWorks at some point, mostly from an interest in embedded devices (for specific wearables concepts). This will be another thing to add for that list. :)
As far as I know, it has flown on two government (civil space) missions. I'm not longer at the company so I don't know what else it has or will go into.
I don't know about rovers, but some smaller spacecraft (mainly satellites) use mysql, as well as postgres. Disclaimer: I'm not the right person to ask.