Databases
Where the data of a web platform lives and how you ask for it. I have written SQL since 2009 and still use it every day.
Most data on the web sits in relational databases: tables of rows and columns, linked through keys and queried with SQL. The language was standardised by ANSI in 1986 and by ISO a year later, so the basics I learnt long ago still apply. SQLite takes a different route from the others: the whole database is one ordinary file, read and written by a library inside the application, without a separate server process.
MySQL has been the database next to PHP for me since my own domain in 2004. From 2009 to 2015 I worked with Microsoft SQL Server, writing reports on business systems, and since 2023 I have used PostgreSQL next to MySQL. SQLite joined in May 2026, for cases where a single file is all a tool needs.
Frameworks such as Laravel hide much of the SQL behind models and query builders, which saves a lot of time. I still like to see the query that actually runs. A missing index or a query repeated inside a loop can cost more speed than almost anything else on the page.
0 updates
Everything I posted about Databases, newest first