- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
It's easier for almost any database to do some things than mysql.
Well, if yahoo doesn't need any transactions, referential integrity, etc. fine with me. Question is: what about their inhouse systems, such as accounting, etc.? Do they run also on mysql? I'd rather doubt that.
l.
Admin
Considering options such as RAC, I'd question that on a general basis. Middle layer may help in some cases, but can also hurt in others.
Yes, vendor lock in. But that can happen with any other system. OSS counterparts would at least give you the option to continue development if the responsible developer team behind the said product would leave.
It also depends on the number of users, etc. and it keeps evolving. Even Oracle aims for "free" (XE) or for a reasonable price (5 user SE) with multiprocessor/clustering options.
Just imagine unique/foreign constraints handled by the middle layer and not the database itself - and that's something to consider in the DB agnostic approach.
And the problem with middle tier caching is: how do keep that one consistent? What happen's to that cache, if some other source changes the data inside the database?
l.
Admin
Does anyone else come to this site, just for a pick me up when they are doubting their own leetness?
Admin
Dude. you can not have just seriously downplayed the usefulness of triggers. What, you want to do everything on the application level? That's no way to treat data of any real value.
I'm not saying MySQL doesn't have it's serious, good uses... but if you have some data that should always change based on the state of other data, it's very good to have a single point of failure, and it's very bad to assume that future application developers will know that the value in foo needs to be recalculated when the value in bar changes.
If you don't have such a data-dependent recalculation, or you swear you'll only, ever, have one application touching your database, then go ahead, use whatever tool suits you. But don't say triggers are never used. They're used often, even if you haven't seen it done yourself, and they're very useful.
Admin
would there be any other reason? Oh, yea, to get a giggle out of the crap some people do.
Inadvertantly, I once learned something about C# syntax, I think, but like I said, I didn't mean to learn anything.
Admin
In defense of VBA apps-- they exist because the "heavyweight" tools suck at delivering fast solutions to simple problems.
In the right context, a VBA app can be a great thing.
Admin
OMG ! Did he generate the table schemas ?
Admin
That's the marketing words when I'm too lazy to code in java.
Admin
That's not entirely true, but it doesn't really matter.
I doubt it too - that's not really an area we've ever discussed.
You are also assuming that the MySQL they use is not modified in-house, which would surprise me. I don't know the specifics, but damn near everything the run they've made code changes to.
Admin
Would it be okay if a Canadian brought it up?
And if you don't mind, we'd prefer that you colour your own arse. I mean ass. Or at least visit a licensed, regulated, and recently-vetted tattoo parlour to have the procedure carried out. I mean, trusting your backside to a bunch of code monkeys?
Admin
MySQL isn't being used by Yahoo! to power any applications with lots of updates. Or applications where data integrity is mission critical. Or where the data itself is mission critical.
Quite a bit of the usage is from legacy applications as well [1].
We use MySQL a lot too [2].
[1] I do not work for Yahoo!, but I do know quite a few good people in their development department.
[2] Legacy. We are now looking at upgrading hardware and rewriting code to use PostgreSQL [3].
[3] Lots of C code. We need lean and fast. Programmer time is cheap as compared to operating costs (the difference between works and does not work at all).
Admin
No, he doesn't. That's just a slang way of saying "We English programmers"
Admin
There was missing a "better". And I used the term "almost" and "some things". But you are right, since I didn't add any further defnitions, it really doesn't matter.
Yahoo has been used as an example for the successful use of mysql. If the scope was Yahoo's web site, fine with me. Unfortunately are web sites only a fraction of today's existing IT applications.
Even if mysql is heavily modified, so what? Did Yahoo it's own trigger/stored procedure language? Foreign Constraints? Transactions? Consistent reads? If not, I wouldn't trust that system mission critical data.
l.
Admin
i know who you are and what you are up too! my question is why???