Hi, I am a PHP Programmer.. Which database is good to use from MySQL, PostgreSQL, Oracle, SQL Server, Access for storing data of dynamic site ? Thanks for any help..
Nope, postgreSQL is far better, it's just that people don't use it, mySQL is missing some vital functions for an SQL. I'm not saying use postgreSQL i'm just saying it has more features. mySQL will have tons more support. Access is for Windows servers and runs only on .asp not php, as far as I know, hope that helps.
I'm also a fan of Postgres, but it can be maddening for MySQL programmers to make the switch because of a few major differences and a bunch of minor quirks. If it's a matter of deciding what to learn in order to market your skills or do some quick consulting jobs on boards like DP, you need to go with MySQL. It's what people use, it's what you need to know. If you want to write your own project/s from scratch, and can really choose anything, I second the vote for Postgres.
MySQ?L is free and well integrated with PHP....Postgres has a reputation of being slow but slight configuration can increase the speed much above the mysql.....oracle is paid but is the industry gold standard for years. Problems: MySQL DBs corrupt frequently when size of DB reaches above a few GBs. MS SQL and Oracle are paid. Postgres requires configuration for faster querying. Hope that helps.