[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 875
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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