[justinclift]

Fairly off topic ;), but any idea if SQLite is used on any of the rovers, spacecraft, etc?

Mostly from idle curiosity. Was wondering a few days ago and guessing "probably yes", but no idea who to ask.

So, taking the opportunity (heh) now. :)

[oso2k]

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.

[justinclift]

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. :)

[planteen]

Not a Mars spacecraft, but SQLite has definitely been used on some CubeSat missions in LEO. I know because I'm the one who did it. :-)

[oso2k]

Was it a commercial or government CubeSat?

[planteen]

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.

[justinclift]

Cool. :)

[jakeinspace]

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.