Live data from Hacker News

On Uber’s Choice of Databases

use-the-index-luke.com

11–15 of 15 posts

Re: On Uber’s Choice of Databases

#11
post #4

All of these response posts seem to miss one big piece that made no sense to me. Uber goes really in-depth around the higher cost of updates in postgres, but then Uber describes Schemaless as an immutable append only data store. They created a custom database with no updates, but one of their primary reasons for changing from postgres to mysql was because of the high cost of updates?

Most of the conversation on the topic misses that Uber's actions are totally irrelevant to 99.9% of us. Uber has unlimited resources and unique problems. Sure, it's interesting but ultimately almost entirely meaningless.

Re: On Uber’s Choice of Databases

#12
This really all boils down to "Ford F-150s are bad trucks because your cargo can get wet when it rains, use a U-Haul truck".

Sure, for that VERY specific (and not very common) use case U-Hauls beat F-150s. However, I think we can all agree that F-150s are far more versitle for most use cases, up to including something trivial like heading to Starbucks for a quick coffee.

Re: On Uber’s Choice of Databases

#13
post #6
post #4

All of these response posts seem to miss one big piece that made no sense to me. Uber goes really in-depth around the higher cost of updates in postgres, but then Uber describes Schemaless as an immutable append only data store. They created a custom database with no updates, but one of their primary reasons for changing from postgres to mysql was because of the high cost of updates?

From what I can tell Schemaless has updates but represents them as inserts. When you want to change something (e.g. change the billing status of a trip), it writes a new billing status for the trip and consumers will always ask for the latest billing status for the trip, which is the most recent and up-to-date one. Take this with a grain of salt, I just read the Schemaless articles yesterday.

Isn't reddit doing schema-less on postgres?

Re: On Uber’s Choice of Databases

#15
post #3

This is a very good and fair response and anyone serious about tuning their DB should have use-the-index-luke.com bookmarked!

'SELECT * from depesz'[1] is another great resource for weird sql capabilities and performance-related stuff, focused heavily on Postgresql

[1] https://www.depesz.com/

Post reply on HN