April 2017 – EU
Presented by Elizabeth Smith (@auroraeosrose)
|Date:||April 20, 2017|
19:00 BST, 13:00 CDT, 11:00 PDT
Everyone knows that SQL is an outdated tool with a standard written in 1992 that isn’t webscale. Who needs consistency or isolation or even atomicity with your data. Just shove it in a document store! And then that transaction is suddenly missing for your user… SQL is not a dirty word, and if you’re processing data you should know how to use the right tool for the job. Learn about modern SQL dialect features including CTEs, aggregate filters, with clauses and more. We’ll look at database support for these features, and use PostgreSQL for examples. We’ll also look at features that many traditionally relational databases are adding and play with PostgreSQL’s jsonb features.
Elizabeth has been using PHP since time immemorial (PHP 4 beta), but has used PHP 7 for so long now that she’s forgotten how she ever got by without return and scalar typehinting. She also plays far too much with C based languages and has the superpower of breaking things, like valgrind and gdb, on the same day. She went to college for dance which quickly became an English major after the first baby. If you see her in person, ask how she wound up with a career in computers.