[Gambas-user] Gambas2 components?

Benoit Minisini gambas at ...1...
Thu Jan 15 00:44:22 CET 2009


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




More information about the User mailing list