SQL

mysql-logo

SQL is a standard language for accessing databases. SQL is used to access and manipulate data in: MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.

This is the best way to hold and contain your data connected to your website and is what we use to ensure requests to the server is fast.

Different versions?

There are different developers of SQL, such as Oracle, Sybase, and Microsoft, however their SQL programs all fundamentally work the same way.

MySQL is an opensource version of SQL, meaning it is open to the public to upgrade through the internet and best of all… free. This makes it very popular with developers. Which is why we use it ourselves

What sort of software is it?

SQL falls into the middleware category of software. Middleware typically functions in between two other programs, such as a website (the front end) and a database (the backend) allowing them to communicate.

Who use it?

Three good examples of websites that use SQL in some capacity are Ebay, Autotrader, and Amazon.

The types of people that may use SQL include Applications Developers, Programmers, and Database Administrators (i.e. the people that look after large databases).

The history of SQL

Dr. E. F. Codd published the paper, "A Relational Model of Data for Large Shared Data Banks". Codd's model is now accepted as the definitive model for relational database management systems (RDBMS). SEQUEL later became SQL (still pronounced "sequel"). In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL.

MySQL not quite as advanced

The maximum size of a row in a MySQL table is 65,535 bytes. And the maximum value of Signed Integer is 2,147,483,647 and the value of Unsigned Integer is 4,294,967,295.

This means the Databases are limited to 32bit, other systems can handle 64bit operations, so they can handle more data and do it faster.

Projects with SQL