Take me back!! I want my CSS!! Click me to get back :)

×

Are you missing out on your dream job?

Enrollment for Skillcrush Blueprints JUST OPENED. Register today!

Click Here

MySQL

MySQL is one of the most popular databases in the world, and no one agrees on how to pronounce it.

Either “My Sequel” or “My S-Q-L” are okay, so don’t let anyone tell you otherwise.

A database is just a fancy spreadsheet that can hold tons of information and interact with programs. MySQL is one of the most popular because it’s found pretty much anywhere you can write a program, and it’s free.

In something like Excel or Microsoft Access you can poke and prod and drag values around, but databases like MySQL don’t really have a way to see them without using another program. You get to type something like this:

SELECT name FROM cocktails WHERE color = 'red'

Which, as you can probably tell, gets us all the cocktails that are red. This incredibly droll method of talking to a database is called the Structured Query Language, and it’s the SQL part of MySQL.

Databases are a powerful part of any dynamic web site, and MySQL is a widely-used and widely-known option.

There are a ton of database solutions out there, and everyone is always arguing about what is best. One particularly vocal group at the moment is the NoSQL movement, which is against RDBMS’s (Relational database management systems – say that five times fast). Other people might push PostgreSQL or Microsoft’s SQL Server.

Many large tech companies use multiple databases for different things. Facebook and Twitter use both MySQL and a NoSQL database called Cassandra, among I’m sure many others.

A big benefit of MySQL and many other RDBMSes is something called ACID compliance. You can read more about it here, but the basic idea is that it’s a very reliable system in terms of data integrity. If you accidentally lose a couple tweets, no big deal, but if your database forgets to deposit $50,000 into your bank account someone’s in trouble.

Cocktail Party Fact

It isn’t called “MySQL” because it’s yours – it’s actually named after the daughter of the main developer, My, which is a common Finnish nickname!

Your email address will not be published.

3 comments

  1. codemeshon Replied

    I’m still a bit confused.. can someone simplify it even more for me… databases and how it relates to MySQL.. I’m trying to visualize what that looks like but struggling.

  2. artaffects Replied

    OK. So what exactly is the difference between all these SQLs, No-SQLs, Pre-SQLs, and such? Not trying to be a smart @ss. Just want to know. :) 

    • sareg0 Replied

      Hey artaffects,
      That’s a good question.
      SQL is the query language by which one goes about ‘querying’ a database.
      NoSQL is a type of storage, but just doesn’t have sql as the query language :)

Want more articles like this?

Sign up to get the most recent tech news, tips and career advice.