#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Soton, UK
    Posts
    43
    Rep Power
    11

    Lightbulb Overview comparison : Firebird vs MySQL ????


    I have regularly used MySQL for over 2 years, before that I used Interbase for 1 project - a further year previous though !

    I am now very tempted by Firebird ... but due to a shortage of time I can't "afford" to 'play' with it unless I'm sure its of use to me.


    Can anyone outline the differences to MySQL and preferably also provide links to web sites which elaborate on such comparisons ?

    I use Windows for general stuff at home and Linux for Web Serving.

    I will be looking to implement secure transaction safe databases which need to be efficient due to high server loads.

    I work with PHP & C# ( though not both @ once )

    I'm looking for : pro's, con's, things which may annoy me or are most likely to "trip me up" and things which I will really appreciate.


    Cheers,
    Hawk.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    Do a search on this forum, there is a nice (and long) thread on this
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Soton, UK
    Posts
    43
    Rep Power
    11
  6. #4
  7. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    10
    I was looking at MySQL 4 - No SProcs, No Triggers, No Views, No Check Constraints ,No Transactions, No Roles.

    No wonder it is so fast, it isnt doing anything! - Sounds like old DBase on steriods!

    And you still have to pay for it while it lacks all these features

    Why is it so popular? ...Must be a Linux \ Unix Community thing.

    I havn't worked with MySQL before - does it have Foreign Keys to define relationships?

    Rather go with Firebird - It can be an proper Server database or a desktop database.
  10. #6
  11. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    Well, I've recently discovered Firebird and like it very much, but let me add something about MySQL, it has FK, you need to create tables of type InnoDB or BDB, the default MyISAM tables don't have FK.
    It's licencing makes it free unless you use it in commercial apps, and yes, it has a huge community behind.
    Anyway, from a feature point of view it is well behind PostgreSQL and Firebird.
    It also has two nice features that Firebird lacks, full text indexing and built in basic replication.
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    10
    I know i am going bit off topic...

    I found this doc on the web about Mysql - http://openacs.org/philosophy/why-not-mysql.html

    I tough it was very good - answered all my questions on why not to use Mysql.
  14. #8
  15. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Portugal
    Posts
    106
    Rep Power
    11
    Originally Posted by pabloj
    Well, I've recently discovered Firebird and like it very much, but let me add something about MySQL, it has FK, you need to create tables of type InnoDB or BDB, the default MyISAM tables don't have FK.
    Yes it has foreign keys but doesn't enforce them. So I don't see the point in having foreign keys like that..
  16. #9
  17. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    New Jersey, U.S.A.
    Posts
    40
    Rep Power
    10

    It depends on your need....


    Hello to all :-)

    I think choosing the backend database is not easy always, but it must be done very wisely depending on the whole system architecture. If you have a plan to separate database module and business module, personally I prefer to choose any RDBMS that supports stored procedures and UDFs. I don't put any sql statments directly into my module source code but only the code calling the backend stored procedures.

    In this category, I am really impressed by FireBird RDBMS. I have been using InterBase v6 and v7, and SQL2000 for many years, but I am really happy with using this FireBird for my ASP.NET project. It simply meets my expectation and has all features I want.

    Regardgin MySQL, it is very easy to handle and admin. I like this database too. Again, when choosing the database, we need to consider which feature we need from RDBMS in order to perform our projects successfully and smoothly.

    I will simply follow my taste..... in this case.

    - JH
  18. #10
  19. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    10

    O \ R Mapper for Firebird


    If you have a plan to separate database module and business module, personally I prefer to choose any RDBMS that supports stored procedures and UDFs.
    Bit of topic.
    For N-tier development in .Net for Firebird checkout LLBLGen (O\R Mapper) - Now supports Firebird (Beta version only).
    For MySQL lovers - LLBLGen will support this towards the end of the year.

    Check out Http://www.LLBLGen.com
  20. #11
  21. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    @Fetcher:

    MySQL 4 - with InnoDB/BDB table types - does enforce FKs.

    It doesn't have Check Constraints though

    --
    Martijn Tonies
    Database Workbench: works with Firebird, MySQL, InterBase and MSSQL Server
    Upscene Productions
    http://www.upscene.com
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  22. #12
  23. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Portugal
    Posts
    106
    Rep Power
    11
    @Martijn:

    My bad then .Maybe I was using an older version but I remembered to delete a table referenced by another one(ex: tbl_products_categories) and it didn't complain ... it probably was an older version.

    Anyway, I think this link is very interesting. everyone should read it: http://sql-info.de/mysql/gotchas.html
  24. #13
  25. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    @Fetcher...

    Oh, it's full of gotchas Be sure about that...

    I'd go with Firebird
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com

IMN logo majestic logo threadwatch logo seochat tools logo