Replying to What Are The Alternatives To MySQL

@Cinnamon: I'm quite curious what you mean by "more than MySQL can handle". As far as I know, MySQL is a powerfull database which is used in many production environments with extremely high loads and huge datasets. I'm quite sure that the performance bottleneck will be on the hardware side and not on the software side (except when you fail to define indexes and stuff like that ). I can guarantee that even a simple query takes a few seconds on a production DB2 server if you're searching inside a table with +100.000.000 entries

If you have non-relational data to store you also might look into NoSQL databases like MongoDB.

i have never worked with any other database, just MySql ... sufficient for my use

By the way, do not forget Oracle as a valuable alternative.
It's free for learning purposes, and for business purposes your boss will have to choose between a great professional database and a free one.

This summer I developed a database application for work as a student, I proposed to the IT department of the organization to use MySQL as I had no experience with MS SQL (SQL Server). I think both options are good, not sure about Oracle though. PostgreSQL also seems like a great system but I've never really used it.

Another option for smaller databases would be SQLite as mentioned above somewhere. It's used in many desktop applications like Firefox and Skype.

IIS Sql Server would be a pricer alternative

H2 and HyperSQL are two great alternatives too, tough they are more used by Java developers for doing in-memory database testing (like me ).
They both say they should fare well in production and performance should be good too. If you'll have a high load on your site I'd stay with MySQL.

Another one is Derby, but I'd stay away from that one because it's quite lacking in performance (it's about 4x slower than MySQL).

Well i use flat file its unsure but i change the name with .php and add a password so now its totaly secure,(password with md5) .
you can try it also.
can add json also..(i dont know a lot about json cant help with it you, just usued for first time.)

Yes. Oracle and sybase have commercial db and they have a quite popular userbase. Not to forget like mysql, oracle has more web searches on the web. I have also seen lot of error codes documented quite a lot by users and some suppor forums.


The thing about oracle is that it is quite popular among java developers. I dont see many php developers using it and for them mysql and postgres are often the choice. In case of asp developers ms sql server is the choice.


My personal opinion is postgres. It is available with most of the webhosts. I have hosting with another company that uses postgres. I didnt find much difference with wordpress or other scripts. So postgres suggestion from me.

By the way, do not forget Oracle as a valuable alternative.
It's free for learning purposes, and for business purposes your boss will have to choose between a great professional database and a free one.

Webdna looks like different thing in itself. I am not sure how many people will adopt it as an sql alternative. Besides it is not yet used in any popular online project. If there are any then i dont mind trying it in that case.


Postgre sql and ms sql server are two alternatives to mysql. Postgre sql is free but ms sql has feature limited version version. So for php based projects i think postgres is enough for most of the needs.


I used postgres and sqlite and i found them fair alternatives to mysql. Syntax and learning curve is not that steep. So worth trying and they are free.

You could try WebDNA: it is a great alternative to php+MySQL: faster, lighter and fun to use

Olivier

Seems great. However, the syntax is very special, seems far-away from any other SQL database language.