Announcement

Collapse
No announcement yet.

Firebird Vs MySql : Which is better ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Firebird Vs MySql : Which is better ?

    Hello all,

    Firebird:
    - clear and understandable SQL syntax
    - full relational support
    - multi generation architecture (but with incremental backups support)
    - fully supported stored objects (procedures, triggers, UDFs)
    - huge set of built-in functions
    - fully supported transactions (including snapshot)
    - auto increment through sequence generators

    MySQL (InnoDB engine):
    - SQL syntax is really bad
    - don't know MySQL's architecture
    - transactions may work
    - huge set of built-in functions including stupid limitations when using them (CURRENT_TIMESTAMP can't be used in columns of type other than TIMESTAMP (e.g. DATETIME) and also there cannot be more than 1 TIMESTAMP columns with NOT NULL constraint in 1 table - what a stupidity)
    - stored objects support is practically missing (except really bad stored procedure/function)
    - auto increment values support is really bad


    Now time to think


    Regards,
    Silvester J
Working...
X