MySQL vs. PostgreSQL

[javapenguin]

---

Diba mura daghan gamit ug MySQL than Postgre? Ngano LAMP (Linux,Apache,MySQL,PHP) man combination ug web server? LAPP unta

[cen]

mas nindot ang postgresql kaysa mysql. mao na among gamit sa academic programs, postgresql on linux

I hope you don't mind. Pero para nako dili kaau na reliable nga proof ang imong opinion. Ex. Kung gamiton sa academic programs is nindot.

Naa ma'y cguro lawm nga reason.

[stradnus]

LAMP gihapon (Linux,Apache,Mod perl,Postgre)

[javapenguin]

LAMP gihapon (Linux,Apache,Mod perl,Postgre)

btaw sa! ka bright jud nimo, hahaha

[javapenguin]

Mo matter ba ug unsa imo programming language gamiton? Kung PHP, MySQL or Postgre? Kung Java, MySQL or Postgre? Basin naa programming language more efficient interface to MySQL and vice versa?

[simoncpu]

It depends. Since MySQL is implemented in C, it follows that compiled programs that directly call the MySQL functions are much faster than interpreted ones. For example, a C program can communicate more efficiently to MySQL than any PHP script can.

PHP scripts use external modules (which are implemented in C) that parses the parameters and passes them to MySQL.


[ simon.cpu ] <-- currently making a PHP module that communicates with a secure database

[BadDudes]

depende lang cguro if where ka comfortable ... better try both in order for you to evaluate properly ...kay ma bias man gud if somebody would just say this one is better or the other one is better ... para sa ako depende lang jud on how you properly design your system from ground up. In some projects I've been assigend in db administration and tried some proprietary DBs to open sourced ones and all went down to proper implementation and design..

Just my two cents!

[javapenguin]

I guess BadDude is right, I'll try Postgre after I have thoroughly tried MySQL

[psyd_1]

yeah depende asa ug unsa imu gamitan..

MySQL is faster compared to Postgres in terms of performance. However, MySQL dont have a Stored Procedure feature not like Postgres.

sa akoa lang,

if pang web apps -- MySQL , faster and simplier
complex apps like ERP's and the like -- Postgres

[BadDudes]

I think MySQL will now support stored procedure kindly update yourself