Slashdot videos: Now with more Slashdot!
If you write a good foundation of libraries and classes you'll need a hack like APC to get any decent execution speed. It also sucks at memory utilization. Everyone likes to link to that "fractal of bad design" article, but it's pretty much just a bunch of whining. Here's a real article that just plain hurts, it has to do with PHP's memory allocation: https://nikic.github.io/2011/1...
Seriously? You think a clustered, 2 site license only runs $100K? Why are you even responding when you clearly have no idea what the pricing is. I assure you, it's NOT a drop in the bucket. Your pricing for the application side is equally clueless, except in the other direction.
One thing very relevant for discussion, that I didn't see mentioned here, is how connections are handled across the different RDBMS. PG still uses one process per connection. This can make its memory utilization grow substantially under high connection counts. Oracle and Mysql don't suffer from this issue.
Just the wording "a DB license" leads me to believe your exposure is with smaller companies and smaller datasets. Have you ever priced a single 32 core Oracle installation with the data warehousing option enabled? If it's a business of any size, you'll need to cluster for reliability, so multiply that single license out. And if it's a publicly traded company, you'll probably need an offsite standby cluster. Even though it sits there and does nothing 24/7, the licensing fee for the standby cluster will be the exact same price as if it was the primary. Also, don't forget dev and testing environments, those aren't free.
Not every large company is a high-margin high tech company. The retail sector, for example, has mountains of data and relatively low margins. DB license expense can be a big concern.
Can you read? I said "the ease in application of DDL changes", not that the application was applying DDL. In other words, when our DBA applied changes under Oracle, packages would be invalidated and all users had to exit the application. This issue doesn't exist under PG. You're an idiot, BTW.
Yes, DDL application is transactional. The company I work for went from Oracle to PG last year. The ease in application of DDL changes was a huge benefit that we didn't originally anticipate.
You nailed it. The AC's idea that all data access is performed via a single application is naive. There are cases where the only common interface point between applications is the database.
It's not cheap at all once you get into even just medium-scale usage. If you have a situation where you are starting out small but plan to grow, you need to really consider whether it's wise to go with a commercial RDMBS, because the pricing does get nasty when you get to the point of needing clusters, high core counts, and standby sites.
I can second this, I've used Hover for over 10 years, from back when Tucows first offered OpenSRS.
It was a joke, have you ever looked at the "food" available at a sporting event?
To carry forward from the parent, do you think that a hunter/gatherer could imagine that someone would pay to eat the food at a basketball game?
You're aware that the OS was named "Windows" for a reason, right? And that you can't install the OS separate from the UI?
You are right, I am failing to adequately communicate what I am saying. That a transaction can be retried is a byproduct of the atomicity requirement that a transaction fills. Retrying a transaction, because there is an ongoing problem with the database system dropping connections, is a sloppy hack.
You said that the point of a transaction is to enable the ability to retry it. I said that was not the point. I don't see how we are saying the same thing.