Aidan Gannon aidangannon

🚩

wired in

Backend engineer, climate tech advocate 🍃

aidangannon / gist:f855d3762fe22d805032a9f8da506a76

Created August 19, 2025 18:21

commit_backdater.py

	#!/usr/bin/env python3
	import subprocess
	import random
	import os
	import tempfile
	from datetime import datetime, timedelta

	def main():

	# THREE WEEKS: May 5-25, 2025 (21 days)

aidangannon / lock-escalation.sql

Created March 6, 2022 17:20

	# transaction 1
	START TRANSACTION;
	LOCK TABLE User IN EXCLUSIVE MODE;
	INSERT INTO User (Name, Dob, Age) VALUES ('John', '10-10-1999', 24);
	UNLOCK TABLE User;
	COMMIT;

	# transaction 2
	START TRANSACTION;
	SELECT * FROM User WHERE ID = '1bd76753-f391-453d-bd98-a212789dd652' FOR UPDATE;

aidangannon / tcp-streams.cs

Created March 6, 2022 17:10

	var endpoint = new IPEndPoint( IPAddress.Loopback, 6000 );
	var server = new Socket( AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp );
	server.SetSocketOption( SocketOptionLevel.Tcp, SocketOptionName.KeepAlive, true );
	server.SetSocketOption( SocketOptionLevel.Tcp, SocketOptionName.TcpKeepAliveTime, 90 );
	server.SetSocketOption( SocketOptionLevel.Tcp, SocketOptionName.TcpKeepAliveInterval, 5 );
	server.SetSocketOption( SocketOptionLevel.Tcp, SocketOptionName.TcpKeepAliveRetryCount, 3 );
	server.Bind( endpoint );
	server.Listen( 1 );
	Task.Run( ( ) =>
	{

aidangannon / ray_tracer.py

Last active May 10, 2022 01:29

heuristic analysis of scene complexity

	import string
	from datetime import datetime
	from typing import Callable

	import bpy
	from bpy.types import Object
	from mathutils import Vector

	VECTOR_LENGTH = 5