You are confusing the UK with the US. It's understandable because... well, really it's not understandable. You are simply wrong. Thanks for playing, though.
My generalizations were good enough for the original poster's purposes. He has a hobby website, not an enterprise application. Any anyway, I was not answering a question about which db would perform better for his application. He never asked which db would perform better.
He asked if pgsql was more widely-used than mysql, and I said no, it is not, and gave some reasons why. One of the many reasons that mysql is so much more prevalent than pgsql happens to be performance. Since we are talking about many many applications, not his specific applications, I can say with total comfort that in the majority of applications, my generalizations will hold. That mysql will yield better performance than pgsql. In all applications? No. In his application? Who knows? But if you are looking at popularity, you have to look at what is most commonly the case.
Most commonly, for a simple-data-model dynamic content website, mysql will beat the pants off of pgsql. I'm sorry to say it, but it is true. It is certainly not true in all cases. But it will be true in the majority of cases. Deal with it.
And yes, that is one of the many reasons why mysql is vastly more popular than pgsql. Nothing against pgsql. I'd use it if all my apps supported it (I run one app, mythtv, that will not support pgsql, and I see no reason to run two database servers when every app I run supports mysql). I'm glad it's out there and that it's available. But more often than not, it is going to be slower than mysql for simple data applications.
I asked about Wisconsin because of your slashdot userid. The fraternity that I am in designates chapter and initiation year as X'YY with X being the letter of the school and YY being the initiation year. I guess if you were F'79, that would make you a pretty old Wisconsin alumnus.:-)
mnovotny writes "Computerworld reports that Microsoft is finally set to release their belated SQL Server 2005. From the article: 'Despite a two-year delay, several users who have tested the software cited the improved performance and new functionality it brings as positive developments that likely will convince them to upgrade soon.' The free version can be downloaded directly from Microsoft."
When Debian Sarge was finally released, the slashdot writeup went so far to assert that "Hell has officially frozen over!". So the sword cuts both ways.
For a small website, MySQL is overwhelmingly more popular then Postgres. The reasons for this are:
MySQL is very simple to learn
MySQL is supported by virtually all webhosting companies, whereas you have to look pretty hard to find a host that provides PostgreSQL.
MySQL historically has performed much better than Postgres for both reads and writes. Nowadays, MySQL only outperforms Postgres on reads. So for a website, where most database calls are SELECTs, MySQL will often (but not always) give better performance.
Nearly all blog, forum, photo gallery, etc. packages support MySQL. They do not all support Postgres, but some do.
Now, of course, Postgres has many advantages over MySQL, but for a small hobby website, you should just use whatever you know best and your host supports and your software supports. The answer is normally MySQL for your type of website.
Postgres is generally better than MySQL (though MySQL is closing the gap) in terms of SQL standards compliance and RDBMS-type features. If you're implementing a true DB app, you should definitely give PostgreSQL a second look. But for a web forum, stick with MySQL.
What is your goal of this hobby website? To run the actual website? Or to learn about many different database engines?
If your site uses one DB or the other and is working just fine, then why would you want to rip out the DB and start over? I can't tell you how to spend your time, but if it were me, I'd spend time adding new features or promoting the site or contributing in other ways to your community. Switching DB engines is a waste of your time and effort.
In general, conservatives do believe that evolution exists. It's not like they sit there and watch bacteria and viruses evolve, then cover their eyes and repeat 50 times over that what they just saw didn't really happen.
Any intelligent Intelligent Design theorist will readily admit that evolution does happen, but only on a small scale. They acknowledge that evolution happens, but they deny that evolution fully explains how each plant and animal got to its present form.
At least that's as much as I can gather from listening to right-wing-nut talk radio. C'mon. You gotta admit it's entertaining.
MySQL: Simple to install and learn, good enough for many purposes.
PostgreSQL: More feature-complete than MySQL, but takes longer to learn and is more difficult to administer. A good, solid, open-source database.
Oracle 10g: Enterprise DB. No, it is not just an expensive substitute for MySQL+replication.
Oracle XE: ???
Seriously, there are already good, truly-free alternatives to Oracle XE that developers already know and trust. I would not advise a client to use Oracle XE because who knows if it's going to be around in 10 years? Sure, Oracle's flagship database isn't going anywhere, but Oracle could decide that this XE product isn't generating enough revenue to justify its continued development and can it.
That's about the last thing you need. Do have a bunch of imporant data trapped in an unsupported datastore.
Is that you can make that much without suffering through lawschool and suffering through being a first year associate. They work 90 hour weeks, week in and week out. I know a guy whose partner called him a "pussy" for visiting his wife in the hospital after missing the birth of his first child while working.
As for me, I make way the hell more than that, and I take a few months off every year. In fact, this year, I'm taking the rest of the year off because why the hell should I work November and December? I've only taken 6 weeks of vacation so far, so I think I've earned some time off. Yet I have "only" an undergraduate degree. From a state school. And not even a good one. My entire college education cost less than one year of law school. And I didn't have to kill myself studying for the bar.
By the way, I live in one of the most expensive cities in the US, and $70k is nothing. You can't rent a parking spot for $70k/yr, let alone an apartment. My points are:
Becomming a lawyer is not a path to automatic riches. Some lawyers make way the hell more than I do, but many eek by on $50k/yr or less.
Being a lawyer, especially a highly-paid one, really blows donkeys. They work so hard it's insane. No good for me. I like to dick around.
You say you'd like to make $75k and would be willing to kill yourself to do it. Well, personally I don't like to work hard, so it isn't for me, but some people love work, and it sounds like you love work. Good for you. So why don't you go be a lawyer? Or start your own business? Do that, and you'll find out what work really is.
Actually, I don't really see your point. If you want to work your ass off for $75k/yr, nobody's stopping you. But remember, at least in the states, you've got to go to three years of law school, which costs a ton of $US. And after you're done working your ass off in law school, you get to work your ass off for some partner in some law firm.
You know, I have to say it's kind of funny. You know when you're poor and you hear rich people say things like, "money isn't everything" and "money can't buy happiness," etc.? And you think to yourself, "That's something rich people say so poor people don't kill them." Well, I've been poor. And right now, I don't feel wealthy, but John Kerry says I'm wealthy and he really wanted to raise my taxes so I guess it must be true. Anyhow, I have to say, money isn't all it's cracked up to be. There are other infinitely more important things in life. My advice to you is to be happy with what you have. Spend time with your family. Go travel the world. That's what life's really about.
Anyhow, more money is useless if you have no time to spend it.
Regarding being an MD: Being an MD is not necessarily more profitable than a BSEE. Remember, doctors continue their schooling well past getting a BS, which means while the BSEE is out making money, building a nest egg, etc., future physicians are getting up to their eyeballs in debt. They don't even start their careers until age 29. Many specialists don't begin their careers until their mid 30's! That's a lot of years of negative earnings while a BSEE has positive earnings.
Don't forget the interest on the student loan debt. While I have significant savings, the average med school graduate has $100,000 - $200,000 worth of student loans. My money is working for me. Doctors' debt is working against them.
And let's not forget quality of life issues. I work during normal business hours. I have 3 uncles who are various types of doctors and they work crazy hours and carry a pager. In their 50's and 60's! WTF?
So being a doc is not automatically a better life and/or better earnings than being technical.
Also, regarding being a lawyer, that is a total mixed bag. The best lawyers do very well financially, there is little doubt of that. But the hours suck, and if you don't get yourself into a good firm, you're making surprisingly little money. For instance, my father in law's firm pays first year associates between $70-80k. Was it really worth going through law school/bar exam for that?
"Hi mom. I have this great new way for you to call me. First, you find me through a Jabber server. What's Jabber? It's a services-based messaging hub that can locate me wherever I happen to be. No, I'm not running from the law, I just don't sit around in the same place all day. Yes, I still have my cellphone, but... well.. you'll see why I want you to use this new way in a moment. Then you download my openpgp key. Open my front door? No, not that kind of key. An openpgp key! Openpgp? It's a crypographically secure way for us to identify each other and can each be sure that the other is who he claims to be. Recognize each other's voices? C'mon, mom. That's so 2005. Besides, it also will encrypt our conversation so no one can intercept it. No, mom. I already told you I'm not running from the law. I'm not in trouble. Really. You raised me fine. Anyhow, once you have my openpgp key, you use a web of trust to make sure that it's really my key, because anybody could have put a key out there with my name on it and claim to be me. Would their voice sound like mine? Well, how should I know, mom? You're missing the point. If you sign someone's key who has signed someone else's key who somewhere down the chain has signed mine, you'll have some level of assurance that you're really speaking to me. Anyhow, now that you have some confidence it's me, you'll encrypt a session key with ElGamal/RSA, and before you ask, no you can't get into my house with that key either. Lastly, we open up a secure AES256 channel and then we can talk and nobody can intercept our communication. No, mom, this isn't me hinting that I don't want you to call me anymore. I always want to hear from you. That's why I set up this fancy way for use to communicate securely. No, it's not a pain in the ass once you get used to it. It's only 6 orders of magnitude more of a pain in the ass than just calling me. Yes, I am aware that the telephone was invented over 100 years ago and works fine, but there is this thing called CALEA that allows the feds to listen in on our conversations. No, I am not in trouble with the FBI. Seriously! Look, forget I even suggested it. If you want to talk, just fucking call me."
The product market and the labor market are not tied together. The laws of economics do not require your company to increase your compensation based on their success in the product market.
If you feel that you can get a better work environment including compensation package elsewhere, then you should go. Or you could try making the case to your boss that this is what you are really worth. That's what I did many years ago. My company felt that I was worth X while working a ton of unpaid overtime. I thought that I was worth 3X with no unpaid overtime. I left. Turns out I was right and they were wrong. Ain't capitalism grand?
Do you distribute under one of their approved FOSS licenses? If so, you're definitely fine using the GPL version under their FOSS exception.
Do you distribute at all? If no, then you are probably still fine using their GPL code. IANAL.
Do you distribute under a proprietary license? If so, you must purchase a license from MySQL AB. I think the cost is about $300. If you can't afford that, maybe you should consider giving your code away for free anyway, 'cuz no one's buying it.:)
So what you're saying is that once we've all told our kids about integrity, there will be no reason to get worked up over what somebody could do? It will be OK to leave our front doors unlocked and our keys on the dashboard, huh?
Nope, I never said that. I said that if Sarah Gadye, a teacher and parent, truly worries that her own child could break into the school's computer system then she needs to stop worrying and start parenting. Only she is in a position to instill values in her child and teach him right from wrong. We are clear that breaking into the school's computer system is considered wrong, aren't we?
You, of course, completely missed the point. Isn't that ironic?
Slashdot Mirror
If not..... <YAWN>.
You are confusing the UK with the US. It's understandable because... well, really it's not understandable. You are simply wrong. Thanks for playing, though.
Oh, that's right. Maybe because it's not allowed to tear a suspect's arms off.
Unfortunately, I lost the thumbdrive about a week ago on the way home from work.
Sorry.
He asked if pgsql was more widely-used than mysql, and I said no, it is not, and gave some reasons why. One of the many reasons that mysql is so much more prevalent than pgsql happens to be performance. Since we are talking about many many applications, not his specific applications, I can say with total comfort that in the majority of applications, my generalizations will hold. That mysql will yield better performance than pgsql. In all applications? No. In his application? Who knows? But if you are looking at popularity, you have to look at what is most commonly the case.
Most commonly, for a simple-data-model dynamic content website, mysql will beat the pants off of pgsql. I'm sorry to say it, but it is true. It is certainly not true in all cases. But it will be true in the majority of cases. Deal with it.
And yes, that is one of the many reasons why mysql is vastly more popular than pgsql. Nothing against pgsql. I'd use it if all my apps supported it (I run one app, mythtv, that will not support pgsql, and I see no reason to run two database servers when every app I run supports mysql). I'm glad it's out there and that it's available. But more often than not, it is going to be slower than mysql for simple data applications.
I see you quoted one sentence of mine. Read the next one, smart guy.
Could somebody please explain to me how blinding the driver of a moving vehicle can be considered a "non-lethal weapon"?
Good luck!
When Debian Sarge was finally released, the slashdot writeup went so far to assert that "Hell has officially frozen over!". So the sword cuts both ways.
Nice kneejerk reaction though, buddy.
- MySQL is very simple to learn
- MySQL is supported by virtually all webhosting companies, whereas you have to look pretty hard to find a host that provides PostgreSQL.
- MySQL historically has performed much better than Postgres for both reads and writes. Nowadays, MySQL only outperforms Postgres on reads. So for a website, where most database calls are SELECTs, MySQL will often (but not always) give better performance.
- Nearly all blog, forum, photo gallery, etc. packages support MySQL. They do not all support Postgres, but some do.
Now, of course, Postgres has many advantages over MySQL, but for a small hobby website, you should just use whatever you know best and your host supports and your software supports. The answer is normally MySQL for your type of website.Postgres is generally better than MySQL (though MySQL is closing the gap) in terms of SQL standards compliance and RDBMS-type features. If you're implementing a true DB app, you should definitely give PostgreSQL a second look. But for a web forum, stick with MySQL.
P.S. Did you go to Wisconsin?
If your site uses one DB or the other and is working just fine, then why would you want to rip out the DB and start over? I can't tell you how to spend your time, but if it were me, I'd spend time adding new features or promoting the site or contributing in other ways to your community. Switching DB engines is a waste of your time and effort.
If it ain't broke...
Jaif?
I don't need no stinking McAfee... I can just let the various malware programs duke it out amongst themselves.
Any intelligent Intelligent Design theorist will readily admit that evolution does happen, but only on a small scale. They acknowledge that evolution happens, but they deny that evolution fully explains how each plant and animal got to its present form.
At least that's as much as I can gather from listening to right-wing-nut talk radio. C'mon. You gotta admit it's entertaining.
Seriously, there are already good, truly-free alternatives to Oracle XE that developers already know and trust. I would not advise a client to use Oracle XE because who knows if it's going to be around in 10 years? Sure, Oracle's flagship database isn't going anywhere, but Oracle could decide that this XE product isn't generating enough revenue to justify its continued development and can it.
That's about the last thing you need. Do have a bunch of imporant data trapped in an unsupported datastore.
BTW, IAAE.
As for me, I make way the hell more than that, and I take a few months off every year. In fact, this year, I'm taking the rest of the year off because why the hell should I work November and December? I've only taken 6 weeks of vacation so far, so I think I've earned some time off. Yet I have "only" an undergraduate degree. From a state school. And not even a good one. My entire college education cost less than one year of law school. And I didn't have to kill myself studying for the bar.
By the way, I live in one of the most expensive cities in the US, and $70k is nothing. You can't rent a parking spot for $70k/yr, let alone an apartment. My points are:
Actually, I don't really see your point. If you want to work your ass off for $75k/yr, nobody's stopping you. But remember, at least in the states, you've got to go to three years of law school, which costs a ton of $US. And after you're done working your ass off in law school, you get to work your ass off for some partner in some law firm.
You know, I have to say it's kind of funny. You know when you're poor and you hear rich people say things like, "money isn't everything" and "money can't buy happiness," etc.? And you think to yourself, "That's something rich people say so poor people don't kill them." Well, I've been poor. And right now, I don't feel wealthy, but John Kerry says I'm wealthy and he really wanted to raise my taxes so I guess it must be true. Anyhow, I have to say, money isn't all it's cracked up to be. There are other infinitely more important things in life. My advice to you is to be happy with what you have. Spend time with your family. Go travel the world. That's what life's really about.
Anyhow, more money is useless if you have no time to spend it.
Good luck!
Don't forget the interest on the student loan debt. While I have significant savings, the average med school graduate has $100,000 - $200,000 worth of student loans. My money is working for me. Doctors' debt is working against them.
And let's not forget quality of life issues. I work during normal business hours. I have 3 uncles who are various types of doctors and they work crazy hours and carry a pager. In their 50's and 60's! WTF?
So being a doc is not automatically a better life and/or better earnings than being technical.
Also, regarding being a lawyer, that is a total mixed bag. The best lawyers do very well financially, there is little doubt of that. But the hours suck, and if you don't get yourself into a good firm, you're making surprisingly little money. For instance, my father in law's firm pays first year associates between $70-80k. Was it really worth going through law school/bar exam for that?
I'm an American. I vote. What else, specifically, should I be doing?
"Hi mom. I have this great new way for you to call me. First, you find me through a Jabber server. What's Jabber? It's a services-based messaging hub that can locate me wherever I happen to be. No, I'm not running from the law, I just don't sit around in the same place all day. Yes, I still have my cellphone, but ... well.. you'll see why I want you to use this new way in a moment. Then you download my openpgp key. Open my front door? No, not that kind of key. An openpgp key! Openpgp? It's a crypographically secure way for us to identify each other and can each be sure that the other is who he claims to be. Recognize each other's voices? C'mon, mom. That's so 2005. Besides, it also will encrypt our conversation so no one can intercept it. No, mom. I already told you I'm not running from the law. I'm not in trouble. Really. You raised me fine. Anyhow, once you have my openpgp key, you use a web of trust to make sure that it's really my key, because anybody could have put a key out there with my name on it and claim to be me. Would their voice sound like mine? Well, how should I know, mom? You're missing the point. If you sign someone's key who has signed someone else's key who somewhere down the chain has signed mine, you'll have some level of assurance that you're really speaking to me. Anyhow, now that you have some confidence it's me, you'll encrypt a session key with ElGamal/RSA, and before you ask, no you can't get into my house with that key either. Lastly, we open up a secure AES256 channel and then we can talk and nobody can intercept our communication. No, mom, this isn't me hinting that I don't want you to call me anymore. I always want to hear from you. That's why I set up this fancy way for use to communicate securely. No, it's not a pain in the ass once you get used to it. It's only 6 orders of magnitude more of a pain in the ass than just calling me. Yes, I am aware that the telephone was invented over 100 years ago and works fine, but there is this thing called CALEA that allows the feds to listen in on our conversations. No, I am not in trouble with the FBI. Seriously! Look, forget I even suggested it. If you want to talk, just fucking call me."
She clearly said "my child", not "child's play".
Not that I expect to just accept the fact that you are wrong and arguing for the sake of arguing. You can't even decide why you want to argue. Only that you want to argue and really really really really think that I must be wrong. First, you put words into my mouth, arguing that I think it's OK to leave our front doors unlocked and our keys on the dashboard, next you argue that I mininterpreted the meaning of the words "My own child" to mean "My own child" and that instead of "My own child" meaning "My own child", it really means "the computer is insecure".
Do you have any other really stupid things to say, or are you finished?
If you feel that you can get a better work environment including compensation package elsewhere, then you should go. Or you could try making the case to your boss that this is what you are really worth. That's what I did many years ago. My company felt that I was worth X while working a ton of unpaid overtime. I thought that I was worth 3X with no unpaid overtime. I left. Turns out I was right and they were wrong. Ain't capitalism grand?
Do you distribute under one of their approved FOSS licenses? If so, you're definitely fine using the GPL version under their FOSS exception.
Do you distribute at all? If no, then you are probably still fine using their GPL code. IANAL.
Do you distribute under a proprietary license? If so, you must purchase a license from MySQL AB. I think the cost is about $300. If you can't afford that, maybe you should consider giving your code away for free anyway, 'cuz no one's buying it. :)
You, of course, completely missed the point. Isn't that ironic?