Patrick patricksimpson

izerop Audit — Remaining Findings (2026-03-15)

Items not yet fixed from the full audit. Organized by repo.

N+1 in directory_json file_count — Each directory triggers a separate COUNT query in index. Fix: counter_cache or preloaded counts with subquery. (app/controllers/api/v1/directories_controller.rb)
N+1 in UserDirectory#path_display — Recursive parent loading for path construction. O(depth × N) queries on manifest endpoint. Fix: materialized path column. (app/models/user_directory.rb:33-43)
changes API limit logic bug — fetch_file_changes queries both active AND deleted with same limit, so actual count can be up to 2× limit. has_more can give false positives causing sync clients to loop. (app/controllers/api/v1/sync_controller.rb:10-23)

	config.assume_ssl = true
	# Force all access to the app over SSL, use Strict-Transport-Security, and use secure cookies.
	config.force_ssl = true

	...

	# based on https://github.com/Purple-Devs/health_check/issues/25#issuecomment-432819017
	config.ssl_options = { redirect: { exclude: ->(request) { request.path == '/up' } } }

	# and/or

	function dateToLocal(date) {
	let localOffset = new Date().getTimezoneOffset() * 60 * 1000;
	let d = new Date(Date.parse(date));
	return new Date(d.getTime() + localOffset);
	}

	{
	"createdBy": "Redirector v3.5.3",
	"createdAt": "2021-10-16T12:28:52.532Z",
	"redirects": [
	{
	"description": "Medium -> Scribe",
	"exampleUrl": "https://medium.com/@user/post-123456abcdef",
	"exampleResult": "https://scribe.rip/@user/post-123456abcdef",
	"error": null,
	"includePattern": " medium.com/(.)",

	#!/bin/sh

	dir=app
	files=*.js
	output=dist.js

	find $dir/$files -exec cat {} \; > $output

	while true; do
	watch -d -g ls -lR $dir/$files

	! undo any meta keys already set
	clear Mod1

	! keycodes 63 and 71 are the left and right COMMAND buttons adjacent to the spacebar; set them to be control keys
	keycode 63 = Control_L
	keycode 71 = Control_R

	! keycodes 66 and 69 are the option/alt keys; assign them as Meta keys
	keycode 66 = Escape NoSymbol Escape
	keycode 69 = Meta_R

	xev \| grep -A2 --line-buffered '^KeyRelease' \| sed -n '/keycode /s/^.keycode \([0-9]\).* (., \(.\)).*$/\1 \2/p'

	xmodmap -e "keycode 133 = Alt_L"
	xmodmap -e "keycode 37 = Control_L"
	xmodmap -e "keycode 64 = Control_L"