MySQL is aiming for speedier development cycles than most database companies. The company is currently focusing on two products: MySQL versions 4.1 and 5.0. It released the binaries of 4.1 this week and plans to unveil a final version in about eight months. A final version 5.0 should be available about six months after that. Read the report at News.com.
MySQL Boasts Might Against Big Players
About The Author
Eugenia Loli
Ex-programmer, ex-editor in chief at OSNews.com, now a visual artist/filmmaker.
Follow me on Twitter @EugeniaLoli
39 Comments
of course it doesnt have the same features, oracle costs hundreds of thousands of dollars to deploy, it should have more features!
sapdb is not too far behind it though, and you can’t beat the $0 cost to deploy either.
mysql, postgres… are light years behind oracle and sapdb in terms of functionality.
well, like most things, use the best tool for the job, and if it for simple non-critical data use mysql for it’s speed.
otherwise, for the bigger and badder stuff, use sapdb. unless you have thousands of dollars for oracle or db2.
in reply to the other post about firebird… it is still beta, although it is based on interbase, i would not deploy a beta RDBMS on an enterprise system.
and as for the oracle documentation, oracle is very complicated, and takes years to become a pro at it. have you seen all those damn books that it comes with!?!?! just to create a simple database takes a long time to implement!
>I think the word everyone is looking for is ACID. Which MySQL does not have!
Actually the newest stable mysql version (4.1) does.
PostgreSQL should work on becoming more user-friendly and also improve their documentation. MySQL is super easy to install, use the installer or load the RPM’s, slap on something like phpMyAdmin if you want, for a frontend, and start feeding in data.
When a newbie has installed postgres they will run “psql” and expect it to work automagically, mysql doesn’t even prompt you for a password anymore. Frustration ensues, there’s permissions that must be set up, tcp connections aren’t enabled by default, the database must be bootstrapped (while logged in as the postgres user, a little detail that is buried somewhere in the Administrators Guide). In the end a fraction of users will succeeded and stay with postgres, remember, “rpm -e postgres”, “rpm -Uvh mysql*” takes exactly 2 minutes. At least automatic vacuuming is being added soon, to MySQL users the whole idea that you have to do maintenance is a totally foreign concept.
I really like postgres and use it myself, but people who claim it is as easy as MySQL haven’t watched new users try to get it up and running.
I use MySQL because … well … it was there. And I really liked how it worked. The only other DB I’ve ever used is Microsoft Access, so, can you blame me?
A few posts ago, someone compared the cost of “deployment” of SapDB to Oracle. “Deployment” isn’t just purchasing the software, it’s a whole plethora of issues that sometimes can take many man-hours to sort out. And if sapdb breaks, how big is the support base?
I like MySQL because of its close affiliation with PHP (I don’t do complex databases at the moment, only dynamic web site style databases), ease of installation (“make install clean” on FreeBSD; of course, PostgreSQL probably is exactly the same), and ease of comprehension. It’s just SQL, pure and simple. Having never used PostgreSQL, I can’t say the other way – I’m sure it’s very similar in that respect – but MySQL (combined with phpMyAdmin) has always met my requirements.
One day I’ll take a look at PostgreSQL. Anyone know how much work it is to move MySQL PHP code to PostgreSQL PHP code? (in particular, mysql_fetch_object() … oh, how I love that function)
“A few posts ago, someone compared the cost of “deployment” of SapDB to Oracle. “Deployment” isn’t just purchasing the software, it’s a whole plethora of issues that sometimes can take many man-hours to sort out. And if sapdb breaks, how big is the support base? ”
maybe i used the wrong word, i know that deployment is a lot of factors, but regardless sapdb costs less to deploy.
as for support, you can get it directly from sap. as with oracle.
Although the site does not say it, I can activate postgresSQL on my server. $10/mo
Blueartmedia.com
OK, let’s just take apart that troll attempt by ‘all your linux’:
>> this may be true but sapDB certainly has way more features than postgreSQL and MySQL combined. Postgres and Mysql do not support database views, at the point where each user can have their own database, like oracle (of course you can get around this by appending the user_name to every table that belongs to a user, but having your own, secure set of tables is a much sexier solution =) ).
As of version 7.3, PostgreSQL does indeed support ‘database views’, or SCHEMA, as some of us like to call it.
>> and if you like phpmyadmin for mysql and postgres, sapdb comes with it’s own web-based administration tool that is top notch. sapdb also has NO LIMIT to table size, database size, etc… not like mysql, postgresql and MS SQL!!! and performance dramatically decrease with very large databases such like those DB’s i just mentioned.
PostgreSQL has not had a limit to table and DB size for years. It is especially not at all limited by the filesystem, even on standard Linux/x86 installs with 2GB max file size.
>>but for business applications, web-portals, and mission critical applications, sapdb is definetly the most promising rdbms. so if you want to build an enterprise able database, and do not have tons of money to spit out for oracle, go with sapdb. if you need support, sap does offer some solutions.
Not knocking SAPDB at all, but there are plenty of large companies with very large databases in PostgreSQL, such as BASF.
As far as I can tell, from reading the documentation, SAPDB has precisely two features that PostgreSQL does not have: 1) built-in replication/clustering, and 2) nested transactions. PostgreSQL will probably have both of those by the next release, 7.4.
Meanwhile, there are quite a few features that PostgreSQL has which you won’t find in SAPDB, such as a richer set of datatypes, user-defined types and operators, multiple procedural languages, and my favorite feature, the RULE system, which among other things allows for great flexibility in view updates.
i did in fact try postgresql before i used sapdb, but at that time two years ago postgres did not have the capabilities that i required for my system.
database schemas was one of them. i am not surprised that enterprise systems deploy postgres, i am glad they do. sapdb had the capabilities i needed, thus i chose that solution. i do miss the rule system sometimes, but the schemas make up for that.
however, it is correct that sapdb is not as widely used, you will probably have an easier time with postgres and mysql due to community exposure. most people don’t even know that sapdb is an open source db. that is where the problem lies.
my developers had a high learning curve with sap, but we are glad we went this direction, for porting to oracle in the future would not be so difficult moving from sapdb (if necessary).
postgresql is indeed a powerful database, more powerful than mysql in my opinion, but does take longer to set up than mysql. and sapdb longer than postgres, then oracle which takes a long long time.
>>…then oracle which takes a long long time.
lol… I finally managed to get Oracle installed on my cheap Linux box, after downloading and burning 3 whole CDs worth of Oracle 9i. Why do they make you do that just to use a DBMS?
After PostgreSQL, I can’t imagine the headache of dealing with Oracle. Ironically, I have found that a straightforward install _from source_ is the quickest way to get PostgreSQL up and running, and it literally only involves reading about 5 or 6 lines of documentation. The problem with PostgreSQL installs for most Linux users is that the RedHat RPM tries to set up Postgres in such a non-standard way that people get all messed up when they try to configure it.
The thing that soured me on MySQL is not MySQL, but its developers. MySQL is fine FOR WHAT IT IS, but the developers keep on touting it as if they have a legitimate comparison to Oracle or DB2, when that is far from the truth. They have turned out to be some of the best self-promoters in the open source world.
I was interested in SAPDB for awhile, but I was a little disappointed by some of its limitations, such as the 8K row size (without BLOBs) and the max SQL statement length (16K, compared to PostgreSQL’s 1 MB), and the 32 char max length of tablenames, etc…
you are right, mysql developers do seem to have this notion for mysql being on par or a direct competitor with oracle. they have been like that for as long as i remember.
i know mysql isn’t on par with oracle, so that is all that matters to me, regardless of what those developers say.
btw 32 character table names is plenty… i would hate to type 32 character table names in a select statement!
and for the 8k and 16k thing, when i was using postgres b4 it had worse limitations than that i think they took care of it though in version 7.3, but it was too late to turn back at that point.
Hi,
One final clarification and we will have officially beat this horse to death ;-): PostgreSQL hasn’t had an 8K row limit for years. I believe since version 7.0 first hit the mirrors.
Anyway, it’s good to know that there are decent open-source DBMSs out there. Even Firebird, while more limited than SAPDB and PostgreSQL in some ways, is still a fairly good choice.
MySQL, well… let’s see where they go with all this. For years they have been nay-saying the need for any real integrity constraints. But, since they also claim they eventually want to implement all standard SQL DBMS features, it just seems to beg the question…
Anyway, SQL itself is flawed, according to the most serious relational data theory thinkers (www.thethirdmanifesto.com, http://www.dbdebunk.com). By the time MySQL is fully ANSI SQL compliant, I would hope the world will have moved to a better standard. (not holding my breath, though)
…in this software business. I have seen this video a thousand times and counting.
Nonetheless, go MySQL ! 🙂
MySQL may or may not ever be capable of going toe to toe with Oracle and DB2, but there’s quite a bit of marketspace in between that it could own quite handily. Like the article mentions, using Oracle to drive a small database is like using a nuke to swat a mosquito.
-Erwos
What does MySQL have over Postgres, except perhaps speed?
What Postgres has that MySQL does not (afaik):
# stored procedures
# stored procedures in different languages
# ability to create different languages
# inheritance
# speed with transactions (more mature transaction implementation)
# ability to survive larger number of connections
# wealth of data types
# views
# Triggers
# Rules
# Subselects in target lists
# NUMERIC type of arbitraty precision
# PL/pgSQL, PL/Tcl, PL/Perl, PL/Pythin
# Multiversioning
# User-definited data types, operators, and functions
# Write-ahead logging
# Partial indexes
# Functional indexes
# Rollbackable DDL (CREATE/DROP TABLE, etc.)
# Absolutely 100% free
# Referential integrity
*What does MySQL have over Postgres, except perhaps speed?
Availability? Momentum? A future?
All web hosting companies these days offer mysql. Its become a standard. And because its a standard, many more developers will learn and use it. And because of that mysql will be the choice of future programmers because they know it probably has the best chance of staying around longer.
>All web hosting companies these days offer mysql. Its become a standard.
Windows is also a standard. Yet, readers of this site try to sell us Linux.
In the same fashion, while mySQL is INDEED way more popular than PostgreSQL, doesn’t make mySQL a better product.
sapdb is as powerful as oracle. and it’s free.
enough said
MySQL has:
– an easy installer for windows;
– larger user (support) base;
– tie to php;
– more support from programming languages and book authors;
– a cool name;
Cant be beaten. Remember that MySQL is often used where one comercial DB could be used (NASA, Yahoo, etc). Those extra features that you list for PostgreSQL certainly arent so important to the people that use MySQL .
Even though those features when implemented by MySQL will attract even more users 🙂
Cheers
>> All web hosting companies these
>> days offer mysql. Its become a standard.
I wouldn’t go so far, because, believe it or not, more hosting clients use Access than use mysql.
But yeah, mySQL is good on the middle range. The license for SQL server is so expensive that many hosting companies don’t want to bother with it -unless they pirate it. What MS has done to oracle in the db market (drive prices down), mySQL will do all of them.
There is no comparison.. none whatsoever… MySQL is NOWHERE near where postgresql is… MySQL is an easy product that lets people who don’t even know what an ERD or a view is create a ‘database’.. which is why it’s popular..
it’s so inferior it isn’t even funny.
They mention that the number of people downloading mysql for windows compared to linux is 4 to 1. Are they including all of the people who download linux distributions with MySQL as part of the package? If they dont, then they did not count the 8 times I have downloaded MySQL this year for/with linux as opposed to the 1 time I downloaded it for windows.
I know (and like) ERDs and views, but I use MySQL. I guess it is probably because that is what my host has offered me. Does postgres have pretty much the features that SQL Server 2000 has?
That was a nice link I didn’t know SAP released a free database (but then again I’ve only been a user on SAP systems). OTOH reading the site it ain’t even close to Oracle. The types of features they are bragging about are features that aren’t even in the ballpark of cutting edge for Oracle. For example the configuration file for SAPdb has something like 30 options; the one for Oracle has 30 catagories of options (with dozens of options per catagory).
For all Oracle’s vaunted complexity, I’ve found it much harder to get started with Sapdb. It may just be the paucity of written documentation. I’ve not found anything really good on the web, and SAP’s documentation seems terribly badly organized. Additionally, the ONE third-party book on sapdb a) hasn’t yet been published and b) is written in German.
I’m probably going to give sapdb another shot — the price is right, it *looks* like it has a really good feature set, and it would make an attractive bullet point on the resume. But postgres is looking pretty attractive at the moment…
Yours truly,
Jeffrey Boulier
Too bad, I wish PostgreSQL was more widely available. All the cheap webhosts only offer mySQL support which is understandable of course but still. mySQL is good when you want to hack together a quick and dirty page with some database support. It’s fast for simple things and thats great but for a real, professional application it doesn’t even close to the required features.
Stored procedures. All database logic should be on the database, Faster, less traffic, more secure, and updates are dead simple. Distribute the new sprocs to your client and you dont even have to restart the application.
Triggers. Yeah they’re a bitch to debug but sometimes they’re irreplaceable. If another app modifies your data you MUST ensure that your data integrity will not be compromised. This is the way to do it.
Foreign keys. Btw I thought you could already do this in earlier mySQL versions. Anyway, also invaluable. Cascading deletes, updates, and more data integrity insurance.
Anyone know of a good, cheap postgreSQL host?
that postgresql doesn’t
– speed/performance (dun try to explain to me how to tune postgresql, i spent lots of time with both, mysql beats postgresql hands down, especially when it comes to inserts)
– embedded db (when u run an appliance, it’s 1 less factor to worry bout when u dun have to run a db server process)
– easy of use (installation/configuration/maintenance, all easier than postgresql)
granted, there are alot of features (as one reader mentioned above) that postgresql has over mysql, and they are very valid. so, choose the best tool for ur job…for me, mysql it is
It is easy to use for me. It just like Windows and Linux, many that wrote/say bad thing about Windows and praise Linux but the reality is that Windows just works and let it’s user to do their works.
The same goes to MySQL compare to others like PostgreSQL, MySQL just works and let me and other user do our works. So why do we need to switch to the other databases?
Read here for the short version: http://brainscraps.com/faq/pg_my.html
Is you really want to know what the diffrences are between
PostgresSQL and MySQL read these pages…
http://www.geocities.com/mailsoftware42/db/dbs.html
http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html
http://www.phpbuilder.com/columns/tim20000705.php3?page=2
http://www.phpbuilder.com/columns/tim20000705-res.php3
I prefer PostgresSQL but i do agree with some posters MySQL is extremly fast but as you will read in above linked pages, PostgresSQL can outpreform MySQL on certain terrain like
scaling and connections.
I think each product has it’s place. For a quick and cheap website you use MySQL, if you have lot of data use Postgresql. If you have tables with +2 millions of records (like we do) play safe and use Oracle.
“The types of features they are bragging about are features that aren’t even in the ballpark of cutting edge for Oracle”
this may be true but sapDB certainly has way more features than postgreSQL and MySQL combined. Postgres and Mysql do not support database views, at the point where each user can have their own database, like oracle (of course you can get around this by appending the user_name to every table that belongs to a user, but having your own, secure set of tables is a much sexier solution =) ).
Good thing about sapdb is that it does not take as long to set up as oracle, yah you dont have the billion configuration options like oracle, but it has enough to make a secure mission critical database. actually i did find their online documentation pretty thorough and have managed to get many things done with it. it would be nice to see more documentation though, you can never have enough. I use sapdb with PHP and apache, and it runs great.
and if you like phpmyadmin for mysql and postgres, sapdb comes with it’s own web-based administration tool that is top notch. sapdb also has NO LIMIT to table size, database size, etc… not like mysql, postgresql and MS SQL!!! and performance dramatically decrease with very large databases such like those DB’s i just mentioned.
it certainly would be nice if sapdb was more widely used and developed/integrated with other applications, but i think the power os sapdb may be overkill for more common database applications such as web forums, and guestbooks.
but for business applications, web-portals, and mission critical applications, sapdb is definetly the most promising rdbms. so if you want to build an enterprise able database, and do not have tons of money to spit out for oracle, go with sapdb. if you need support, sap does offer some solutions.
don’t get me wrong, i have tried mysql, then switched to postgresql (more features, more mature), but none of these had the power i needed. i could not afford db2, and refused to use MS SQL (i have linux servers). my friend told me sapdb released their DB to the public a few years ago, and i never turned back.
“and performance dramatically decrease with very large databases such like those DB’s i just mentioned. ”
i meant :
and performance DOES NOT dramatically decrease with very large databases such like those DB’s i just mentioned.
I think better is Interbase and it’s clones… as Firebird or Yaffil.
Firebird is multiplatform- for Windows, Linux, FreeBSD…
I think the word everyone is looking for is ACID. Which MySQL does not have!
Nothing can be consider a database unless you are ACID compliant PERIOD!
Now the fact that what most people do on the web with MySQL could just as easily be accomplished with Flat Files is a whole different story.
The ONLY reason why MySQL has received so much attention is because the average WEB, and let me clearify WEB developer only need a minimualistic way of storing data.
I’ve read Google runs MySQL too.
http://techupdate.zdnet.co.uk/story/0,,t492-s2120389-p2,00.html
“I was just at Google, and Google’s an all-MySQL shop. Why did they do it? Because they looked at DB2 and it was expensive and it didn’t offer any added value.”
I always wondered why MySQL is mentioned so many times more than PostgreSQL and SAPDb. Maybe a lot of people like it’s simplicity.
Hate to say it but, judging by the 4:1 ratio of downloads, MySql owes it’s success to Windows. Personally, I prefer PostgreSQL, how can people live without views, foreign keys and stored procedures? They’re basic necessities in RDBMS and without them maintaining a medium sized database is a pain.
PostgreSQL really loses out because it’s a PIG to install on Windows, you have to install cygwin then a load of common utils then blah blah blah. Five hours later it just might work so on Windows my recommendation is always MsSql.
Though if you’ve got a machine handy you can dump Linux on the Post is the only way for me.
Though where MySql could really win this fight, esp against M$, is by releasing a desktop version in replacement to Access. Access is utter crap when coming to doing anything more powerful than Insterts, updates and deletes, MySql in a self contained file would be awesome!
It’s a little old, so it may now be incorrect in places, but it provides good insight to why many people do not like MySQL.
http://openacs.org/philosophy/why-not-mysql
It sounds like both of you agree that sapdb doesn’t have the same features. As for Oracle documentation it is not very good but there is lots of it and its cross referenced. A good way to get started is the DBA handbook. http://www.amazon.com/exec/obidos/tg/detail/-/0072193743/qid=105007…
As for documentation on the web Oracle has a documentation CD (and yes it is full) and its free. I’d start with database concepts. No questions Oracle is a professional tool intended for DBAs and not people who set up a database quickly in the midst of something else.
Anyway take a look at http://otn.oracle.com/pls/db92/db92.homepage (may require registration to view I’m not sure).
It’s a little old, so it may now be incorrect in places, but it provides good insight to why many people do not like MySQL.