4 ms·
Postgres in particular: - has strong performance vs, say, sqlite - has "channel" and "trigger" support so you can avoid polling (which either slows down your
by colinchartier 7y ago
Postgres in particular:
- has strong performance vs, say, sqlite
- has "channel" and "trigger" support so you can avoid polling (which either slows down your jobs or limits your number of workers)
- is actually OSS (versus, say, mysql)
- Twirrim 7y agoHow is MySQL not OSS?
- snuxoll 7y agoThere’s MySQL EE and the CLA that allows it to exist, I guess.
- cogman10 7y agoIt is somewhat split. Not all MySQL features are open source (enterprise edition feature). Postgres is completely open source.
- jabl 7y agoWell, yeah, but then there's stuff like enterprisedb which is postgresql + some proprietary stuff on top, and the company employs some of the postgresql core developers. So in some sense it's "PostgreSQL Enterprise Edition" in all but name. I believe Citus DB(?) is something similar.
- e12e 7y ago> I believe Citus DB(?) is something similar. "Citus Unforks From PostgreSQL, Goes Open Source" https://www.citusdata.com/blog/2016/03/24/citus-unforks-goes-open-source/ https://www.citusdata.com/blog/2016/03/24/citus-unforks-goes... https://news.ycombinator.com/item?id=11353322 https://news.ycombinator.com/item?id=11353322 As for mysql - I don't know why anyone wouldn't prefer mariadb - but I suppose it's conceivable mysql has features that makes it worth dealing with oracle licensing. But I doubt it.
- zejn 7y agoSQLite is significantly undervalued. I agree that PostgreSQL has some very nice extensions and if you know you are going to have multiple users (or multiple processes using it), SQLite can't compete. But if you only have one process using the DB, then SQLite is immune to N+1 query problem since everything is in-process and there are no round-trips.