• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 908
  • Last Modified:

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.
0
IncognitoMan
Asked:
IncognitoMan
3 Solutions
 
segurahCommented:
If you wish powerfull triggers, think postgresql is better, has many languages for write them.
0
 
IncognitoManAuthor Commented:
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.
0
 
twinsoftCommented:
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...

Chears...
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
AStaCommented:
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). :)))

0
 
IncognitoManAuthor Commented:
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 ...
0
 
segurahCommented:
0
 
segurahCommented:
FYI we uses postgresql in a 80K employees corporation.
0
 
IncognitoManAuthor Commented:
I now postgre is a powerful DBMS, but the tool for it are paid. Thaks for the replies Guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now