Émilien (perso) unixfox

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

Proton VPN IPv6 Manual Setup

Over 80% of the servers support IPv6 but only the Linux app and the browser extension support it at the moment.

The Linux app supports IPv6 over the VPN but still connects to the VPN server using IPv4.

It's possible to make changes to the WireGuard configs that you can get from https://account.protonvpn.com/downloads to enable IPv6.

An easy way to test if a server supports IPv6 is to use the browser extension and then go to myip.wtf or test-ipv6.com.

Browser Based

Web Wormhole https://webwormhole.io/ https://github.com/saljam/webwormhole
ToffeeShare https://toffeeshare.com/
FilePizza https://file.pizza/
~~ShareDrop sharedrop.io https://github.com/szimek/sharedrop~~ (SOLD, not recommended, use one of the forks)
1. ~~A clone SnapDrop snapdrop.net https://github.com/RobinLinus/snapdrop~~ (SOLD, not recommended, use one of the forks)
  1. A fork PairDrop https://pairdrop.net/ https://github.com/schlagmichdoch/pairdrop
Instant.io https://instant.io/
FileTC https://file.tc/

PostgreSQL is Enough

Background and Cron Jobs

System parameter common to all googleapis for filtering fields

query parameter	header
`fields`	`X-Goog-FieldMask`

FieldMask contains a list of paths

Basics

Specify multiple field paths by seperating with a comma

Poor Man's Global Traffic Manager

Sometimes we need to add redundancy to some service or server which happen to be a public-facing entry point of our infrastructure. For example, imagine we want to add a high availability pair for a load balancer which sits on the edge of network and forwards traffic to alive backend servers.

                                             ┌─────────────┐
                                             │             │
                                      ┌─────►│  Backend 1  │
                                      │      │             │
                                      │      └─────────────┘

A way to install Alpine Linux on a Scaleway Stardust instance without the use of a rescue image, but by booting into the install image over the network using https://netboot.xyz.

Connect to the serial console, using scw instance server console {uuid} zone={zone}
Reboot the VM into UEFI settings
- either by executing systemctl reboot --firmware on the machine
- or by using scw instance server reboot {uuid} zone={zone} locally and repeatedly mashing the escape key on the serial console
Go to Device Manager -> Network Device List -> the only network device -> HTTP Boot Configuration -> Boot URI

	import http.client
	import http.cookies
	import json
	import base64
	import hashlib
	import os
	import random
	import argparse
	import time
	from cryptography.hazmat.primitives import serialization

 {
    "context":{
       "client":{
          "hl":"",
          "gl":"",
          "remoteHost":"1.2.3.4",
          "deviceId":"",
          "debugDeviceIdOverride":"",
          "experimentIds":[