MySQL, PostgreSQL, and PHP: open source technologies for a database management course
2001; Consortium for Computing Sciences in Colleges; Volume: 17; Issue: 2 Linguagem: Inglês
ISSN
1937-4771
Autores Tópico(s)Distributed and Parallel Computing Systems
ResumoMySQL 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 with an industrial strength, 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 of MySQL versus PostgreSQL, and I will talk about the parts of ANSI SQL supported by each. I will also briefly cover the process of setting up a MySQL or 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 brief overview of PHP and participants can run several sample web based applications that will interact with each database server.
Referência(s)