Macro vs. Micro Vision

In this weeks episode we start off by congratulating Mick on handing in his masters dissertation. We then move on to discuss decision trees, ordinal regression and genetic algorithms. Edd then mentions managing large tables in Postgres, MVCC, Fill factors and Vacuuming a table. From here we highlight an interesting JavaScript Unicode/New-Line length issue that occurred recently. Finally, we touch upon testing time-dependent processes in isolation, dreaded CRM integration and sign-up processes.

Corrections: Couple of mistakes by Edd; its’ MVCC not MVVC, and any character that can’t be represented using 8 bits in PHP will have a strlen > 1.

Show Links

• Decision trees
• Ordinal regression
• Weka - Data Mining with Open Source Machine Learning Software in Java
• Learning to rank
• Shannon entropy
• The Awesome Table Fillfactor to speedup UPDATE and SELECT statement
• PostgreSQL - Difference between table fillfactor and index fillfactor
• PostgreSQL Concurrency with MVCC
• grayhemp/pgtoolkit: Tools for PostgreSQL maintenance
• Reducing bloat without locking
• Reduce bloat of table without long/exclusive locks
• TOAST - PostgreSQL
• Understanding Character Sets and Encodings - Three Devs and a Maybe
• JavaScript has a Unicode problem - Mathias Bynens
• bestiejs/punycode.js: A robust Punycode converter that fully complies to RFC 3492 and RFC 5891.
• Basic Multilingual Plane (Unicode)
• The Great Newline Schism
• cemerson/clock - Packagist
• krakjoe/uopz: User Operations for Zend
• Carbon - A simple PHP API extension for DateTime.
• Test Doubles
• seanpowell/Email-Boilerplate: The email boilerplate for sending out nicely formatted messages.
• Taylor Otwell on Twitter: “Laravel 5.4: write your mail / notifications in simple Markdown with Blade…”