http://www.maximumpc.com/article/maximum_i...oracle_do_mysql

Do you think it will happen? Why is Oracle trolling me? First the Java rumors and now MySQL? </3

If this were to happen, first we should probably storm Oracle HQ, then after that possibly design our own open-source database program? YEAH! Prepare for battle.

a replacement would come up, after all the source is available

It's been forked a few times so far: http://news.cnet.com/8301-13505_3-10208294-16.html

Doubtless, if MySQL became too encumbered, the open source community would ditch it for the most viable alternative. It's not like this hasn't happened before with other projects. XFree86, a core OS element, was dropped like a rock by most Linux distros in the space of months.

You do understand there is MS SQL Express, right? It's free.

http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

+1 to that! haha

@modi123_1 - I don't think that runs on linux does it? If not, definitely doesn't doesn't cover near what MySql does.

Cheers

http://www.postgresql.org/

Not to mention the numerous MySQL forks...

Half true. SQL Server Express is "free" with license restrictions. Most notably, you're limited to a single processor, 1GB of RAM, and only a 4GB database. If you need to scale beyond that, you have to pay for one of the other editions. Plus, as markhazlett9 mentioned, it only runs on Windows, which is definitely not free.

With MySQL, on the other hand, you can run it on Linux, scale as much as you want, and never have to pay a penny for the software. So there's really no comparison.

Wow.. the fanbois really did jump out didn't they.

I took the OP's comment as in what she would use and was looking for alternatives.

The other alternative to my alternative is PostgreSQL

A couple people point out limitations in your "alternative" and that makes them fanboys?

Knowles' Rule of the Internet:

A thread can not get past 10 posts without the imminent possibility of it turning into an OS debate.

Yes but only M$ posts get any real attention


On topic - There are plenty of alternatives neo, I am also pretty sure there always will be.

As far as what Oracle decides to do with MySQL, there's nothing anyone can do about. But I think it needs to be known that even if Oracle decides to trash MySQL (which I personally do not believe they will), the MySQL project as we know it will not perish.

Michael Widenius is the genius behind the MySQL project. After Sun Microsystems gobbled up the project, Michael Widenius (often referred to as Monty) did not agree with how Sun was managing the project and decided to leave the company. He has taken his 'Maria' engine, named after his daughter, and has begun working on Monty Program AB, which will pick up where it was left off.

I am a huge fan of MySQL, and personally loathe MS SQL, and therefor have been following this story for some time. Many believe Oracle will drop MySQL because it directly competes with their own products. I think Oracle is a smart company and will utilize the huge fan base of MySQL and build off of that. But again, should it go awry, I believe Monty Program AB will leave us with the MySQL we have always known and loved.

But wouldn't that screw a lot of programs and websites and stuff up? A lot of people use it. My knowledge of databases is probably skewed, but in like Java isn't there seperate packages for SQL vs. MySQL?

[/n00b]

Other than the fact that it's not free why would you loathe it? It is much more powerful than MySQL and so much more can be done with it than can be done with MySQL.

Just wondering?

I've been using MySQL for a while and I've recently started using MS SQL. Can't say about other platforms, but since I am using only Windows, I don't think that MySQL being discontinued will be a big loss for me personally, since I really like the way MS SQL works (even the Express edition).

I believe, though, that even if MySQL will be closed (as a project - there will still be people using it all over the world), that is still not likely to happen anytime soon, Oracle will most likely come up with a free edition of their RDBMS. They probably don't want to lose thousands of clients with a single click.

There's an SQL package. You can use it with different drivers for different databases.



Please don't turn this into a Microsoft vs everyone else thing. KeyboardKowboy, why do you loathe MS SQL? PsychoCoder, please explain in what ways it is more powerful than MySQL.

This post has been edited by Tom9729: 28 Oct, 2009 - 10:33 AM

When comparing MySQL to MS SQL, I believe less is more. To begin with, I find the installation much more straightforward with MySQL Server. It's as simple as choosing whether to run as a system service or not, what port to run on, the default database type (ISAM, InnoDB, etc.), and setting a root password... Done.

Since the inception of MySQL 5.0+, stored procedures and triggers are now available. I find the MySQL Administrator system much less cluttered than SQL Server Management Studio. It makes more sense, it's laid out better, and runs faster. MySQL Administrator is also accompanied by Query Browser and Workbench... all the bases are covered. Management Studio is extremely top heavy... and I find most common procedures/functions to be buried, nothing is where you would expect it to be unless you've had to dig into it before.

When developing software, I find the MySQL libraries just as full fledged as the built in Microsoft SQL libraries. I've had issues in the past with restoring MSSQL backups... never an issue with MySQL. I also find the connection strings annoying. Connecting to a MySQL database requires a simple socket connection (IP:Port). I have never been able to connect to an MSSQL database using anything other than named pipes. I've spent hours and hours digging through the windows registry and Management Studio trying to find every little place to turn TCP Connections on... still doesn't work. And what's with all that 'dbo' stuff? There's just far too much unnecessary clutter for me... although it should be expected being a Microsoft product.

I typically use MySQL Community Edition, which is the completely free MySQL product. I understand MS SQL Server Express exists, but it only utilizes 1gig of system memory versus 4gig that MySQL utilizes. MS SQL Express also limits your databases to 4gig in size... and is it just me or are MS SQL databases gigantuan in size as compared to a MySQL database (assuming similar datasets). Also, if an Enterprise system is required (Replication, etc.), I'd much rather shell out around $700 for MySQL Enterprise than upwards of $10k for MS SQL.

I guess I don't know what MySQL can't do that MS SQL can. Well, aside from giving you constant migraines, an empty wallet, and a cluttered maintenance and development life cycle. Oh, and MSSQL allows windows authentication (yippee). I guess I'll shoot the same question back to you... how is MS SQL so much more powerful than MySQL... and at what cost?!

As you can tell... I use MySQL whenever possible. I've had a better experience using, maintaining, and developing against MySQL Server.

You could list these differences. It would help a lot of people. Maybe a tutorial. =)

Hmm... I feel the need to assert my DBAness.

IMHO: MS SQL Express < MySql < MS SQL Server < Oracle

MS SQL Express is a developer's tool. It's primary advantage is the ability to behave like it's big brother in almost all respects. However, it's not meant for a production solution, by design.

MySql is comes from humble beginnings. It has excelled as a general purpose data store and back end for any number of applications. It leverages the speed of file IO and can be faster than other options for raw IO. I preferred it when it had less frills and didn't pretend to be a more enterprise solution. It's default engine is still pretty brain dead, but if your logic is in the application layer that's not an issue.

MS SQL Server is a true enterprise solution. In all but the most demanding applications it is more the adequate. It's tool set is exceptional. This is by far the easiest database to maintain, backup, and restore that I've ever worked with. The only real con is it's OScentric nature. It works best on a dedicated Windows box and will use every drop of resource given a chance.

Oracle is the really big RDBMS. It can handle massive amounts of transactions and storage, measuring in petabytes and running on mainframes. Things that would crush MS SQL. However, this level of demand is uncommon for most applications. Also, it is a venerable and horribly complex beast. You need to hire a full time employee ( like myself ) just to maintain some installations. It's also significantly more expensive than MS SQL.

It's worth noting that while MySql gets all the open source notice there are other options. This mostly because MySql was an ideal choice for the LAMP stack. However, other databases like PostgreSQL or Ingres can be more suitable as a MS SQL replacement.

SQLite. For smaller MS SQL Express style applications, SQLite is a good choice. While actually much simpler than MS SQL Express, it is ideal for a basic web application datastore. Often you see MySql used where something like SQLite would be more than enough.