Firebird Or MySQL For Windows Applications Written In C#

Posted on 2009-12-23
Last Modified: 2013-12-17
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.
Question by:IncognitoMan
    LVL 6

    Accepted Solution

    If you wish powerfull triggers, think postgresql is better, has many languages for write them.

    Author Comment

    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.
    LVL 7

    Assisted Solution

    Hi, AFIK MySQL is better for web apps, Firebird for desktop apps and PostgreSQL somewhere in between. It depends on what you expect from your DB

    1) Do you want powerful PL/SQL ?
    2) Do you want triggers (before/after) ?
    3) Do you want external functions ?
    4) Do you want Replication ?
    5) Do you want messaging ?

    For example MySQL does not have triggers executed by changes in data, but they are executed by SQL.
    MySQL has build in replication but nor FB or PostgreSQL have (build in).
    Firebird supports embedded mode. (I don't know about the other ones...)
    The one thing that i know for sure is that the BEST tool is the one that you know better and covers fully your needs...

    LVL 2

    Expert Comment

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

    Go to 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). :)))


    Author Comment

    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 ...
    LVL 6

    Assisted Solution

    LVL 6

    Expert Comment

    FYI we uses postgresql in a 80K employees corporation.

    Author Closing Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now