okay,so we recently installed postgresql in addition to mysql on our cpanel server.I've got a few questions about the comparison of them.....:
which is generally better speed/performance wise?
can postgresql function as good as mysql with php?
is there any severe diffrence in the specific SQL functions?
Is it worth using postgresql instead of mysql when developing php based sites?
I've never used postgresql before....so I'm interested in getting to know it intimately(I love database work)
thanks.I have heard a lot of talk about how postreg can do so much more. it can do subselects, mysql can't. it is over-all faster so I have heard. from what I have read it is best to desgin with postreg but not many host support it. I beleive when mysql4.0 gets up to speed and finally comes out of beta it will be just the same as postreg is now. I have not used postreg so I can't comment on it apart from what I have read.ah I see.so I should probably read some articles about it then
MySQL 4.0 is released (no longer Beta). Postgresql is a very capable database (one of the guys I work with has used it extensively). It's not quite as fast as MySQL but can handle stored procedures, sub-selects, cascade deletes and referential integrity.
MySQL 4 is a major step in the evolution of the database and has closed the gap in some of these areas. You won't go far wrong with Postgresql though should you decide to go that route.
Btw, MySQL 5.0 will incorporate Stored Procedures Yay! See below:
<!-- m --><a class="postlink" href="http://www.mysql.com/doc/en/TODO_MySQL_5.0.html">http://www.mysql.com/doc/en/TODO_MySQL_5.0.html</a><!-- m -->
which is generally better speed/performance wise?
can postgresql function as good as mysql with php?
is there any severe diffrence in the specific SQL functions?
Is it worth using postgresql instead of mysql when developing php based sites?
I've never used postgresql before....so I'm interested in getting to know it intimately(I love database work)
thanks.I have heard a lot of talk about how postreg can do so much more. it can do subselects, mysql can't. it is over-all faster so I have heard. from what I have read it is best to desgin with postreg but not many host support it. I beleive when mysql4.0 gets up to speed and finally comes out of beta it will be just the same as postreg is now. I have not used postreg so I can't comment on it apart from what I have read.ah I see.so I should probably read some articles about it then
MySQL 4.0 is released (no longer Beta). Postgresql is a very capable database (one of the guys I work with has used it extensively). It's not quite as fast as MySQL but can handle stored procedures, sub-selects, cascade deletes and referential integrity.MySQL 4 is a major step in the evolution of the database and has closed the gap in some of these areas. You won't go far wrong with Postgresql though should you decide to go that route.
Btw, MySQL 5.0 will incorporate Stored Procedures
Yay! See below:<!-- m --><a class="postlink" href="http://www.mysql.com/doc/en/TODO_MySQL_5.0.html">http://www.mysql.com/doc/en/TODO_MySQL_5.0.html</a><!-- m -->