Menu
Sign In Search Podcasts Libraries Charts People & Topics Add Podcast API Blog Pricing

Mike Stonebraker

๐Ÿ‘ค Speaker
444 total appearances

Appearances Over Time

Podcast Appearances

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.