Row level locking may be in mysql now, i gladly admit that i don't follow the development of it, but that's standard in pretty much every database made since 1996 or so, it's not special. if anybody tells you that most databases don't do it, they're wrong.
I never said foreign key constraints aren't possible, I said to use them you have to use InnoDB tables, which aren't fast. I said check constraints aren't implemented, because they aren't. In MySQL CHECK is a no-op which always returns true, whether the condition is true or false.
"on cascade" triggers aren't what i meant by triggers. A real trigger lets me do something like create a rule saying 'on an update to table foo, write some other shit in table bar', or 'if the update to table foo attempts to change the userid, kill the transaction, and write something to a log'.
And dozens of tables doesn't imply a complex database structure, it merely implies that there are dozens of tables. a few gigs of data also does not imply a complex database structure, or something that should be particularly challenging for the database to handle quickly either.
MySQL has more limitations than that too, it can't even have the default value for a field be variable. You can't do something like:
expires TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP + '2 days' because that's not a constant.
as far as quirks and limitations of interbase, i can't say anything because i've never used it heavily.
As for postgres, yes, there are some things it can't do, but far, far, far fewer than mysql. PL/pgSQL is no match for PL/SQL but it beats the shit out of mysql's procedural language (you know, the non-existant one). It has some annoying limitations, like the fact that you can't use the return value of a function as a CHECK constraint, but to find the limitations of Postgres (and believe me, I'm good at finding the limitations of Postgres) you need to be attempting to do fairly advanced and complicated things. To find the limitations of MySQL, you just need to take somebody who learned SQL on a real database and ask them to solve a simple problem. Odds are good they'll do something that MySQL does not support.
Re:have you considered MySQL?
on
PostgreSQL vs. SAP?
·
· Score: 4, Insightful
MySQL is great. As long as you don't want stored procedures. Or triggers. Or sub-selects. Or row locking. Or check constraints. Or views. Or inherited tables. Or performance that doesn't disappear as soon as you have a moderately complex database structure.
Yes, you can now have transactions and foreign keys, but to get them you'll be using InnoDB tables, which don't offer up any significant speed advantage. They run at slightly slower than postgres speeds, in my testing.
MySQL sounds really good, especially if you haven't worked with real databases before, so you don't know what they're supposed to be able to do, but in the end it's not. Unfortunately, telling mysql advocates this is like convincing a Best Buy employee that overall PC performance cannot be compared by looking at the CPU clock rate.
Until I actually use one of these things, I have some serious doubts about it's usability. After all, their website puts the text of the specifications into a gif that's nearly impossible to read, and then puts this hard-to-read black text over a dark backgrounded making it even harder to read.
Now go to news/press, and read the article with a nice high-res monitor. You'll find that the text of their press release is inside a borderless box that doesn't offer a vertical scroller. Instead you have to put your mouse over some up and down arrows, and wait for the text to slowly scroll into the visible area.
It's a nice idea, but if they can't make a usable website, what are the odds that they can make a usable PDA? Anybody who ever counted themself as a Palm user knows that the key to a good PDA is quality interface design, not speed or memory.
BAD: wastes time of the individual telemarketer, unfairly targets a real person just trying to do their job and make some money.
Real people who knowingly, and willingly engage in a profession which consists entirely of annoying and scamming people. They became fair targets when they accepted the job.
BTW, ever notice that few people would treat telemarketers with the same disrespect if they were face-to-face with them?
Ever notice that few people would actually engage in the tactics that telemarketers use in a face-to-face situation? Ever notice that if somebody used those tactics, you'd probably end up telling them to sod off and you certainly wouldn't make a purchase from them? Something about talking over the phone makes it easier for them to ignore the fact that they're disrupting peoples lives, and they could at the very least just hang up when the person politely expresses that they have no interest in the product/service.
If you have a few minutes to spare, what's even better is to say 'I'm making an official request for your no-call policy, as I am entitled to by law. I'd like to provide you with all the information neccessary for you to mail me a copy of your no-call policy.'
At this point they may hang up, or get confused and put you on with a supervisor who will know about this and take the information.
Now that they have the information, request to be added to their No-Call, and No-Sell lists. By this point you've cost them a lot of phone time, often with a supervisor, plus they usually actually do mail you the no-call policy, and you get blacklisted for being a pain in the ass who knows the law, thus helping make sure you don't get any more calls.
The ideal solution would be for him and his fellow employees to stop working for dishonest child labor employing mega-corporations who destroy local businesses and don't even have good coffee.
This solution would obviate the need for this hackery, allow for them to listen to better music, and help make the planet a slightly nicer place to live.
Well, a hockey game has attendance limited to somewhere around 20,000, as opposed to a couple hundred million possible consumers for a television program. And in hockey, they don't print ads around the top of the glass, they put them in places where it doesn't affect your ability to view the game itself, like on the boards, on the stairs, around the balcony, on every side of the scoreboard.... but not anywhere that makes it so you can't see the action.
I don't mind product placement either. I know from the Men In Black previews that I'm supposed to want a Mercedes E class, with about 26 coats of paint and a good wax on it. This does not bother me.
I'm not saying there should be no ads anywhere, hell, I like good advertising. It doesn't bother me that when I go to the orchestra, I walk into Verizon Hall, but I'd cancel my subscription in a second if during the performance a James Earl Jones walked out and announced 'This performance is brought to you by verizon'. There's no excuse whatsoever for advertising that destroys the main content, and I think the argument that advertising is neccessary contains fundamental flaws.
The obvious question I have is why doesn't my monthly bill cover expenses to begin with.
I pay about $150/mo to DirecTV and another $50/mo to comcast. I watch maybe 60 hours of TV/month, plus however many hours of animal planet my dog watches while I'm not home.
It seems to me that $3/hr is enough money that I really shouldn't need to be bothered with ads. They just need to find a better way to split the money.
My mother died due to an incompetent doctor who missed an overian cancer diagnosis (it was only found because the techs accidentally did an ultrasound on the wrong quadrant and found massive tumors). The doctor had diagnosed it as irritable bowel syndrome for many months, allowing the cancer time to spread. By the time it was found, it had spread badly. (Stage 4, T3c, N1, M1)
Overian cancer isn't a rare disease. Her symptoms were not rare variants of standard symptoms. The doctor just didn't think to check for it. A computer in the waiting room that asked her to fill in some questions would've given her a better chance, since it would've at least put the possibility of cancer into the doctors head.
I agree with the AC that it's irresponsible to eschew technologies which can help save lives without even giving those technologies a fair evaluation.
Doctors are trusted to evaluate our health, and help us find a way to survive. If I want comfort I'll go to church. If I want an accurate diagnosis and the best hope of survival, I'll go find a doctor, preferably one who doesn't believe that he has an infallible memory and perfect diagnostic ability.
As far as standing up to the entire medical community and attempting to force best practices, I'd love to do that to the whole industry, but in the meantime I do it the best way I can, by voting with my wallet. I patronize a doctor who has been using this system for a few years now, and I'll continue to do so, no matter what the cost.
There already is a toll on all the tunnels and bridges to Manhattan, and it's $4 or $5 for EZ-Pass users, or $6 if you want to pay cash. I've not seen any hell raised so far, holy or otherwise.
yes, because 'Hey Baby, hey baby, hey baby, yeah baby' is less repetitive than good trance.
trance works by creating a pattern, then modifying elemnts of the pattern at varying rates. clearly this is a strategy that doesn't work if you don't repeat things. go listen to an album by infected mushroom or growling mad scientists and then try to honestly tell me that there is no such thing a great trance music.
Chaos Existence also sells some really tasty psytrance, and has all-track real-audio preview of a lot of their inventory, and is run by really friendly folks to boot.
Ugh, massinova not only has the amazing sound quality of a high-power AM radio station, but the music selection is just pathetic. It's all extremely mainstream music, most of which was made long before the year 2000 came upon us.
I'd suggest a better one, but I like the fact that my favorite stream isn't slashdotted.
I was going to give Gnome and KDE $50 each, these are both worthwhile projects which push the unix desktop forward, partially by pushing each other forward. They are monumental projects, whose success is surprising, impressive, and truly an amazing accomplishment. They're helping build Free as in Speech software, to help build a better tomorrow, and they need my support.
Then I remembered, this is Open Source Software. It's supposed to be Free as in I'm a cheap bastard so give me a free os, unmetered cable modem, and 100 gigs of downloaded mp3s. Now I've got to go reboot to windows to burn some cds, browse the internet, watch a dvd, and play some games. I use Linux for everything else though!
Like so many environmentalists you take the worst-case scenario, then apply it to everything. Allow me to cite this bbbc article
one study of nine Brazilian reservoirs found their greenhouse emissions varied per unit of electricity by a factor of 500.
the 'worse than coal' hydroelectric plants were the ones at the top of that spectrum. This means that there are also reservoirs which generate.2% of the emissions that the high-emission reservoirs generate, which would be far, far less than any fossil fuel based plant using current technology.
Clearly, there's no clear answer for whether or not a dam is definitely cleaner, but clearly, hydroelectric can be significantly cleaner than fossil fuels.
Oddly enough, that's a genuine c2it affiliate link. I wish they'd use c2it.com, but m0.net seems to have convinced citibank and american express that we should trust somewhat cryptic domain names. On the plus side, it does redirect back to c2it.com by the time you're asked to enter your information to setup or use your account.
Slashdot Mirror
Row level locking may be in mysql now, i gladly admit that i don't follow the development of it, but that's standard in pretty much every database made since 1996 or so, it's not special. if anybody tells you that most databases don't do it, they're wrong.
I never said foreign key constraints aren't possible, I said to use them you have to use InnoDB tables, which aren't fast. I said check constraints aren't implemented, because they aren't. In MySQL CHECK is a no-op which always returns true, whether the condition is true or false.
"on cascade" triggers aren't what i meant by triggers. A real trigger lets me do something like create a rule saying 'on an update to table foo, write some other shit in table bar', or 'if the update to table foo attempts to change the userid, kill the transaction, and write something to a log'.
And dozens of tables doesn't imply a complex database structure, it merely implies that there are dozens of tables. a few gigs of data also does not imply a complex database structure, or something that should be particularly challenging for the database to handle quickly either.
MySQL has more limitations than that too, it can't even have the default value for a field be variable. You can't do something like: expires TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP + '2 days' because that's not a constant.
as far as quirks and limitations of interbase, i can't say anything because i've never used it heavily.
As for postgres, yes, there are some things it can't do, but far, far, far fewer than mysql. PL/pgSQL is no match for PL/SQL but it beats the shit out of mysql's procedural language (you know, the non-existant one). It has some annoying limitations, like the fact that you can't use the return value of a function as a CHECK constraint, but to find the limitations of Postgres (and believe me, I'm good at finding the limitations of Postgres) you need to be attempting to do fairly advanced and complicated things. To find the limitations of MySQL, you just need to take somebody who learned SQL on a real database and ask them to solve a simple problem. Odds are good they'll do something that MySQL does not support.
Yes, you can now have transactions and foreign keys, but to get them you'll be using InnoDB tables, which don't offer up any significant speed advantage. They run at slightly slower than postgres speeds, in my testing.
MySQL sounds really good, especially if you haven't worked with real databases before, so you don't know what they're supposed to be able to do, but in the end it's not. Unfortunately, telling mysql advocates this is like convincing a Best Buy employee that overall PC performance cannot be compared by looking at the CPU clock rate.
Now go to news/press, and read the article with a nice high-res monitor. You'll find that the text of their press release is inside a borderless box that doesn't offer a vertical scroller. Instead you have to put your mouse over some up and down arrows, and wait for the text to slowly scroll into the visible area.
It's a nice idea, but if they can't make a usable website, what are the odds that they can make a usable PDA? Anybody who ever counted themself as a Palm user knows that the key to a good PDA is quality interface design, not speed or memory.
Real people who knowingly, and willingly engage in a profession which consists entirely of annoying and scamming people. They became fair targets when they accepted the job.
Ever notice that few people would actually engage in the tactics that telemarketers use in a face-to-face situation? Ever notice that if somebody used those tactics, you'd probably end up telling them to sod off and you certainly wouldn't make a purchase from them? Something about talking over the phone makes it easier for them to ignore the fact that they're disrupting peoples lives, and they could at the very least just hang up when the person politely expresses that they have no interest in the product/service.
At this point they may hang up, or get confused and put you on with a supervisor who will know about this and take the information.
Now that they have the information, request to be added to their No-Call, and No-Sell lists. By this point you've cost them a lot of phone time, often with a supervisor, plus they usually actually do mail you the no-call policy, and you get blacklisted for being a pain in the ass who knows the law, thus helping make sure you don't get any more calls.
obviously you've never met my wife.
Criminals use codes and obscurity as well, but they also use encrpytion.
This solution would obviate the need for this hackery, allow for them to listen to better music, and help make the planet a slightly nicer place to live.
I don't mind product placement either. I know from the Men In Black previews that I'm supposed to want a Mercedes E class, with about 26 coats of paint and a good wax on it. This does not bother me.
I'm not saying there should be no ads anywhere, hell, I like good advertising. It doesn't bother me that when I go to the orchestra, I walk into Verizon Hall, but I'd cancel my subscription in a second if during the performance a James Earl Jones walked out and announced 'This performance is brought to you by verizon'. There's no excuse whatsoever for advertising that destroys the main content, and I think the argument that advertising is neccessary contains fundamental flaws.
I pay about $150/mo to DirecTV and another $50/mo to comcast. I watch maybe 60 hours of TV/month, plus however many hours of animal planet my dog watches while I'm not home.
It seems to me that $3/hr is enough money that I really shouldn't need to be bothered with ads. They just need to find a better way to split the money.
My mother died due to an incompetent doctor who missed an overian cancer diagnosis (it was only found because the techs accidentally did an ultrasound on the wrong quadrant and found massive tumors). The doctor had diagnosed it as irritable bowel syndrome for many months, allowing the cancer time to spread. By the time it was found, it had spread badly. (Stage 4, T3c, N1, M1)
Overian cancer isn't a rare disease. Her symptoms were not rare variants of standard symptoms. The doctor just didn't think to check for it. A computer in the waiting room that asked her to fill in some questions would've given her a better chance, since it would've at least put the possibility of cancer into the doctors head.
I agree with the AC that it's irresponsible to eschew technologies which can help save lives without even giving those technologies a fair evaluation.
Doctors are trusted to evaluate our health, and help us find a way to survive. If I want comfort I'll go to church. If I want an accurate diagnosis and the best hope of survival, I'll go find a doctor, preferably one who doesn't believe that he has an infallible memory and perfect diagnostic ability.
As far as standing up to the entire medical community and attempting to force best practices, I'd love to do that to the whole industry, but in the meantime I do it the best way I can, by voting with my wallet. I patronize a doctor who has been using this system for a few years now, and I'll continue to do so, no matter what the cost.
There already is a toll on all the tunnels and bridges to Manhattan, and it's $4 or $5 for EZ-Pass users, or $6 if you want to pay cash. I've not seen any hell raised so far, holy or otherwise.
$5/hr * 40 hrs = $200
$7.50/hr * 80 hrs = $600
Total: $800
Per Year: $41,600
Could I please have the IP address of the servers you admin, so I can give you some knowledge? I'll send you a bill afterwards.
fuck PLUR, i just want bangin' music.
trance works by creating a pattern, then modifying elemnts of the pattern at varying rates. clearly this is a strategy that doesn't work if you don't repeat things. go listen to an album by infected mushroom or growling mad scientists and then try to honestly tell me that there is no such thing a great trance music.
As for the best way to experience the music, I have some suggestions.
I'd suggest a better one, but I like the fact that my favorite stream isn't slashdotted.
It's... slightly larger!!
Then I remembered, this is Open Source Software. It's supposed to be Free as in I'm a cheap bastard so give me a free os, unmetered cable modem, and 100 gigs of downloaded mp3s. Now I've got to go reboot to windows to burn some cds, browse the internet, watch a dvd, and play some games. I use Linux for everything else though!
Clearly, there's no clear answer for whether or not a dam is definitely cleaner, but clearly, hydroelectric can be significantly cleaner than fossil fuels.
The difference being that the vegetation eventually stops rotting. the coal plant continues to burn, and burn and burn.....
Oddly enough, that's a genuine c2it affiliate link. I wish they'd use c2it.com, but m0.net seems to have convinced citibank and american express that we should trust somewhat cryptic domain names. On the plus side, it does redirect back to c2it.com by the time you're asked to enter your information to setup or use your account.