MySQL Forums
Forum List  »  Other Migration

Re: MySql Vs Firebird
Posted by: John Daisley
Date: January 16, 2009 10:34AM

Milan Tomes Wrote:
-------------------------------------------------------
> Firebird:
> - clear and understandable SQL syntax
> - fully supported relations
> - 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)
> - autoincrement 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)
> - autoincrement values support is really bad
>
> In my opinion - MySQL is the worse (pseudo)SQL
> server I've ever seen. Hopefully there will be
> soon available spatial support for Firebird &
> MySQL will be kicked out really fast. MySQL can't
> be used for serious development.
>
> M.T.


Wouldn't an unbiased comparison have been more helpful instead of this from someone who openly admits to not knowing MySQL Architecture?

I wouldn't try and compare the two because I don't know Firebird and don't know of anyone who has even tried using it. I use MySQL because it is fast, functional, is proven in millions of active installations (including some very large high profile users), and is easy to use and maintain.

Its difficult to understand where the idea that the SQL Syntax is poor has come from; its certainly on a par with Oracle which I use frequently and far better than SQL Server which I also use regularly.

Stored Procedures, User Defined Functions and Triggers all work well.

If you know how to work with MySQL Timestamps you can do some very powerful things with them and its easy to populate a datetime field with the current timestamp.

Auto-increments in MySQL do exactly what they should and whilst not as powerful as an Oracle Sequence they do work well.

I must say the Firebird community do seem a little agressive towards MySQL, why is that? I have noticed this on here and on a few Linux forums.

Regards

__________________________________________________________________________

John Daisley

Freelance Cognos BI Developer / SQL Server & MySQL DBA
Gloucester, United Kingdom.
Telephone +44(0)7918 621621

» MySQL Certified Database Administrator (CMDBA)
» MySQL Certified Developer (CMDEV)
» MySQL Certified Associate (CMA)
» Comptia A+ Certified Professional IT Technician

Options: ReplyQuote


Subject
Views
Written By
Posted
29885
October 21, 2008 04:33AM
15827
November 26, 2008 03:47AM
Re: MySql Vs Firebird
16990
January 16, 2009 10:34AM
13644
March 06, 2009 06:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.