Thread:SamwiseFilmore/@comment-25101690-20161212231300/@comment-25101690-20161215232936

SamwiseFilmore wrote: Still could be slightly annoying.

My dad works with SQL a lot. You basically just shuffle data?

Shuffle data? SQL is just a language for database access. Databases are the most efficient known way to store lots of data, efficient being measured in multiple criteria, including access speed, insert speed, update speed, memory consumption. A big advantage of SQL is that it allows to define very complex search criteria, far more complex than any Google search, to select very specific data.

The most important part of database programming is data modelling, which means to find a representation for the data that makes it easy to insert and later find the data in the database. You split your data in multiple entities (objects) and consider the relations between the entities. A good data model can make servers much more efficient, allowing to handle more accesses in shorter time, consuming less valuable server resources, and sending the responses to the client faster. A popular website often has millions of database accesses per second[citation needed], so a good database model can save a lot of money otherwise used for additional server hardware.