naranyala naranyala

Make Ubuntu packages 90% faster by rebuilding them

TL;DR

You can take the same source code package that Ubuntu uses to build jq, compile it again, and realize 90% better performance.

Setting

I use jq for processing GeoJSON files and other open data offered in JSON format. Today I am working with a 500MB GeoJSON file that contains the Alameda County Assessor's parcel map. I want to run a query that prints the city for every parcel worth more than a threshold amount. The program is

INSTALLATION GUIDE

Download packages

We borrow rpm packages from fedora 41, because we won't build all components ourselves. Download all packages using wget !

$ wget -ci packages.txt

PostgreSQL is Enough

Background and Cron Jobs

Building on Ubuntu 23.04

You have 2 options, use the script descrived bellow or follow the instrutions

script in this gist if you want the source code

wget https://gist.githubusercontent.com/Vertecedoc4545/6e54487f07a1888b656b656c0cdd9764/raw/2c5e8ccb428fc331307e2f653cab88174c051310/build-ubuntu-23.sh
chmod +x build-ubuntu-23.sh
./build-ubuntu-23.sh


	#!/usr/bin/env bash
	set -euo pipefail

	# chmod +x make-dotdesktop-for-nixpkgs.sh

	STORE_DIR="/nix/store"
	DESKTOP_DIR="$HOME/.local/share/applications"
	ICON_DIR="$HOME/.local/share/icons"
	LOG_FILE="$HOME/nix-desktopify.log"

	#!/usr/bin/env bash
	set -euo pipefail

	# chmod +x make-global-symlinks-nixpkgs.sh

	STORE_DIR="/nix/store"
	TARGET_DIR="/usr/bin"
	LOG_FILE="$HOME/nix-global-symlinks.log"
	LOG_PREFIX="\e[1;32m[LINK]\e[0m"
	SKIP_PREFIX="\e[1;33m[SKIP]\e[0m"

	#!/usr/bin/bash

	# make-snap-apps-visible.sh

	sudo cp /var/lib/snapd/desktop/applications/*.desktop /usr/share/applications/

	echo "[DONE] all snap packages visible!"

	✅ REALITY FILTER — CHATGPT

	• Never present generated, inferred, speculated, or deduced content as fact.
	• If you cannot verify something directly, say:
	- “I cannot verify this.”
	- “I do not have access to that information.”
	- “My knowledge base does not contain that.”
	• Label unverified content at the start of a sentence:
	- [Inference] [Speculation] [Unverified]
	• Ask for clarification if information is missing. Do not guess or fill gaps.

	import gg
	import gx
	import math
	import rand
	import sokol.audio
	import os.asset
	import sokol.sgl

	const designed_width = 600
	const designed_height = 800

	import os
	import re
	import subprocess
	import sys
	from pathlib import Path

	def clone_repo(repo_url, target_path="."):
	# Define patterns for GitHub, GitLab, and Codeberg URLs
	# Support both HTTPS and SSH-style URLs
	patterns = [