Ambiguous. You can't say one is better than the other. MySQL actually has pluggable database engines, and if you're comparing Postgres to InnoDB, they have a lot in common. I don't know of anything different about the Postgres transaction engine and InnoDB.
It's always bothered me how slow postgres is sometimes. It doesn't take anywhere near a million records to see speeds slow to a crawl.
MySQL, on the other hand, can be optimized to be faster than anything else out there. I've heard Oracle is faster in certain circumstances, but I don't know enough about oracle. Check out all the ways to optimize MySQL queries like fixed length rows and indexes, natural sort order, table and index defragmenting, hash lookups, mysql 5 has an index merge algorithm which was always a sore spot in the past, but now puts it up there with the rest of the big time databases (I'll include Postgres in that category for the sake of argument).
Personally I see less and less reason to use ANYTHING but MySQL these days. It's only a matter of time before MySQL is king. I don't really pay any attention to the license restrictions. As long as I have the source code on my computer I am happy.
The server in this case would be built into the programming language. There's nothing magic about SQL, in fact, it's just a hacked down version of any decent procedural programming language.
If you knew how complex the SQL query optimizer was, for any given database, you'd know that the same could be implemented in any programming language. Selecting the right indexes to use, table order, all that... nothing magic about SQL, in fact there is a lot wrong with it.
C++ is also optimized you know, you can write C++ code in a number of different ways, often times the compiler will reduce different C++ styles to the same machine code. Programming languages have so much in common with SQL it would make sense to combine them. You could practically emulate SQL in ruby.
Well the constructs in any given language are the same, loops and what not. Some languages have shortcuts to do what they want, SQL has "cursors" that you can use to loop through resultsets.
While a language like ruby could make use of iterators to type things faster, like Order.each(:order_by => 'date_received') do |order| in PHP for example you'd probably have to do something like foreach( Order::find(['order_by' => 'date_received']) as $order ) {
Ruby fits into the dynamically typed languages category. There are few other popular languages in this category, and they can all be represented as frontends to parrot (which means perl, ruby). Statically typed OODBMS's would be fundamentally different, but could be tied into microsoft.net (mono) and support all languages in the family. There are already a few oodbms's out there for C++, I don't use C++ anymore though.
The DB wouldn't have to be optimized for one language, it would just have to have an optimizer for the language you want to use it with. It'd be like a client API, except much more complicated.
You sound like a left wing political propaganda machine. You're like the talking heads, except you'd never get elected with your attitude. By the way, you don't have to go dodge bullets in order to serve your country. I didn't, I was a member of the Air Force, closely associated with the NSA. OOOO scarey huh? And don't tell me you're some old-time veteran. You're a stupid little kid. With age comes wisdom, kid.
That was soooo last post, dude! You said we shouldn't be engaged in free trade with state owned corporations, I was giving you an example of one that owns a larger share than any other.
I served in the first gulf war you fucking worthless pile of shit. You're full of mindless babble, and apparently you enjoy making an ass out of yourself with mindless insults.
And next I know you'll be telling me that we never landed on the moon! You're nuts. If you don't know what nuts means, ask mommy and daddy, ya little kid.
Listen to yourself, all arab nations are full of islamic fanatics and we should cut off all dealings with them? Listen to how ridiculously absurd you sound. You're more comparable to Hitler.
I'm not going to argue with you, you're a liberal fanatic, comparing Bush to hitler is fucking bizarro nuts, you're living in your own cesspool of thought. You're a hipocrite for hating all arabs and wanting to cut off all relations with arab governments. You're an idiot for not knowing what you're talking about. The port of long beach, where I used to live, is practically owned by China.
I want a house that goes underground quite a ways, with tunnels and what not, a tunnel that go to an underground river, another tunnel that just goes to another small workshop on the property, a shaft that goes 100 feet down, where I hide my gold!
I don't think you're making much sense. OOP doesn't handle many-to-many relationships very well? I don't know what your idea of OOP is, but in ruby, we have iterators.
Orders.addresses.each do |address|
address.do_stuff
end
So far no OOP database has hit the mark, the problem is it is mostly tied to one language. Most of the cross-platform OOP databases don't do anything more than relations and single-column indexing. What needs to happen is all of the features of a particular RDBMS need to be implemented IN THE LANGUAGE the OOP database was designed to support, so for example, instead of selecting all addresses from orders in the state of California or Nevada in SQL, you'd just say
Orders.addresses.each do |address|
next unless ['CA', 'NV'].include?(address.state)
end
This is basically what the RDBMS does when you SELECT... WHERE state IN ('CA', 'NV') but it would be optimized in the program code. Oracle wants you to write your entire application in the database, I want the database to be in my application, that's what OOP databases should focus on.
"I mean, we've got Chavez in Venezuela with a lot of oil money," Rumsfeld added. "He's a person who was elected legally -- just as Adolf Hitler was elected legally -- and then consolidated power and now is, of course, working closely with Fidel Castro and Mr. Morales and others."
That's not a comparison, other than to say that they were both elected democratically. I'm talking about people saying Bush is the next Hitler, going to start world war 3 and all that, imperialism. Just listen to that colorado teachers rant. "No worse than hitler". That's the kindof shit I read from people on slashdot every day.
Pakistan isn't islamic fanatics, what have they done lately to make you think that? I think you just feel how you want to feel, and nothing ever changes. I suppose you think the UAE is a bunch of fanatics also.
What happened to all the SD music players? I can buy a 4 GB SD card on ebay, mix and match with my phone and my camera. If it doesn't have SD I don't care much for it.
Those data packets only cost a lot because not many people use the service. Back when cell phones were new, you paid $1 per minute in addition to some monthly service charge, and the phone was 10 pounds.
Logistically, cell phones are cheaper than land lines, it is only a matter of time before the cell phone is unlimited use, and half the price of a land line.
There is a LOT of unused bandwidth out there, the FCC is just waiting to disperse it.
I love it when I'm snowboarding coming up behind a boarder with headphones in his ears, he doesn't hear you coming and swerves right into your path. Ipods everywhere, it's attack of the pod people. I'm pretty sick of seeing them, some goon while I'm waiting at the DMV to get my license renewed sitting their bouncing up and down with his god damn IPOD! want to smack them, want to smack them
It was the only one that had an ice maker I could tolerate
That is damn funny that you can't stand icemakers. I'd have divorced you by now. Icemaker is like the last thing I look at when buying a fridge, all the higher-end fridges have them. I thought it was the mans job to look at how much the thing costs to run every year, kwh per month er whatever. It's wifey's kitchen, so I just let her pick everything, although I bought her an automatic can opener with a beer bottle opener on it.
I bought the kenmore fridge from sears. They get highest consumer reports every year, for the ones in the $1000-$1500 range, and the ice dispenser has a funnel on it. Good old funnels!
Nothing to do with Samsung, but the player supports napster. Most of the music I like is available for free with a subscription to napster. I prefer the napster model because I don't feel buying music is worth it, I get sick of music after hearing it a few times. It might be worth it to listen to all my old music 10 years from now (THEN AGAIN, MAYBE NOT!) but if I were forced to buy every song I wanted to hear, I'd just listen to the radio. Napster is an excellect compromise. I can load my player up with Rachmaninoff one day, and mozart the next. Plenty of free classical. I think the latest pop music is what you can't find for free on napster, if you're into pop music itunes might make more sense.
As for samsung, I hear you about their quality. They are up there on my list, along with Hitachi. I sold sprint cell phones like 5 or 6 years ago and the samsung phones were by far the best. My crappy nokia broke and I didn't have a warranty on it, so rather than fork out $200 for a new phone, I bought an old samsung 3500 on ebay for $1, hehe. Thing works great, and you can drop it all you want, probably run over it with your car.
Slashdot Mirror
Do you wear a football helmet when you drive? Just curious.
I know PostgreSQL is a better database engine
Ambiguous. You can't say one is better than the other. MySQL actually has pluggable database engines, and if you're comparing Postgres to InnoDB, they have a lot in common. I don't know of anything different about the Postgres transaction engine and InnoDB.
MySQL, on the other hand, can be optimized to be faster than anything else out there. I've heard Oracle is faster in certain circumstances, but I don't know enough about oracle. Check out all the ways to optimize MySQL queries like fixed length rows and indexes, natural sort order, table and index defragmenting, hash lookups, mysql 5 has an index merge algorithm which was always a sore spot in the past, but now puts it up there with the rest of the big time databases (I'll include Postgres in that category for the sake of argument).
Personally I see less and less reason to use ANYTHING but MySQL these days. It's only a matter of time before MySQL is king. I don't really pay any attention to the license restrictions. As long as I have the source code on my computer I am happy.
If you knew how complex the SQL query optimizer was, for any given database, you'd know that the same could be implemented in any programming language. Selecting the right indexes to use, table order, all that... nothing magic about SQL, in fact there is a lot wrong with it.
C++ is also optimized you know, you can write C++ code in a number of different ways, often times the compiler will reduce different C++ styles to the same machine code. Programming languages have so much in common with SQL it would make sense to combine them. You could practically emulate SQL in ruby.
Order.select([column1, column2], :join => Person, :where => (Order.person_id == Person.id)).print_as_grid
While a language like ruby could make use of iterators to type things faster, like Order.each(:order_by => 'date_received') do |order| in PHP for example you'd probably have to do something like foreach( Order::find(['order_by' => 'date_received']) as $order ) {
The DB wouldn't have to be optimized for one language, it would just have to have an optimizer for the language you want to use it with. It'd be like a client API, except much more complicated.
Don't take it from me, take it from a respectable economist.
http://www.foreignaffairs.org/20040501faessay83304 /daniel-w-drezner/the-outsourcing-bogeyman.html
You sound like a left wing political propaganda machine. You're like the talking heads, except you'd never get elected with your attitude. By the way, you don't have to go dodge bullets in order to serve your country. I didn't, I was a member of the Air Force, closely associated with the NSA. OOOO scarey huh? And don't tell me you're some old-time veteran. You're a stupid little kid. With age comes wisdom, kid.
I served in the first gulf war you fucking worthless pile of shit. You're full of mindless babble, and apparently you enjoy making an ass out of yourself with mindless insults.
And next I know you'll be telling me that we never landed on the moon! You're nuts. If you don't know what nuts means, ask mommy and daddy, ya little kid.
I'm not going to argue with you, you're a liberal fanatic, comparing Bush to hitler is fucking bizarro nuts, you're living in your own cesspool of thought. You're a hipocrite for hating all arabs and wanting to cut off all relations with arab governments. You're an idiot for not knowing what you're talking about. The port of long beach, where I used to live, is practically owned by China.
I want a house that goes underground quite a ways, with tunnels and what not, a tunnel that go to an underground river, another tunnel that just goes to another small workshop on the property, a shaft that goes 100 feet down, where I hide my gold!
So far no OOP database has hit the mark, the problem is it is mostly tied to one language. Most of the cross-platform OOP databases don't do anything more than relations and single-column indexing. What needs to happen is all of the features of a particular RDBMS need to be implemented IN THE LANGUAGE the OOP database was designed to support, so for example, instead of selecting all addresses from orders in the state of California or Nevada in SQL, you'd just say
This is basically what the RDBMS does when you SELECT ... WHERE state IN ('CA', 'NV') but it would be optimized in the program code. Oracle wants you to write your entire application in the database, I want the database to be in my application, that's what OOP databases should focus on.
Oddly, my friend divorced her husband last year for almost that exact sentiment.
Odd that they were married to begin with. Sounds to me like that was the least of their problems.
That's not a comparison, other than to say that they were both elected democratically. I'm talking about people saying Bush is the next Hitler, going to start world war 3 and all that, imperialism. Just listen to that colorado teachers rant. "No worse than hitler". That's the kindof shit I read from people on slashdot every day.
Pakistan isn't islamic fanatics, what have they done lately to make you think that? I think you just feel how you want to feel, and nothing ever changes. I suppose you think the UAE is a bunch of fanatics also.
What happened to all the SD music players? I can buy a 4 GB SD card on ebay, mix and match with my phone and my camera. If it doesn't have SD I don't care much for it.
They don't include it because some linux hacker will do it within a month after release.
Logistically, cell phones are cheaper than land lines, it is only a matter of time before the cell phone is unlimited use, and half the price of a land line.
There is a LOT of unused bandwidth out there, the FCC is just waiting to disperse it.
I love it when I'm snowboarding coming up behind a boarder with headphones in his ears, he doesn't hear you coming and swerves right into your path. Ipods everywhere, it's attack of the pod people. I'm pretty sick of seeing them, some goon while I'm waiting at the DMV to get my license renewed sitting their bouncing up and down with his god damn IPOD! want to smack them, want to smack them
It was the only one that had an ice maker I could tolerate
That is damn funny that you can't stand icemakers. I'd have divorced you by now. Icemaker is like the last thing I look at when buying a fridge, all the higher-end fridges have them. I thought it was the mans job to look at how much the thing costs to run every year, kwh per month er whatever. It's wifey's kitchen, so I just let her pick everything, although I bought her an automatic can opener with a beer bottle opener on it.
I bought the kenmore fridge from sears. They get highest consumer reports every year, for the ones in the $1000-$1500 range, and the ice dispenser has a funnel on it. Good old funnels!
As for samsung, I hear you about their quality. They are up there on my list, along with Hitachi. I sold sprint cell phones like 5 or 6 years ago and the samsung phones were by far the best. My crappy nokia broke and I didn't have a warranty on it, so rather than fork out $200 for a new phone, I bought an old samsung 3500 on ebay for $1, hehe. Thing works great, and you can drop it all you want, probably run over it with your car.
I'll show YOU a gigakelvin of quark-gluons!
I like the little diving board, so you can dive in for a refreshing dip into the electricity.
Maybe they discovered double-quasmo-hyper thrusters.
Whenever someone says "from TFA" I think to myself "from the fucking article", is that what the acronym really means?