Web 2.0 — Dynamic, Interactive Websites!
However, there is one significant piece of the puzzle that largely remained unchanged, and arguably helped the Web 2.0 growth the most — relational databases. PHP and MySQL dominated the early days of Web 2.0, and still does to this day. Let’s take a quick look at our favorite sites and software from the early days:
- Xanga — PHP & MySQL
- Newgrounds — PHP & MySQL
- DeviantArt — PHP & MySQL
- Photobucket — PHP & MySQL
- AddictingGames — PHP & MySQL
- All your favorite forums (vBulletin, phpBB, SMF) — all PHP & MySQL
Relational databases, specifically MySQL, completely changed the landscape, and is still the most dominant RDBMS to this day. Relational DBs organize data into tables, which contain columns and rows with a unique key identifying each record. This allows for easy, efficient, and logical ways in which data can be stored, updated, and retrieved. Without this seemingly simple, yet so powerful piece of data storage technology, the internet would look completely different today.