MySQL and PostgreSQL are relational database management systems that are
available free of charge from the internet. Both are considered open source
software. PostgreSQL provides some advanced features that MySQL does not,
including object-relational features, transaction support, sub-selects, and foreign
keys. Both are quality database servers and support much of the ANSI standard
SQL92. MySQL or PostgreSQL can provide an inexpensive way for students to
gain experience withan industrialstrength, SQL based, client-server DBMS. PHP
is an open source, HTML-embedded scripting language. Adding PHP to the mix,
students can easily develop web applications with database connectivity. In
addition, there are JDBC drivers for both MySQL and PostgreSQL, so students
can produce database applications in Java. This tutorial will provide an introduction
to MySQL, PostgreSQL, and PHP. I will compare and contrast the merits and
drawbacks ofMySQLversus PostgreSQL, and I will talk about the parts ofANSI
SQL supported by each. I will also briefly cover the process of setting up a MySQLor PostgreSQL server in a Solaris or Linux environment. Participants will
be able to interact with running servers and run queries and updates on a set of
sample data. We will also cover a briefoverview ofPHP and participants can run
several sample web based applications that will interact with each database server.
MySQL and PostgreSQL are relational database management systems that are
available free of charge from the internet. Both are considered open source
software. PostgreSQL provides some advanced features that MySQL does not,
including object-relational features, transaction support, sub-selects, and foreign
keys. Both are quality database servers and support much of the ANSI standard
SQL92. MySQL or PostgreSQL can provide an inexpensive way for students to
gain experience withan industrialstrength, SQL based, client-server DBMS. PHP
is an open source, HTML-embedded scripting language. Adding PHP to the mix,
students can easily develop web applications with database connectivity. In
addition, there are JDBC drivers for both MySQL and PostgreSQL, so students
can produce database applications in Java. This tutorial will provide an introduction
to MySQL, PostgreSQL, and PHP. I will compare and contrast the merits and
drawbacks ofMySQLversus PostgreSQL, and I will talk about the parts ofANSI
SQL supported by each. I will also briefly cover the process of setting up a MySQLor PostgreSQL server in a Solaris or Linux environment. Participants will
be able to interact with running servers and run queries and updates on a set of
sample data. We will also cover a briefoverview ofPHP and participants can run
several sample web based applications that will interact with each database server.
การแปล กรุณารอสักครู่..
