Feed: Tinker, Tamper, Alter, Fry

Blog	Tinker, Tamper, Alter, Fry
RSS 2.0 Feed	Tinker, Tamper, Alter, Fry
web	https://blog.ploetzli.ch
Last Update	11.20.2024
Posts	4

How To Use PyJWT With Django In A Resource Server And Still Keep Parts Of Your Sanity

Aug. 20, 2024 » Tinker, Tamper, Alter, Fry » [Archived Version]

The OAuth2 spec cleanly separates the role of Authorization Server (AS) from that of Resource Server (RS). The role of the AS, and the whole OAUTH2 dance, is to get an access token that will be accepted by a RS.It’s puzzling. It should be easy, nay, trivial, to implement the Resource Server side in Django, […]

Understanding Common Table Expressions in SQL

Aug. 4, 2020 » Tinker, Tamper, Alter, Fry » [Archived Version]

One of the lesser known features of modern SQL are so-called “Common Table Expressions” (CTE) or “WITH queries”. I’ll explain the mental model that helped me make sense of them, and how to use them to execute recursive queries. Afterwards I’ll show how to apply these techniques in Django.Syntactically a CTE consists of one or […]

An Efficient Multi-Stage Build for Python Django in Docker

June 21, 2020 » Tinker, Tamper, Alter, Fry » [Archived Version]

We’ve recently begun dockerizing our applications in an effort to make development and deployment easier. One of the challenges was establishing a good baseline Dockerfile which can maximize the benefits of Dockers caching mechanism and at the same time provide minimal application images without any superfluous contents.The basic installation flow for any Django project (let’s […]

Showing SQL Queries with Pytest and Django

Nov. 20, 2019 » Tinker, Tamper, Alter, Fry » [Archived Version]

I have a Django based project, and am doing unit tests with py.test. To debug a test failure it’s sometimes useful to see the actual SQL queries that Django emitted, which is surprisingly hard. I assumed that that would be such an obvious and common need, that a simple switch (for pytest-django) or easy plugin […]