Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog Abban's gone and done a blog

TIL Week 9 2022

01/03/2022 • 1 minutes

Professional

A roundup of the things I learned in the 9th week of 2022.

Technical

Doctrine doesn’t escape column names so you shouldn’t use a MySQL reserved word as a column name.

To view the SQL you’re trying to run in Doctrine you can set a logger

$debug = new DebugStack();
$em->getConnection()->getConfiguration()->setSQLLogger($debug);
// Do queries in try catch
print_r($debug->queries);

Professional

Always test as close to production as possible. Because interval is not a reserved name in SQLite, but is in MySQL the Doctrine column name issue in Technical would have slipped through CI and caused production to break. This is because our test environment was using SQLite.

Personal Notes

When work informs you that Coronavirus is over and they’re no longer going to provide support to parents, and at the same time your kid is home for 2 weeks because of a Coronavirus outbreak in his kindergarten it is incredibly demotivating.