Lesson Weekend

In the next few lessons, we'll start exploring SQL, or Structured Query Language, the standard language of databases. There are many types of SQL databases, and they work very similarly - almost everything you learn at Epicodus can be applied to any type of SQL database. The next few lessons will use MySQL; other SQL databases include SQLite, PostgresSQL, Microsoft SQL Server, and Oracle databases.

To use databases with PHP, we use an extension of PHP called PDO, which stands for PHP Data Objects.

Epicodus computers already have PDO and MySQL support set up. If you'd like, you can just not worry about configuring your own computer to use MySQL, and just work at Epicodus.

If you're setting up your own Mac, we recommend using a powerful tool called MAMP. We're able to do a lot with MAMP. For our purposes here it will help us create and manage our databases. There is a great deal of excellent setup documentation online if you're installing these programs on your own computer. For now, we're going to include some help with MAMP.

If you're using MAMP simply click Start Servers.

At various points in the following lessons you will see references in our code to an address called localhost. This tells our code where our MySQL server is running. If you're using MAMP you'll need to adjust your code to reference localhost:8889 instead, as this is the location of the default MAMP MySQL server. This address is configurable within MAMP, just as it is in the other programs listed above.