Indexed views (known as materialized views in other RDBMSs) can improve query performance as they store the result set of the view physically on disk, with details updated automatically when the un...

Setting Azure App Service to ‘Always on’ Azure App Service having the ‘Always on’ setting disabled can apparently lead to the container going to sleep, with the first d/b call after wake-up often ...

nan values cannot be directly serialized to JSON. Django REST Framework uses json.dumps(), which throws an error unless allow_nan=False is passed to it. Ref.: https://chatgpt.com/share/6907c3ca-4a...

pandas’ where() function doesn’t replace nan values in float64 columns by default. Instead, it retains the original nan values unless explicitly instructed to replace them. Coupled with the fact t...

pandas converts integer columns with nan values to float64 to accommodate those values. If the results of a SQL query that contains, say, min() or max() operations, and count() operations, are rea...

Updating virtual environment settings when folder names change In env\pyvenv.cfg, update file paths. In env\Scripts\activate, update file paths. Ref. \

Two-factor fixed effects regressions These can be useful to start to dig more into causality by focusing on changes in the independent and dependent variables - as this should strip out the effect ...

NB: These all require Git to be installed. Repos that have been turned into Python packages I.e. that have a setup.py file. pip install git+https://github.com/philipnye/<package_name> Repo...

Debugging Azure App Service issues Conflict (CODE: 409) When deploying an app to Azure App Service using GitHub Actions, it is possible to encounter the error message Deployment Failed, Error: Fail...

Using Django Create a project: django-admin startproject myproject cd myproject python manage.py startapp myapp Run development server: cd myproject python manage.py runserver