My PHP journey part 8 (through to 9).

I’ve merged the 8th and 9th instalment into 1 single article…

MYSQL is often ushered in the same breath as PHP as the two are meant to work very well together.  MYSQL is a relational database system.  What do databases do? Store data, and then you can do as you wish with this data.  On my course we’ve been using the advanced terminal to get a grip with things – this has it’s pros and cons, the pros probably out weighing the cons in the long term.  The pros being that we are being taught interchangeable skills – skills which can go a long way in the work place. The cons being, if you haven’t dealt with this before, you can find you brain panicking as you really do need to build up your confidence when dealing with this sort of application.

Now throughout this part of my course (and I type this with as much respect for my tutor as possible, as she is trying to cram as much in as possible – however, quart and pint pot comes to mind!) I reverted to looking at the manual, located here and following it step by step.  This doesn’t have any reflection on my tutor and what she knows or how she teaches, but this was something I wanted and needed to take in more slowly, and with all of the other stuff I’ve learned so far, have a free reign to be creative and do as I wish with this application and hope that this application comes in handy at some point (which no doubt it will).

Instead of regurgitating what it says on the above links (and you should really take a look at what they have to say before you start reading anything about PHP/MYSQL from my view point) here is some text from MYSQL, about what it is!

[box color=”green” align=”left”]

MySQL is the world’s most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it’s history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

Many of the world’s largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.

The flagship MySQL offering is MySQL Enterprise, a comprehensive set of production-tested software, proactive monitoring tools, and premium support services available in an affordable annual subscription.

MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.

MySQL was originally founded and developed in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael “Monty” Widenius, who had worked together since the 1980’s. More historical information on MySQL is available on Wikipedia

Our Continued MySQL Values

We want the MySQL database to be:

  • The best and the most-used database in the world for online applications
  • Available and affordable for all
  • Easy to use
  • Continuously improved while remaining fast, secure and reliable
  • Fun to use and improve
  • Free from bugs

 

We want the people working on MySQL to:

  • Subscribe to the Open Source philosophy
  • Aim to be good citizens
  • Prefer partners that share our values and mindset
  • Answer email and give assistance to users, customers, partners and co-workers
  • Be a virtual organization, networking with others

[/box]

Source: MYSQL