List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:February 1 2008 1:52am
Subject:Re: Decimal - Maximum is 30
View as plain text  

I can certainly understand the upgrade based on the performance advantages
of MySQL
What would NASA use for its mapping GIS/Mapping software?
Postgres has PostGIS
Oracle has OracleSpatial
MySQL has ?

Many Thanks for the link
----- Original Message -----
From: "Michael Cole" <colemichae@stripped>
To: <mysql@stripped>
Sent: Thursday, January 31, 2008 8:45 PM
Subject: Re: Decimal - Maximum is 30

On Friday 01 February 2008 7:32:33 am Warren Young wrote:
> The average grain of sand is a bit smaller than a millimeter. There are
> a million millimeters per kilometer.
> 10^11 * 10^13 * 10^6 = 10^30
> In other words, the current system is sufficient for establishing the
> location of every grain of sand in the universe at this scale. If we
> rescale by making use of the digits we're allowed to the left of the
> decimal point, we can probably describe the location of every atom in
> the universe instead. You must be working on something absolutely
> mind-blowing for this amount of precision to be insufficient.
I think you missed something in your formula,

You just have a 1 dimension dealt with here.

That would be every grain in that line.

But when i first read the statement before i had the same conclusion that
10^30 would normally be enough for anyone, I noticed years ago Nasa used
MYSQL -2000 to be exact..

NASA switches from Oracle to MySQL
In November a team at NASA's Marshall Space Flight Center finished the
transition of the NASA Acquisition Internet Service (NAIS) from Oracle to
MySQL. NAIS sends e-mail notifications to users based on specified interests
and enables users to query the Web site ( for updated
Dwight Clark, project leader of NAIS, claims to have noticed an increase in
speed of performance without experiencing any problems.
The switch to Open Source software was primarily driven by costs, and MySQL
was found to be the most robust product available. The President's
Information Technology Advisory Committee recommended in September that the
federal government encourage open-source software as an alternative for
software development for high-end computing and allow open-source
efforts to compete on a "level playing field" with proprietary solutions in
government procurements.
Read the whole story at Federal Computer Week:

MySQL General Mailing List
For list archives:
To unsubscribe:

Decimal - Maximum is 30Eli Shemer30 Jan
  • Re: Decimal - Maximum is 30Warren Young30 Jan
RE: Decimal - Maximum is 30Eli Shemer31 Jan
  • Re: Decimal - Maximum is 30Michael Dykman31 Jan
  • Re: Decimal - Maximum is 30Warren Young1 Feb
    • Re: Decimal - Maximum is 30Michael Cole1 Feb
      • Re: Decimal - Maximum is 30Warren Young1 Feb
  • Re: Decimal - Maximum is 30Martin Gainty1 Feb
    • Re: Decimal - Maximum is 30Peter Brawley1 Feb
      • Re: Decimal - Maximum is 30Paul DuBois1 Feb