MaxinDev GeniusThe Weird Side Effects of Modifying Python Variables Inside a FunctionHave you ever faced a bug in your code when writing Python where you thought you were modifying a local variable but actually modified the…Jun 24, 2022Jun 24, 2022
MaxinBetter ProgrammingThe Unexpected Workings of Python’s Default ArgumentsThat can help you create fresh objectsJun 20, 20221Jun 20, 20221
MaxinDev GeniusUnderstanding EXPLAIN ANALYZE Query Plans (Part 2 of 2)This article is part 2 of a set of 2 articles focused on understanding the query planner output using the EXPLAIN statement. If you’d like…Jun 6, 2022Jun 6, 2022
MaxinBetter ProgrammingDealing With Slow SQL Queries? Let the “EXPLAIN” Statement Handle ItUnderstand EXPLAIN query plans (part 1 of 2)Jun 6, 2022Jun 6, 2022
MaxinDev GeniusHow To Improve the Performance of Your SQL QueriesWe can all benefit from having faster queries. If you’re a Business Analyst that may mean having your dashboards and analytical queries…Apr 9, 2022Apr 9, 2022