The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
He would ship stuff that didn't work
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
and have his initial customers help him debug it.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
So I think he engaged in what I consider very shady business practices.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
But lying to customers, I think, is unconscionable.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
So for instance,
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
There was a thing called referential integrity, which is if you fire an employee and he's the last person in a given department, do you want to delete the department or do you want to have it be a department, a ghost department?
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
It's all that kind of stuff.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And so Ingress Corporation implemented referential integrity.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
Oracle Corporation wrote two manual pages that said, here's the definition of referential integrity, which everybody agreed to.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And then down at the bottom it said, not yet implemented.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
That was the genesis of Postgres replacing MySQL as the preferred open source relational database system.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
was the original reasoning for the academic version of Ingress was we were going to support a geographic information system that the neighboring professor, Praveen Varaya, wanted.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And so, to support a GIS system, you need points, lines, polygons, line groups, that sort of stuff.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And it was clear that Ingress couldn't do it because
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
The data types we put into Ingress were the standard ones, integers, floats, text strings.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And you couldn't support, you couldn't efficiently support GIS types on top of that.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
So as a GIS, the academic version of Ingress was a complete failure.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And that was in the back of our mind.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
The other thing that happened, this is a little out of chronological sequence, but it helps make the point, is that the commercial version of Ingress, I think around 1985, ANSI had just proposed a date and time standard for relational databases.
The Peterman Pod
Turing Award Winner: Postgres, Disagreeing with Google, Future Problems | Mike Stonebraker
And so commercial Ingress implemented date and time using the standard Gregorian calendar.