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.
Do a search on this forum, there is a nice (and long) thread on this
Found it :
http://forums.devshed.com/showthread.php?s=&threadid=62269&perpage=80
Hi, I'm adding this link I found http://www.dbginc.com/tech_pprs/ibmy.pdf it's a PDF that compares the two.
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.
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.
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.
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.. :p
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
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
@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:
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