On 2013-07-15 13:43, leledumbo wrote: > > Or if they insist on using MySQL (compatible alternative): MariaDB
Nope, still not! I'll not touch MySQL, MariaDB or anything based on those with a 10 foot pole! If you value your data, stay away from those two. Another developer enlightened me on how bad MySQL really is, and I confirmed what he said on two of my servers (Linux and FreeBSD). Here is the simple test to show how bad MySQL/MariaDB is... ---------[ Forwarded message ]----------- This test was done on a newly setup FreeBSD server - no tweaking to MySQL was done - just the default install. mysql> create table a (b int not null, c int not null); Query OK, 0 rows affected (0.17 sec) mysql> insert into a (b) values (1); Query OK, 1 row affected, 1 warning (0.03 sec) As if the above was not miraculous enough, then you get: mysql> select * from a; +-+-+ | b | c | +-+-+ | 1 | 0 | +-+-+ 1 row in set (0.00 sec) Unbelievable! Then depending on which filesystem your MySQL database is, it affects the case sensitivity of the table names! Why, oh why, let a filesystem dictate requirements in your database schema. eg: Moving a database from Windows to Linux/FreeBSD/etc.... Under Windows the database schema will not be case sensitive, and your applications work wonderful. Move that database to a more secure Linux/FreeBSD system, and suddenly your application is broken - because the filesystem under Linux/FreeBSD is case sensitive and your SQL statements didn't know that. This is apparently caused by MySQL because it uses a directory structure to define tables - one directory per database table. Absolutely ridiculous! Then there are cases where MySQL magically does Number-to-String and vice-versa conversions. MySQL is nothing but a toy database "server" (if you can call it that) - you really must not place any value on your data. My clients value their data a lot, hence we use a real database server...Firebird is a good fit for most of my clients. -----------[ end of message ]------------ Regards, - Graeme - -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
