Interbase vs. mysql
Terry
application to a client server app. The data base currently has 31
tables using master-detail relationships, referential integrity and
lookup tables. It is currently 14.4 MB is size. Interbase was
recommended as a possibilty, also mysql. I am looking for comments of
the pros and cons of either database from those with experience using
them. I will be using Delphi 6 to do the development.
Thank you for the input.
Justmade
interbase will be a better way to go.
It is not that interbase is generally better then MySQL (MySQL has much more
user base then Interbase) but the fact that Interbase is Borland product and
all Delphi components and driver support interbase much better then other
DBMS, which MySQL get the worst support among them.
The MySQL dbExpress driver is full of bugs and Borland had do little, if not
none, on these for the past 2 years. There is a great push for upgrading
MySQL driver recently by several MySQL user including myself.
If you will consider using other language (such as PHP) to access your DBMS,
MySQL is still worth consideration and please join accompany us to ask for a
better MySQL driver.
By the way, in addition to the better support, interbase has more
functionality then MySQL and is a quite good DBMS itself.
"Terry" <coo...@woh.rr.com> wrote in message
news:3E733C31...@woh.rr.com...
Ross Davis
Interbase is more robust and if you need stored procedures, view and
triggers you need Interbase. Judging from what you are converting from, I
don't really think you do.
The other thing to consider is the deployment costs. Is this an inhouse
application or will it be deployed? If it will be deployed in an opensource
environment then you could use the Interbase 6.0 that is opensource or mysql
and not have to have any deployment costs.
If you want to use the Interbase 7 then you should take a look at the
delployment costs. They are substantial. If this is an issue for you, you
might want to look at mysql again and consider purchasing the crlabs driver.
It is not that much money and a hell of a lot cheeper that Interbase
licenses.
Ross
"Justmade" <pete...@jaunlet.com.hk> wrote in message
news:3e73...@newsgroups.borland.com...
Bill Todd
choose the best database for your application that you might find
helpful.
If you consider MySQL check look closely to see that it has the
features you need. I am not a MySQL user so the following may be out
of date. I am sure someone will correct me if I am wrong. MySQL is
just now adding transaction support. I believe it is in late beta.
There is no declarative RI so you will have to code that. There are no
stored procedures and triggers. IIRC the SQL dialect does not support
joins. MySQL is reputed to be extremely fast at SELECTs and quite slow
at INSERTs and UPDATEs.
InterBase is a more full featured database with multiple transaction
isolation levels, stored procedures, triggers, declarative RI and
performance monitoring tools.
Converting a Paradox application to a SQL database server will involve
some code and architectural changes. You can get an overview of the
issues involved in the paper at
http://bdn.borland.com/article/0,1410,29106,00.html .
Another alternative is Advantage Database Server. It does not have all
of the features that InterBase has but it does support Paradox style
navigational architecture so the conversion of a Paradox app is much
easier.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
Ross Davis
> just now adding transaction support. I believe it is in late beta.
Version 3.23 has had full transaction support for more than a year( Long
before the release of d7). It not only supports transactions on a single
database, but across databases as well. Version 4.0 is passed Beta and now
is in maintenance mode.
> There is no declarative RI so you will have to code that. There are no
> stored procedures and triggers. IIRC the SQL dialect does not support
> joins. MySQL is reputed to be extremely fast at SELECTs and quite slow
> at INSERTs and UPDATEs.
The only join that is missing is a right join. On my laptop I can insert
1500 items per second using the corelab driver(Can't use borland driver it
crashes under heavy load and gives invalid username/password errors). I
have seen over 2500/second inserted on my other servers. That is not
exactly slow.
Thomas Miller
an open source database, based on the code of IB6. It
is really a good database and version 1.5 is in beta and
has features that D7 doesn't have. The driver from Upscene
is first rate, even better then the Borland IB DBX driver.
--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus
Nick Hodges (TeamB)
<bi...@notthis.dbginc.com> wrote:
>There are no
>stored procedures and triggers.
Yikes, I didn't realize that.
Nick Hodges - TeamB
Lemanix Corporation
Please always follow the newsgroup guidelines --
http://www.borland.com/newsgroups
Kyle Cordes
news:unn67v4iafiet7om2...@4ax.com...
> If you consider MySQL check look closely to see that it has the
> features you need. I am not a MySQL user so the following may be out
> of date. I am sure someone will correct me if I am wrong. MySQL is
MySQL is certainly a product that people widely "love to hate" :-)
> just now adding transaction support. I believe it is in late beta.
It's been in production for a while now, actually. This was by far the
largest problem with MySQL for serious work, but it's been taken case of
thoroughly.
> There is no declarative RI so you will have to code that.
I don't know if this has been added yet.
> There are no
> stored procedures and triggers.
I believe this is still correct.
> IIRC the SQL dialect does not support
> joins.
MySQL most certainly supports joins. It wouldn't really be very useful
otherwise.
> MySQL is reputed to be extremely fast at SELECTs and quite slow
> at INSERTs and UPDATEs.
In the apps that I worked on in MySQL (some time back), these operations
were quite fast also. There was an issue then with how it handled locking
(rather poorly) that made it very ill-suited for Inserting in to a DB that
very busy with a lot of select activity. That's all been well addressed
since then.
--
[ Kyle Cordes * ky...@kylecordes.com * http://kylecordes.com ]
[ Consulting, Training, and Software development tips and ]
[ techniques: Java, Delphi, ASTA, BDE Alternatives Guide, ]
[ JB Open Tools, EJB, Web applications, methodologies, etc. ]
Marian Munteanu
Craig Stuntz [TeamB]
> If you want to use the Interbase 7 then you should take a look at the
> delployment costs. They are substantial.
"Substantial" relative to free, cheap compared to, say, Oracle. So it
depends upon your frame of reference. Here's a more quantative answer:
http://delphi.weblogs.com/stories/storyReader$236
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Terry
is a server ( windows 2000 server ) and 2-3 workstations running
windows. What would I need from you referenced list to make work?
Dave Nottage (TeamB)
> Can you explain to me the 'free' part.
MySQL is free. Interbase licensing costs are "substantial" relative to MySQL
costs, however they're cheap compared to Oracle.
--
Dave Nottage (TeamB)
Richard Gilbert
6.? and seems to be very solid. I can't tell the difference between it
and the same version of the paid version of Interbase.
Craig Stuntz [TeamB]
> "Terry" wrote:
> > Can you explain to me the 'free' part.
>
> MySQL is free.
Sometimes.
Check the license.