Skip to content

Instantly share code, notes, and snippets.

View ftrvxmtrx's full-sized avatar

Sigrid Solveig Haflínudóttir ftrvxmtrx

View GitHub Profile
-- Fast SQL as-of join (Postgres version), contributed by Rand Merchant Bank e-Quant team
-- Kabelo Masemola, Paul Jacot-Guillarmod, Michael Stephanou
-- Rand Merchant Bank does not make any representations or give any warranties as to the correctness, accuracy or completeness of the included code; nor does Rand Merchant Bank assume liability for any losses arising from errors or omissions in the code.
-- Create tables
CREATE TABLE table1 ( time timestamptz, val double precision);
CREATE TABLE table2 ( time timestamptz, val double precision);
-- Create aggregate functions
@mohrezaei
mohrezaei / Calyx-Magisk.md
Last active August 31, 2024 13:58
CalyxOS with Magisk with working signed images and AVB Verity

CalyxOS with Magisk with working signed images and AVB Verity

This idea was inspired by this post topjohnwu/Magisk#509 (comment)

I got this working with CalyxOS 2.11.0 (Android 11) with full AVB Verity enabled and was able to lock the bootloader after flashing and still have su.

Create a working build

First, make sure you can build and sign a proper CalyxOS for your device. This is probably the hardest part.

Prepare Magisk files for rooting

@cellularmitosis
cellularmitosis / README.md
Last active June 23, 2025 04:31
QEMU PowerPC G4 OS X Tiger (10.4) setup

Blog 2020/5/7

<- previous | index | next ->

QEMU PowerPC G4 OS X Tiger (10.4) setup

EDIT 2024/12/1: I updated a few of these commands to work with qemu 9.x.