SQL has been around longer than most of us have been writing code—and it shows. Originally built for tidy tables and straightforward joins, it’s now being stretched to handle JSON documents, arrays, and even composite types. Meanwhile, so-called “NoSQL” databases are sneaking SQL in through the back door. In this talk, we’ll take a slightly ranty tour through the history of SQL, the rise of document databases like MongoDB and CouchDB, and the awkward state of modern query languages. If you’ve ever tried updating a nested JSONB field in MySQL and thought, “there has to be a better way,” this one’s for you.
In this talk, Pauline Vos will explain how she built the raffle system for the AmsterdamPHP meetups using WebSockets. She'll cover several real-time protocols, including their limitations and advantages.
Next, she'll proceed with a comprehensive implementation of asynchronous PHP using Ratchet for WebSockets. If you've ever wanted to learn how to build something for multiple users communicating in real time, this simple and fun use case is for you.