Interbase vs MySQL

What is the strength/weakeness of Interbase as compared to MySQL.
Where can I find any site/document/article that contains such comparison?
LVL 2
kjtengAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

simonetCommented:
There are many differences between them.

- Interbase is a relational database. That means, among other stuff, you can create relationship between columns, and the like. IB supports this very well. OTOH, MySQL doesn't support referential integrity.

- MySQL supports a much higher volume of data than and more transactions per second than IB. On a corporative level, I'd go for MySQL (if I could only choose between the 2, because an even better choice would be Oracle).

- IB has a large, well-known and stablished company behind it, from which you can get support if you need. Although there are lots of newsgroups from which you can get support for MySQL, we both know it's not the same thing.

- IB is easier to administer.

- When Delphi development is concerned, there are great components that let you access IB (like IBExpress, that comes with D5). I believe (I have heard about) similar stuff for MySQL, but have never seen it.

- Although both can run on Linux, MySQL is better optimized for Linux, because that's the platform where it was born and where most of it's development is being focused.

As you can see, there are shortcomings for both of them as well as there are advantages. My last suggestion is to go to MySQL's site and read a chart they have comparing all the big players in the DBMS area to MySQL. Although the results are kinda "oriented", you can have a pretty good idea to which one is best for you.

There's no absolute answer "this one is better". It all depends on your needs. If you don't care about using ODBC and will not be using referential integrity, then MySQL is the one for you.

Yours,

Alex
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kjtengAuthor Commented:
Looks like no other experts has experience in using MySql with Delphi.
I am going to accept you comment as answer as it is very informative. Thanks.


p/s There are some 'MySql dataaware' components (freeware) eg TMySql.
0
simonetCommented:
I have heard of them, but I don't actually know or use any of them. I've used MySQL through ODBC, which was pretty slow compared to IBExpress.

I belive you may find some info about it in MySQL's site.

Alex
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.