On Thu, 17 Feb 2000, Nemeth Miklos wrote:
> > And if this isn't too inflamatory a question, where does postgresql stand
> > in comparison to MySql and DB2? (both of which aren't free I believe).
> >
> MySQL does NOT support transaction, which is indispensable for a real
> DBMS used as the primary data storage system for reliable/consistent
> business transactions.
> However, MySQL is the fastest RDBMS ever seen, and perfect for data
> warehouses and DSS and EIS purposes, as well as for
> query databases for web sites.
MySQL is pretty free - you just canno redistribute it with commercial
applications.
MySQL is FAST! (MySQL is fast only on very simple SELECTs, but it is
more than enough for most Web projetcs.)
MySQL has very good fine-grained access control; you can GRANT almost
whatever you want to whomever (and REVOKE too) on a very selective basis:
GRANT select,insert ON my_data.table1 TO user1;
GRANT select,insert,update ON my_data.table2 TO user2;
GRANT alter,delete ON my_data.* TO user3;
MySQL has very good ALTER TABLE command.
MySQL has good support for Large Objects. I have a habit to store
and manipulate Web-images right in database using SELECT, INSERT, UPDATE.
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.