7 ms·

I'm curious if the same holds true if you drop in Sqlite/MS Sql Server/Mysql. I.e. is this good advice because Postgres in particular is a great implementation

I'm curious if the same holds true if you drop in Sqlite/MS Sql Server/Mysql. I.e. is this good advice because Postgres in particular is a great implementation of sql, or because sql in general is good enough to solve this problem, or a mix of the two?

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 ago
  How is MySQL not OSS?
  - snuxoll 7y ago
    There’s MySQL EE and the CLA that allows it to exist, I guess.
  - cogman10 7y ago
    It is somewhat split. Not all MySQL features are open source (enterprise edition feature). Postgres is completely open source.
    - jabl 7y ago
      Well, 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 ago
  SQLite 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.
EvanAnderson 7y ago
SQL Server has Service Broker (my prize winner for most undervalued and unknown feature in a mainstream software product) that does a tremendously good job of solving these types of problems. I can't say how well it scales, but it has done a reasonable job at every workload I've thrown at it.
- dfox 7y ago
  IMO the reason why Service Broker is mostly unknown and undervaluated is the name itself. It sounds like something horribly complicated, while it in fact is relatively straightforward implementation of pub/sub.

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 ago
How is MySQL not OSS?
- snuxoll 7y ago
  There’s MySQL EE and the CLA that allows it to exist, I guess.
- cogman10 7y ago
  It is somewhat split. Not all MySQL features are open source (enterprise edition feature). Postgres is completely open source.
  - jabl 7y ago
    Well, 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 ago
SQLite 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.

EvanAnderson 7y ago

SQL Server has Service Broker (my prize winner for most undervalued and unknown feature in a mainstream software product) that does a tremendously good job of solving these types of problems. I can't say how well it scales, but it has done a reasonable job at every workload I've thrown at it.

dfox 7y ago
IMO the reason why Service Broker is mostly unknown and undervaluated is the name itself. It sounds like something horribly complicated, while it in fact is relatively straightforward implementation of pub/sub.