?
Solved

Interbase vs MySQL

Posted on 2000-02-09
3
Medium Priority
?
367 Views
Last Modified: 2010-04-04
What is the strength/weakeness of Interbase as compared to MySQL.
Where can I find any site/document/article that contains such comparison?
0
Comment
Question by:kjteng
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
simonet earned 200 total points
ID: 2507148
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
 
LVL 2

Author Comment

by:kjteng
ID: 2548807
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
 
LVL 15

Expert Comment

by:simonet
ID: 2552472
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses
Course of the Month4 days, 22 hours left to enroll

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question