asked on

Firebird Or MySQL For Windows Applications Written In C#

I was developing a small database on Firebird for an application and yesterday I was thinking if MySQL is better? I've heard it is faster, but does it provide those powerful tools like IBExpert and does it have Scripts that work as programs and can do many things with your database. Does it have easy write use triggers and stored procedures. Is it better guys tell me.

ASKER CERTIFIED SOLUTION

segurah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IncognitoMan

ASKER

Yes, but Postgre doesnt have a powerful free tool for it. All good are paid. No metter, tell me guys which is better FB, MySQL or PostreSQL or someting else thats free.

SOLUTION

twinsoft

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASta

MySQL not better or worse. MySQL is another, different, but alike in some places.

Go to MySQL.org and read docs about transactions, triggers, SP, etc.
Google: "MySQL tools", "EMS MySQL tools", "EMS MySQL Manager Lite".

You have full info about task, requirements to DBMS, and you must make choice.

I think Firebird is better, Firebird SQL more powerful (for my tasks of course). :)))

IncognitoMan

ASKER

OK twinsoft, you say "depends on what do you expect from your DBMS".
Give me information about those three according to the following criterias.
Which one has got powerful:
1. Database managing slgorythms a.k.a. better benchmark results.
2. Triggers
3. Stored procedures.
4. Using User defined functions.
5. PSQL
6. Scripts
7. External tools like synchronization, replication, cleaning, testing and so ...

SOLUTION

segurah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

segurah

FYI we uses postgresql in a 80K employees corporation.

IncognitoMan

ASKER

I now postgre is a powerful DBMS, but the tool for it are paid. Thaks for the replies Guys