Re: Buglist
От | Robert Treat |
---|---|
Тема | Re: Buglist |
Дата | |
Msg-id | 1061301235.1708.222.camel@camel обсуждение исходный текст |
Ответ на | Buglist (Bo Lorentsen <bl@netgroup.dk>) |
Список | pgsql-general |
On Tue, 2003-08-19 at 07:32, Bo Lorentsen wrote: > Hi ... > > I'm trying to convince my boss to use posgresql (I need RI, transactions > and views), but he keeps comparing the project to mysql. Until now, I > found the answers to he's questions on the www.postgresql.org page, but > now I'm lost :-) > > Where do I find a list of bugs both found and solved, or will I need to > ask on the pgsql-bugs list to know the answer ? search the bugs forum. for a list of bugs/missing features, the TODO list is your best bet. > > Also have anyone tryed to compare the new transaction model in MySQL 4.x > to PostgreSQL ? > The biggest problem I see with the mysql transactional model is that it violates relational theory, namely the separation of the physical and logical model, but allowing both myisam and innodb tables to coexist. I think it was stephen szabo who posted the best example of this which involves starting a transaction, updating both a myisam table and an innodb table, then rolling back the transaction. in this case the myisam table will be updated and the innodb table wont, which means that app writers can't simple know what information is contained in a table, they have to know how tables are physically created and stored in order to work with them, which tends to increase development time. > I'm looking forward to recive even more constructive arguements :-) > a few links for your perusal: http://faemalia.org/wiki/view/Technical/PostgreSQLvsMySQL http://forums.devshed.com/archive/46/2002/10/3/35171 http://www.phpbuilder.com/columns/tim20001112.php3?page=1 http://openacs.org/philosophy/why-not-mysql.html hope this helps, Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-general по дате отправления: