Posts
2024
- 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