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 treesOrdinal regressionWeka - Data Mining with Open Source Machine Learning Software in JavaLearning to rankShannon entropyThe Awesome Table Fillfactor to speedup UPDATE and SELECT statementPostgreSQL - Difference between table fillfactor and index fillfactorPostgreSQL Concurrency with MVCCgrayhemp/pgtoolkit: Tools for PostgreSQL maintenanceReducing bloat without locking Reduce bloat of table without long/exclusive locksTOAST - PostgreSQLUnderstanding Character Sets and Encodings - Three Devs and a MaybeJavaScript has a Unicode problem - Mathias Bynensbestiejs/punycode.js: A robust Punycode converter that fully complies to RFC 3492 and RFC 5891.Basic Multilingual Plane (Unicode)The Great Newline Schismcemerson/clock - Packagistkrakjoe/uopz: User Operations for ZendCarbon - A simple PHP API extension for DateTime.Test Doublesseanpowell/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…”