Skip to content

Instantly share code, notes, and snippets.

CREATE TEMPORARY TABLE newer_states (
state_id INTEGER NOT NULL,
entity_id VARCHAR(255),
state INTEGER,
last_updated INTEGER,
PRIMARY KEY (state_id)
);
CREATE INDEX ix_entity_id ON newer_states (entity_id);
INSERT INTO newer_states
SELECT state_id, entity_id, CAST(state AS INTEGER), CAST(STRFTIME('%s', last_updated) AS INTEGER)
@endrift
endrift / make-dotcode.py
Created February 20, 2020 07:58
e-Reader Dotcode Generator
import numpy as np
import PIL.Image
import PIL.ImageChops
import sys
with open(sys.argv[1], 'rb') as f:
data = f.read()
size = len(data)
blocksize = 104
@endrift
endrift / gbalink-decoder.py
Created February 8, 2019 18:08
GBA link cable logic analyzer decoder
@endrift
endrift / hid-rev.c
Last active September 29, 2018 15:30
#include <string.h>
#include <stdio.h>
#include <switch.h>
int main(int argc, char **argv) {
struct HidController controller[9];
gfxInitDefault();
socketInitializeDefault();
@endrift
endrift / disasm-ge.py
Created November 17, 2016 23:44
PSP Graphics Engine disassembler
#!/usr/bin/env python
import struct
import sys
class Instruction:
def __init__(self, name, *args):
self.name = name
self.operands = args
@endrift
endrift / mgba-index-screenshots.py
Created October 29, 2016 00:05
Let's take screenshots of a bunch of games.
import mgba.core
import mgba.image
import mgba.log
import os, os.path
import sys
from concurrent.futures import ThreadPoolExecutor
logger = mgba.log.NullLogger()
@endrift
endrift / golfed.py
Created October 15, 2016 01:22
mGBA Python bindings example
from mgba import core,image
c=core.loadPath('ruby.gba')
i=image.Image(*c.desiredVideoDimensions())
c.setVideoBuffer(i)
c.reset()
for x in range(800): c.runFrame()
with open("out.png", "w") as f: i.savePNG(f)
@endrift
endrift / gist:7b96e35fceb5e935227c
Last active August 29, 2015 14:17
clang bad constant folding
#include <stdio.h>
#include <limits.h>
// gcc detects the weirdness, clang does not!
// Try different optimization levels, architectures and OSes for more fun.
int main() {
// Unclobberred arguement
printf("%x\n", INT_MIN / -1);
// Unclobbered variable
@endrift
endrift / gst-stream.sh
Last active August 29, 2015 14:04
GStreamer-based web video streamer for Freescale i.MX6
#!/bin/sh
# Stream video from your Freescale i.MX6 device (e.g. CuBox-i, Hummingboard, Wandboard, UDOO)
# Pass it a URL that `youtube-dl` can handle, or pass it as a player to `livestreamer`.
# Currently only works with MP4 streaming h.264 video and AAC audio.
#
# Requires:
# - gstreamer >= 1.2
# - gst-plugins-good
# - gst-plugins-bad
# - gstreamer-imx (https://github.com/Freescale/gstreamer-imx)
@endrift
endrift / mandelbrot.hs
Created December 21, 2011 05:19
Haskell Mandelbrot
import Data.Complex
import Data.Bits
import Data.Binary.Put
import qualified Data.ByteString.Lazy as BL
import Data.Word
import System.IO
import Control.Exception
import Char
import Ix