Ask HN: Tools you have built for yourself?

I built PackageMap to help me visualise the codebase, and see where the natural seams were -- or should be.

https://packagemap.co

I use the tool to build a directed graph of the type and method usages, and to see which code is grouped into which packages. The code is rendered in a graph diagram that I can see, query, and filter. It really helps me when I'm doing code review or working on a part of the code I'm not too familiar with.

    Import-Xlsx and Export-SQL

The purpose of this is to enable spreadsheet-driven bulk provisioning tasks where there are a lot of distinct-but-similar parameters. I added some niceties such as the ability to trim off leading or trailing spaces and blank lines to prevent objects being created with names such as "xyz ".

The Export-SQL is the twin, which dynamically adds missing columns to a table and similarly allows streaming input. Simply pipe anything from the command-line to get it into a database for indexing and querying. This will work as expected:

    Get-AzVM | Export-SQL -TableName 'azurevms' -Database 'Reports'

I planned to open-source and publish both utilities, but there remain a couple of bugs that I could never be bothered to fix, and I'm not comfortable publishing tools that could potentially lose or corrupt data. That could make someone else's day very bad.

Copy/paste between hosts using Gitlab Snippets as a backend.

GTA:SA car physics editor gui in pygtk.

Batch upscaler using magick, realesrgan and rembg in node. Pre-resizes to 1mp, converts to webp.

html-to-m - convert html into mithril m() expression indented to my taste. Works as a vim filter.

Few AHK scripts (god forgive the syntax).

Few variants of update-these-vpses via sh/ssh/coreutils. Needed it because had no devops. Trying to learn terraform and ansible instead.

A dashboard for ERP software that made our life much easier when I worked at a warehouse (as a keeper, non-dev). It presented today’s tasks in a detailed list, created multiple cascades of documents with select-and-click, allowed to query qtys through omnisearch and to store cell addresses in unused fields for faster inventory. Our “terminal” was one of the quickest in a company, but nobody up there gave a fuck about some boy’s code. It was actively used by other employees for 17 more years after I left, also they asked to fix it a bunch of times after ERP upgrades. Proud.

A local webapp for doclinks, plans, motivation, remote project control. Sort of a self-launch dashboard. Most procrastinated WIP right now, wish I had it to implement it faster.