Lukas Menzel onemenzel

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

PostgreSQL is Enough

Background and Cron Jobs

The reverse turing test

I asked GPT-4 to come up with 10 questions to determine if the answerer was AI or human.

I provided my own answers for these questions and I also asked ChatGPT to answer them.

The result is that GPT-4 was able to correctly differentiate between AI and Human.

Guide: Run FreeBSD 13.1-RELEASE for ARM64 in QEMU on Apple Silicon Mac (MacBook Pro M1, etc) with HVF acceleration (Hypervisor.framework)

This guide was adapted from https://gist.github.com/niw/e4313b9c14e968764a52375da41b4278#running-ubuntu-server-for-arm64

Running FreeBSD 13.1-RELEASE for ARM64

Install Xcode from App Store or install Command Line Tools on your Mac running on Apple Silicon.

Opening and closing an SSH tunnel in a shell script the smart way

I recently had the following problem:

From an unattended shell script (called by Jenkins), run a command-line tool that accesses the MySQL database on another host.
That tool doesn't know that the database is on another host, plus the MySQL port on that host is firewalled and not accessible from other machines.

We didn't want to open the MySQL port to the network, but it's possible to SSH from the Jenkins machine to the MySQL machine. So, basically you would do something like

ssh -L 3306:localhost:3306 remotehost

	// I'm tired of extensions that automatically:
	// - show welcome pages / walkthroughs
	// - show release notes
	// - send telemetry
	// - recommend things
	//
	// This disables all of that stuff.
	// If you have more config, leave a comment so I can add it!!

	{

	;; SCCS I.D. %W% delta: %G% %U% date: %H% %T%

	;;;;; tablature-mode.el -- modes for editing guitar tablature in GNU emacs

	;; Contains chord-mode and lead-mode, both minor modes of tab-mode.

	;; Author: Mark R. Rubin <[email protected]>
	;; Version: 1.00
	;; Date: 9/20/93

	; 1 2 3 4 5 6 7
	;01234567890123456789012345678901234567890123456789012345678901234567890
	;=======================================================================
	;+---------------------------------------------------------------------+
	;\| \|
	;\| Example using brk() system call for dynamic memory allocations. \|
	;\| \|
	;\| DON'T CONFUSE that brk() used in C Function is different with brk() \|
	;\| systemcall (systemcall 45 for x86 ASM). \|
	;\| \|