Skip to content

Instantly share code, notes, and snippets.

@rattboi
rattboi / convert-datetime.py
Created August 2, 2021 06:32
Data Engineering scripts
import sqlite3
from datetime import datetime
con = sqlite3.connect('project.db')
cur = con.cursor()
count = 0
for row in cur.execute("SELECT timestamp FROM scrobbles").fetchall():
(timestamp,) = row
@rattboi
rattboi / gist:9c116eb26197712af1fde5bbbe3973f3
Created August 6, 2020 16:29
build-gcc-sh-elf-9.3.0-pass2.log
This file has been truncated, but you can view the full file.
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking target system type... sh-unknown-elf
checking for a BSD-compatible install... /usr/bin/install -c
checking whether ln works... yes
checking whether ln -s works... yes
checking for a sed that does not truncate output... /usr/bin/sed
checking for gawk... gawk
checking for libatomic support... no
checking for libitm support... no
Reading symbols from ./target08...done. │ ~
(gdb) run < <(./attack08) │ ~
Starting program: /home/bkanyid/introsec-labs/lab03/target08 < <(./attack08) │ ~
How old are you? │ ~
What is your name? │ ~
What is your favorite color?
@rattboi
rattboi / gist:602bf1eea0e1077553482e6ecda4aff7
Created January 7, 2019 23:06
Switch Games to check out
Wonder Boy - Dragon's Trap
Octopath
Little Nightmares
Axiom Verge
Ikaruga
Yonder
Enter the Gungeon
Atomic Run Gun Jump Gun
SNK 40th Anniversary
Bloodstained Curse of the Moon
Micro-feedback and millennials
Dan Lake
Millennial Specialist at Lead Coach Release
Karmabot is on the forefront of the digital micro-feedback revolution. The Millennial and Gen Z workforce wants feedback with recency, consistency, and the opportunity to improve. Acknowledge performance in realtime and unleash what’s possible for your team’s performance, motivation, and growth.
“Karmabot helps me reward my team and implement a recognition system into our organisation. It’s fantastic.” 
— Kenny Kiet Nguyen, President of the Minority Architecture Students organisation
M-LVG8WN :: code/personal/main_mister_rs ‹master› % docker run -it --rm -v ${PWD}:/source yasuyuky/rust-arm 101 ↵
Unable to find image 'yasuyuky/rust-arm:latest' locally
latest: Pulling from yasuyuky/rust-arm
bc9ab73e5b14: Already exists
193a6306c92a: Already exists
e5c3f8c317dc: Already exists
a587a86c9dcb: Already exists
72744d0a318b: Already exists
34e052c2087a: Pull complete
fcd7dcb423d9: Pull complete
#!/usr/bin/env python
from __future__ import print_function
import sys
import struct
if len(sys.argv) != 4:
print("Invalid # of arguments")
print("{} <input rbf> <output rbf> <output bin>".format(sys.argv[0]))
# ls /media/fat
_Arcade linux MiSTer
config menu.rbf 'System Volume Information'
# mkdir /media/fat/_Cores/
# ./MiSTer-bootstrap -t <apikey> -o /media/fat/_Cores/
Found newer version for C64_MiSTer: 5d7331f949b5332c25f09f9befdc53e2219bdcd2
Found newer version for BK0011M_MiSTer: 661e7933706619dd60e13da7de4b6430220f6abc
Found newer version for ZX-Spectrum_MISTer: 5fb5b0e5764d2ce6fbf3ad0f8ae80c017d5ea6db
Found newer version for SAM-Coupe_MiSTer: 78c404333f09a42163ddedd12586a61999fbcf77
Found newer version for Menu_MiSTer: 6fa105fa1f53a7e986fe4862eb14a168a88568c4
# ./MiSTer-bootstrap -t <apikey> -o .
Found newer version for C64_MiSTer: 5d7331f949b5332c25f09f9befdc53e2219bdcd2
panic: Put error: tx not writable
goroutine 1 [running]:
main.main()
/my/laptop/code/personal/MiSTer-bootstrap/main.go:123 +0x930
#
# ./MiSTer-bootstrap -t <token>
panic: Get https://api.github.com/orgs/MiSTer-devel/repos?per_page=500: x509: certificate signed by unknown authority
goroutine 1 [running]:
main.main()
/my/laptop/code/personal/MiSTer-bootstrap/main.go:72 +0x868
#