On jeudi 15 janvier 2009, Gareth Bult wrote: > Mmm, > > I wouldn't know "how" to do what GridEditor does without autoinc fields and > last_id .. if other DB's make this difficult or don't provide the > functionality, that sort of reinforces my suggestion that one should choose > MySQL. > > Just turning it around for a second, is there any reason why one should > *not* use MySQL? > > As a 10yr+ MySQL user, my views may be biased, however to the best of my > knowledge; a. MySQL is faster than the competition, certainly the likes of > Postgres (by a lot!) b. MySQL does not crash - so it's reliability is not > question > c. Current versions support all the stuff (triggers, stored proc's etc) > that people used to insist was their excuse for Postgres d. MySQL does > loads of back end replication stuff other DB's don't do e. MySQL runs on > more Platforms than any other DB > f. It has bindings for every language I can think of, and then some > g. It has loads of nice GUI tools and designers (commercial and free) > .. etc .. etc .. etc ... > > yes I do have the T-shirt, but no they're not paying me. > > Bottom line, I have no reason why GridEditor should not support other DB's > , just so long as they can actually do the job .. so as soon as people with > the relevant expertise provide Gambas with autoinc / lastid support, I'll > see if I can use it in place of a raw SELECT statement .. how's that ? > :-) > > Gareth. >
1) How can you know that we should use MySQL if you have used MySQL only? 2) The MySQL C API is, hem... strange. Let be politically correct there. 3) Why did they change their timestamp format suddenly? 4) There is no difference between a BLOB and a large TEXT field. 5) MySQL only get features recently that PostgreSQL had for years. 6) David Villalobos Cambronero got an error message from mysql. I have no idea at all where it comes from. Maybe it is gb.db.mysql fault there, but it makes me angry. :-) Not that PostgreSQL is perfect, far from that. The only clean database API I know is the SQLite one. The funny thing in Gambas is that the gb.db.sqlite component (sorry Niggel!) has used a crappy C++ layer on top! And I don't talk about sticking the word "standard" with "SQL"... -- Benoit Minisini ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
