MySQL
- Thread starter mattseh
- Start date
arty-smiley-004:
This is all really interesting stuff to me, but it's problematic since I only understand about 15 percent of it.
That would be one person's opinion...
mySQL is the most widely used database engine in the world for a reason, and it's not because it's a piece of shit.
mySQL is the most widely used database engine in the world for a reason, and it's not because it's a piece of shit.
You are right, it is more like a shit smear, or maybe a diarhea splatter that has gotten itself all over everything, and no one cleaned it up in time and let it sink in for way too long, so now everything is covered in nasty MySQL shit stains even though better database engines have been developed.
[ame]http://www.youtube.com/watch?v=8geLnpGmQAQ[/ame]
Which db engines, and why? None of the newer ones have had enough time to prove themselves yet, hence why you don't see mass adoption.
Unless you are going over 100k-150k hits a day (and that is being really conservative), SQLite is better by quite a bit in my opinion. Most people using MySQL are just being dumb and fucking silly, like they are using dynamite when all they need is a little hammer.
It is simple, fast and proven, but passed over by people who would be better off using it because they are blinded by hope, thinking they are going to be the next google or facebook or some silly shit...
Plus it is 'murican.
It was originally developed for missile defence systems or something like that, hard to get much more mission critical than stopping an ICBM.
MySQL is swedish communist crap.
If you actually do need a big, heavy duty database engine, postgre is just plain better.
MySQL is like a v6 mustang or a porsche boxter or something. People who can actually drive a real sportscar don't buy them because they suck, people who should be buying a fucking camry do buy them because they like to feel special.
Of course, had postgresql picked a more catchy name, and was more novice friendly, it would be a moot point....they would have eclipsed mysql years ago.
Even ignoring Postgres vs MySQL why would anyone use MySQL when they could be using MariaDB instead?
Yeah, I can see your point. If you're just doing small apps, and not taking advantage of what mySQL offers, then yeah, SQLite is probably a better choice. If you're doing anything of decent size though, you can't use SQLite, as it doesn't contain anywhere close to the feature set mySQL offers.
Tried PostgreSQL years ago, and it seemed fine, but ever since mySQL v5 came out with triggers, views, etc... in my mind, that closed the gap between the two. Plus mySQL is much more widely supported, so if you're doing distributables, mySQL is a good choice.
Or I don't know, I haven't checked for years... what does PostgreSQL have that mySQL doesn't?
True, but tell that to customers who purchase a $300 software package from you, and are hoping to install it on their $9.95/month hosting plan.
Or if you want to open-source, and distribute something to the masses on Github.
strange how it's always the super popular languages/dbs that get shitted on and are suddenly shit. like how people don't like bands anymore when they get too popular.
though i do like postgresql, i just always stick to mysql as i prefer phpmyadmin to phppgadmin. agree with one point in that article, it was a pain in the balls getting emoji working in a recent mysql install
though i do like postgresql, i just always stick to mysql as i prefer phpmyadmin to phppgadmin. agree with one point in that article, it was a pain in the balls getting emoji working in a recent mysql install