NASA to deploy PostgreSQL/Nagios on Space Station

[mahmud]

The child in me wants to drop everything he is doing; a new job, and apartment rent in 2 continents, and just go volunteer for this.

[adbge]

Is there anything cooler or more badass than writing software used in space? Whenever I'm told that a piece of software isn't fit for "mission critical applications," I think of NASA.

I'd love to help out with this, but I'm afraid I lack the necessary skill set. Still, maybe I will poke around the NDOUtils source anyways.

If anyone else is interested, here's a link to the NDOUtils source tarball: http://sourceforge.net/projects/nagios/files/ndoutils-1.x/nd...

[openfly]

NASA's commitment to open source is fairly great. And, postgresql is a really great database. If you haven't used it before, I highly recommend giving it a run.

[donw]

It's just too bad they've got to pair it with Nagios; I'm fixing it so that I never have to work with that POS ever again.

[pragmatic]

Why Postgres? I'm a fan of it, but I wonder why they can't/won't use mysql?

(I'm looking for a good technical explanation, if anyone has one.)

[moe]

My guess would be that NASA already uses postgres for other duties and is hesitant to introduce a new database into their infrastructure - especially one with so many known problems.

If I was them then I most certainly wouldn't want a database with silent data truncation/corruption issues to come anywhere near my spaceships. Not even for seemingly unimportant tasks because even those may cost amazing amounts of money to fix if they go wrong a few thousand kilometers above groundlevel...

[rbranson]

PostgreSQL is well-known for it's focus on data integrity and durability first, performance second. The team didn't really focus heavily on performance until the 8.x release series, after the database had been proven as extremely stable. Also, it has a much more complete implementation of SQL and larger feature set.

[dboyd]

I've used both very recently, and I would definitely avoid MySQL given a choice.

From my experience, postgres is faster, especially at more difficult problems (complex joins). I've never had issues in postgres joining several tables into 10 million plus row relations, and then filtering down to the set of interest.

I did a recent test adding a similar column to a MySQL table with 3 million rows in it compared to adding a column to a postgres table with 30 million rows in it. MySQL took 3000 seconds, and postgres took 82 ms.

Functional indexes. Doing things like "create unique index user_emails on users (lower(email));" works great in postgres.

A quick google reveals this: http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_My...

It's a bit old, but it might provide more insight.

[avar]

Isn't the computing power on the ISS almost purely made up of Thinkpad laptops running Windows? Will they be running PostgreSQL and Nagios on a Windows machine?

[nkassis]

That's awesome. Nagios in space. Sounds like a cool comedy title. Were about to install Nagios here too. One more point for management to like the idea ;p

[james2vegas]

well, they want to deploy Pg/Nagios on the Space Station, pity Nagios's support for anything other than MySQL is poor to non-existent.

[jncraton]

It's not really a pity at all. It will be more work for them, but it's a win for us as long as they pass their code to make it work back upstream.

[gourneau]

Another NASA open source programmer checking in.

[helium]

Well, I guess they just haven't heard how awesome NoSQL is yet :)

[tialys]

I'm an intern at NASA this summer, and I've actually convinced the team I'm working with to use Redis/Resque for the application we're working on. Unfortunately it's 'just' a web application ;)

[superk]

Makes me wonder about budget cuts...

[RyanMcGreal]

"I felt about as good as anybody would, sitting in a capsule on top of a rocket that were both built by the lowest bidder." -- John Glenn on how it felt waiting to for the rocket to launch