Jake Hamilton jakehamilton

I make things on the web.

jakehamilton / evolve_sync.js

Created December 29, 2023 05:29 — forked from Daxtorim/evolve_sync.js

Automatically synchronize EvolveIdle saves across devices

	// ==UserScript==
	// @name EvolveIdleSaveManager
	// @version 0.1
	// @description Automatically synchronize EvolveIdle saves across devices
	// @author Daxtorim
	// @match https://pmotschmann.github.io/Evolve/
	// @icon https://www.google.com/s2/favicons?sz=64&domain=github.io
	// @require https://code.jquery.com/jquery-3.7.0.min.js
	// @grant unsafeWindow
	// ==/UserScript==

jakehamilton / remove_old_builds.sql

Created March 29, 2021 19:54 — forked from david-zw-liu/remove_old_builds.sql

Keep 1000 builds per repos for DroneCI (sqlite3 version >= 3.25 required)

	-- Thank @sbengo to figure out foreign_keys constraints is defaults to false in sqlite
	-- Enable to delete logs by cascading delete
	PRAGMA foreign_keys = ON;

	WITH n_build_ids_per_repo as (
	SELECT build_id
	FROM (
	SELECT
	build_id,
	build_repo_id,

jakehamilton / remove_old_builds.sql

Created August 17, 2020 20:31

Keep 1000 builds per repos for DroneCI (sqlite3 version >= 3.25 required)

	-- Thank @sbengo to figure out foreign_keys constraints is defaults to false in sqlite
	-- Enable to delete logs by cascading delete
	PRAGMA foreign_keys = ON;

	WITH n_build_ids_per_repo as (
	SELECT build_id
	FROM (
	SELECT
	build_id,
	build_repo_id,