PDA

View Full Version : What is SQL, mySQL, Oracle 10g vs PostgreSQL 8 vs MySQL 5?


yahooquestionsforyou
10-08-2007, 08:45 PM
What is each of them and what is the difference between them ? I tried to google and confused. hope somebody can clarify this. Thanks

BS9999
10-08-2007, 08:46 PM
Each of them is a database management systems:
http://en.wikipedia.org/wiki/List_of_content_management_systems

Oracle is by far the biggest dbase...mySQL is a widely popular and free dbase., same with PostgreSQL.

annetteaisgroup
10-08-2007, 08:46 PM
They are all different types of Databases. MySQL and MySQL 5 is basically a database for web applications. PostgreSQL 8 is an open source database that is supposedly the most state of the art database. SQL is basically a powerful and flexible relational database software language composed of commands that enable users to create database and table structures, perform various types of data manipulation and data administration, and query the database to extract useful information.

babak_is_curios
10-08-2007, 08:46 PM
http://en.wikipedia.org/wiki/SQL

In a nutshell, SQL is a language for accessing information in a database.

MySQL, Oracle, and PostgreSQL are frameworks for maintaining or managing databases. Oracle is the largest RDBMS (Relation Data Base Management System) in the world and arguably the most advanced. PostgreSQL and MySQL are open-source competitors. Between the two PostgreSQL is more advanced while MySQL is more popular and said to be easier to use.

Shariq Khan
10-08-2007, 08:47 PM
All of them are DBMS/RDBMS - Data Base Management Systems/ Relational Database Management Systems which provides facility to Insert, Update, Modify, Delete, Search records using Structured Query Language(SQL/SEQUEL) and integration with various programming languages and platforms(Java, .Net etc).

SQL -Structured Query Language is supported by all RDBMS.

MySQL, MySQL5 are RDBMS product developed according to Standard rules(CODDS Rule+ rules of RDBMS)

Oracle 10g - provides various features for oniline Data Access(Server Client ).