I heard it's almost the same, but in fact, there are many people use mySQL instead of PostGRESQL. Anybody know what's the difference? mySQL syntax of course is the most standard syntax that other also has right? I just installed my Linux with PostGRESQL **Going to try it out soon once I have my internet setup**

__________________

---

I dont know whats the difference, i have both on my web host, i only ever use mySQL though, im guessing mySQL is more of a standard database than PostGRESQL, be intresting to know more about if anyone can explain?

__________________

---

This is a very interesting topic. I was googling around about comparation
of MySQL and PostgreSQL. According to what I have read, they said
PostgreSQL have more advance features than what MySQL have, and
PostgreSQL is stable than MySQL. However, MySQL run faster than PostgreSQL.
In my opinion, I think MySQL have more supporters than PostgreSQL
because much of PHP books talk about MySQL.

From siLenTz
Wait and see which one is better in the future...

__________________

---

but can't we use either one for PHP though? using the same command to connect to mySQL to PostgreSQL? since PostgreSQL is just a mySQL with aditional features and power...

__________________

---

You can use both with PHP, i dont know if its the same connection string or not, i would think its the same or similar.

__________________

---

In what I believe, you cannot use 2 of them in the same time because
two of them are difference database software. If you use MySQL you have
to have MySQL installed do it in MySQL way. But if you use PosthgreSQL
then you have to do it in its way. Moreover, I think, the way of storing
database of these two software are difference. If you use MySQL, they have
to store in MySQL server....

From siLenTz
I think....

__________________

---

Yeah, I'm pretty sure that you can't use both PostgreSQL and mySQL at the same time of course, that wouuld be confusing!!!! but I'm just wondering whether I can use PostgreSQL with PHP as well as ASP.NET

Since I'm now excited with these 2 languages. They're rocks! Haha, but for now I'm dealing more with ASP.NET probably even though I haven't figured out the problem on my laptop

__________________

---

You can use both MySQL and PostgreSQL in ASP.NET
MySQL: Accessing MySQL Database with ASP.NET
PostgreSQL: Postgresql and ASP.NET - installing Postgresql on Windows

From siLenTz
Enjoy!!!

__________________

---

Postrgresql kicks the butt out of MySQL (well used to)... but it had such strong support from PHP... and php made integrated functions directly for mySQL. MySQL used to suck compared to PostGres then they got innoDB tables. MySQL just recently got stord procs, triggers, etc... with mysql 5... now MySQL is catching up but it's amazing how lesser products can become more popular.

__________________
Day Cares | Golf Courses | Disc Golf Courses | Campgrounds | Ice Rinks | Paintball Fields | Dentists | Plastic Surgeons | Aging Jokes
Catholic Churches | Lutheran Churches | Methodist Churches | Episcopal Churches | Clean Jokes

---

isn't it still kicking butt...?? Can't we use the mysql_connect() command in PHP and using PostgreSQL though...? Doesn't PostgreSQL have all of those functions too? Moreover, I think PostgreSQL have additional features than mySQL... haha...

__________________

---