Firebird

[Hubert Brandel]

>I use Perfect Syncs SQLTools and ODBC on my MySQL Database
...
I did a quick 'Google' for him and found http://www.mysql.com/products/connector/odbc/ and sent the link to the guy.
Is this what you are using? It would be nice to know that it really 'works as advertised.'
MCM

Hi,

I think so (I am not at home at the moment), I loaded this maybe 1 year ago.
I think I am on 3.x ... I had no problems with it, but I use it without huge data transfer and not realy heavy workload on my small webserver - just for fun.

3 Years ago I had a discussion with a gui who did not want MySQL für his software buisiness - he prefered PostGreSQL.

1. MySQL is totaly free for a Web-Server. Even a company can use it for themself for free, BUT if you want to sell your app which uses a MySQL database, your coustomer have to get the database by himself.

2. HE said, that MySQL performs verywell on a WebServer ... > 95% reads, but will not work so good for a normal applicaton (70% reads 30 % updates) - I can't say if this is true !

3. He told me, that "stored procedures" and other "special features" are missing or not so powerfull in MySQL, but very good in PostGreSQL - and he has got a self written wrapperclass for direct connections to PostGreSQL.

I am not able to decide whats true or not, all what I tested worked, but I only have 4 PC to stress the database

[Vincent van der Leun]

I did a quick 'Google' for him and found http://www.mysql.com/products/connector/odbc/ and sent the link to the guy.

Is this what you are using? It would be nice to know that it really 'works as advertised.'

Hi,

My experience with MySQL's ODBC connector (I believe we used 3.51) is quite good. I only tried it in a huge Visual Basic 6 project of a past employer, but I believe we didn't have too many problems (I believe the problems that we encountered were usually probably not directly related to the driver itself).

Of course the SQL syntax and available functions are probably different to the database management systems you already know, so that could be an issue if you use complex SQL-queries in your software.

We had some minor problems with case sensitivity, the Windows version of MySQL (the platform that we used while developing the software) did not care about capitalization of tablenames and fieldnames, while the Linux version of MySQL (used by our client) DID care... That took a little while to find out. Of course, we should have spelled the fields and tablenames correctly in our queries from the start anyway. Again, this is not the fault of the driver, it's just an implementation difference between MySQL Win and Linux and one that's fully documentated.

Now to ontopic mode:
I will definitely plan to test Firebird and am grateful to José for the headers. I will post about my experience here.

[José Roca]

For those interested, I have posted a translation of the Firebird headers in my forum.

http://www.jose.it-berater.org/smfforum/index.php?topic=2896.0

take a look at this info of Michael Widenius the Founder and original developer of MySQL

http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

maybe one shouldn't use mysql

[Michael Mattias]

>I use Perfect Syncs SQLTools and ODBC on my MySQL Database

Last week a prospect asked me about using MySql with The Provider Payment Partner(tm) System . PPPS requires an ODBC interface, and I told him if he can find an ODBC driver for MySQL, no reason it should NOT work.


I did a quick 'Google' for him and found http://www.mysql.com/products/connector/odbc/ and sent the link to the guy.

Is this what you are using? It would be nice to know that it really 'works as advertised.'

MCM

hi,
it is too bad that there is no translation of the firebird (.h) header file. sqllite is nice and limited, but with firebird one would have a real database that is embeddable too. odbc is ok if one ports code to other OS'es, but that is not possible with PB. maybe some knowledgible person will do it one day and i am looking forward to that, since firebird is getting more widely used by companies.

my 2 cents

hans

[Hubert Brandel]

Hi,

I have had a quick look on it (as for PostGreSQL as well).
I use Perfect Syncs SQLTools and ODBC on my MySQL Database.

I will stay with MySQL, but SQLTools will work with Firebird and PostGreSQL too.
I did not found any native DLL, maybe there is some code for C/C++ or Delphi to translate, but I prefere ODBC because the easy way of changing the database.
Of course I do not have huge databases.

[Rick Kelly]

Has anybody looked at or deployed Firebird as their SQL server?

If so, what resources are there on using Firebird with PB?