About:

Drew Silcock is a Senior Research Software Engineer interested in tech, especially databases and programming languages, with hobbies in coding and game development.

Website:

Specializations:

Interests:

Databases Programming languages Best practices Cloud infrastructure Game development

Incoming Links:

Subscribe to RSS:
The blog post discusses the process of manually creating a Git repository without using standard Git commands, emphasizing the elegance and simplicity of Git's design. It provides a step-by-step guide on setting up a repository fr...
The author describes a challenging debugging experience with a SvelteKit application after upgrading from Svelte 4 to Svelte 5. The issue arose when the application worked locally but failed to load on the staging server. The auth...
The Python core developers and community will release CPython v3.13.0 on 7th October 2024. The release includes two big changes: a free-threaded version of CPython which allows you to disable the Global Interpreter Lock (GIL), and...
This post is part 2 of a series on Postgres internals, explaining how Postgres stores oversized values using TOAST. It includes a recap of the previous post, setting up a Postgres instance, creating a table, and loading data. It e...
The text discusses the importance of databases in server-side applications and the magic of SQL. It focuses on PostgreSQL and how it stores data on disk, explaining the structure of the database files and folders. The author also ...
The text is about a version bumper called Bumper that the author created to automate the process of updating versions, commits, branches, and tags. It is specifically designed for use with git flow, main and dev branches, tagging ...
The text is about a Rust parser for the COMTRADE signal file format. It explains the meaning of COMTRADE, the file format specs, the motivation behind the project, and the current status of the project.
The author shares their dotfiles on GitHub, including configurations for neovim, tmux, and CLI tools. They also list their go-to day-to-day tools, including code editors, note-taking apps, version control management, application l...
The text is about QuEST, a C library for exact simulations of quantum circuits, and the QuEST-rs project, a Rust wrapper around the QuEST library. The author provides information on how to use the library and its current status.
The article discusses the handling of astral planes in JavaScript string indexing, the use of UTF-16 encoding, and the implications for string indexing. It also explores how other languages handle Unicode and the differences betwe...
The post discusses the Jekyll KaTeX block plugin, which enables the easy addition of mathematical equations to statically generated sites. It explains the benefits of using KaTeX, how to install the plugin, troubleshooting tips, a...
The text explains how to use make and latexmk for easy LaTeX compilation. It describes the basic syntax of latexmk, useful options to pass to latexmk, and how to wrap all this in a Makefile. It also provides a basic template for u...
The post explains how to calculate the required maximum distance between successive photos to ensure a certain percentage overlap, as well as how to calculate the speed needed to achieve this overlap. It provides the formulas and ...
The text explains how to use custom Jekyll plugins with GitHub Pages. It provides a solution to the problem of GitHub Pages not supporting custom plugins and explains how to organize the source and compiled code. It also includes ...
The post explains how to calculate the meters per pixel (MPP) of a photo taken by a particular camera for aerial photogrammetry. It provides the trigonometry and the required information to determine the MPP, including the resolut...
The text discusses the issues with the default lineno option in Jekyll, and provides an alternative solution using CSS counters. It also addresses the problem of an annoying y-scroll bar and a plugin incompatibility issue.
The text is a coding cheatsheet that includes quick snippets of often used commands, tricks, and tips for git, Vim, Python, Perl. It also provides information on updating git submodules, vim functions, editing over scp, sshfs, Pho...
The article explains how to compile zshell on a Linux machine without root access, including the necessary dependencies such as ncurses and icmake, and the steps to compile and install zsh. It also provides troubleshooting tips an...