5 ms·
Postgres is not hype though. There's very few legitimate use cases for not using a RDBMS as a main data store, and Postgres happens to be the most popular nowad
by thiht 3y ago
Postgres is not hype though. There's very few legitimate use cases for not using a RDBMS as a main data store, and Postgres happens to be the most popular nowadays, for good reasons.
- bradleyjg 3y agoThe number one reason being that it’s free. In a purely technical comparison it is not at the top of the list.
- simonw 3y agoWhat's top of the list technically?
- bradleyjg 3y agoOracle
- VWWHFSfQ 3y agoAnybody that has ever used Oracle knows how nice it is. But very few people have that experience because their company isn't spending millions of dollars on the database server.
- bradleyjg 3y agoYes, that was my point. I get that working with Oracle and their army of lawyers is not cheap or pleasant but the db is still excellent.
- pmarreck 3y agoOracle is a giant mess, is the sense I got from trying to work with it in the past. While I am loathe to recommend any Microsoft product, SQL Server is at least coherent, and has actual transactions like Oracle (and not just "checkpoints")
- paulryanrogers 3y agoAren't MSSQL and Oracle just doing redo logs, like MySQL? What do you consider not actual transactions? Postgresql keeps dead tuples in place until vacuumed, which seems optimized for rollbacks. But isn't so bad if you're inserting much more than deleting or updating.
- pmarreck 3y agoNestable transactions = “real transactions” to me, I guess. I almost don’t see the point in non-nestable transactions
- paulryanrogers 3y agoSQL standardizes SAVEPOINT for such nesting. Is that not sufficient? FWIW Postgres supports it.
- oldsecondhand 3y agoIn my experience MySql is more popular. Worked at several companies that used MySql, none that used Postgres. Kids at universities still use XAMMP to learn databases.
- lutoma 3y agoIn my experience MySQL is still commonly used in the PHP world, but everything else is mostly Postgres
- circusfly 3y agoI've nothing against Postgres but MySQL is a wonderful option that is likely still in far higher and heavier use, when considering open source databases.
- LtWorf 3y agoI think it gained popularity over a decade ago, when it was faster because it was unsafe. In the end postgres is the better one. With mysql the defaults are bad.
- deleted 3y ago[deleted]
- kstrauser 3y agoIn my mind, MySQL no longer exists. It’s a weird Oracle thing that I wouldn’t touch with a lineman’s pole. MariaDB is what happened after MySQL disappeared.
- deleted 3y ago[deleted]
- wlll 3y agoI wrote this in another comment, but it's relevant here I think: " I do scaling and performance work, mostly with Rails apps, but a significant amount of the work is database level and not language specific. I've used both postgres and MySQL (and a few other databases) going back to 2000. The best thing I can hear from a company when I start is "We use Postgres". If they're using postgres then I know there's likely a far smoother path to performance than with MySQL. It has better tooling, better features, better metadata. " Right now I would not choose MySQL over Postgres at all, ever. I can't think of a single way it is materially better.
- deleted 3y ago[deleted]
- darby_eight 3y ago> There's very few legitimate use cases for not using a RDBMS as a main data store I don't think that's true—all the old cases that were legitimate before are still legitimate. The price of both persistent storage and memory has simply come way down to the point where many computational workloads are viable under vertically scalable databases again. I suspect the pendulum will swing the other way one day yet again (and of course there is a rich ecosystem of ways to query horizontally, if not transactionally, with SQL that will likely temper this swing even further).
- wlll 3y agoThe price of persistent storage and memory was the same for Mongo as it was for Postgres back when the NoSQL movement happened. Mongo wasn't made of magic scaling fairies and still needed resources. As soon as you cranked up the safety of Mongo to a nearly acceptable level it's performance fell through the floor. The only reason people though it performed amazingly was because of Mongo's rather deceptive marketing. I use the term "nearly acceptable" because for a long time Mongo's data consistency was absolutely crap (https://jepsen.io/analyses https://jepsen.io/analyses) Personally I think people used Mongo because it was new, shiny and exciting and it promised performance (though it didn't really deliver for most people).
- darby_eight 3y agoI am certainly not going to defend mongo ever having being a good choice; I was referring to other "NoSQL" databases (namely, the large number of highly scalable key-value stores).
- thiht 3y agoBut you wouldn’t use a key value data store as your main store. It’s a specialized kind of store. Of course Redis and friends have their place. Just not as a main store.
- darby_eight 3y ago
- jimbokun 3y agoIn my opinion the use case is when your data no longer fits on a single, potentially very large, server. Automatic distribution and replication and rebalancing of data is a tricky problem and something like Cassandra handles those very well. Or Cockroach DB or similar, if you still need relational capabilities.