3 ms·
Sort of random/oddly specific usecase, but this article helped me understand a bit more of what happens under the hood with both PostgeSQL and MySQL: https://e
by skizm 9y ago
Sort of random/oddly specific usecase, but this article helped me understand a bit more of what happens under the hood with both PostgeSQL and MySQL:
https://eng.uber.com/mysql-migration/ https://eng.uber.com/mysql-migration/
It is a fairly easy read, even for someone (like myself) who has very little knowledge of what's actually going on under the hood of most DBs.
- cookiecaper 9y agoFurther reference material: - PgSQL mailing list thread discussing Uber's post: https://www.postgresql.org/message-id/579795DF.10502%40commandprompt.com https://www.postgresql.org/message-id/579795DF.10502%40comma... - Slides from "A PostgreSQL Response to Uber", a talk that provides the PgSQL-perspective counterarguments to the Uber post: http://thebuild.com/presentations/uber-perconalive-2017.pdf http://thebuild.com/presentations/uber-perconalive-2017.pdf [PDF] - Previous HN discussion on the above: https://news.ycombinator.com/item?id=14222721 https://news.ycombinator.com/item?id=14222721 - Slides from "Migrating Uber from MySQL to Postgres" (2013), in which Uber's prior migration _to_ PgSQL is discussed: https://www.yumpu.com/en/document/view/53683323/migrating-uber-from-mysql-to-postgresql https://www.yumpu.com/en/document/view/53683323/migrating-ub...
- skizm 9y agoHa! I had no idea this article was so hotly contested. I'll definitely be reading through the links. Thanks.