Posts
2024
- Everything you need to know about Python 3.13 – JIT and GIL went up the hillAll you need to know about the latest Python release including Global Interpreter Lock and Just-in-Time compilation.#python
- How Postgres stores oversized values – let's raise a TOASTPostgres internals part 2 – oversized values and TOASTable types#postgres #databases
- How Postgres stores data on disk – this one's a page turnerA high-level overview of how PostgreSQL stores data on disk, covering segments, pages and more.#postgres #databases
2018
2014
- Using make and latexmk for easy LaTeX compilationGuide to using make and latexmk for easy LaTeX compilation#latex
- Calculating the overlap of aerial photosCalculate the overlap of aerial photos for photogrammetry.#photogrammetry
- Calculating meters per pixel from aerial photographsCalculate the meters per pixel of a camera from its resolution, height, and angle of view.#photogrammetry