Skip to content

Instantly share code, notes, and snippets.

View Revadike's full-sized avatar
🌐
Coding

Revadike Revadike

🌐
Coding
View GitHub Profile
@Revadike
Revadike / issues.md
Last active June 17, 2026 20:25
List of Bugs missing from Known Issues (WIP)

It's sad to see Destiny 2 reach the end of its journey. The final content update has already arrived, but Bungie is still releasing smaller maintenance patches, and as the list below shows, there is still plenty of work to be done. More than anything, I want the game to be left in a healthy, polished state, and here's hoping the important issues can be fixed before support comes to an end for good. If anything, this can serve as a record of the state of the game at the end of its life.

Furthermore, I'd like to thank Bungie for addressing many of the issues from last time! It's genuinely appreciated, and it's great to see these reports leading to fixes!

That said, some issues still haven't been addressed, and new ones have emerged or been discovered. This is an updated, and likely fin

@Revadike
Revadike / instructions.md
Last active April 29, 2025 13:11
Cron csv procedure

1. prerequisites

  • pg_cron extension installed and enabled (superuser)
  • your target tables have RLS policies using auth.uid()/auth.jwt()

/**
* PostgreSQL Schema to JSON Schema Converter
* Exports database schema and converts it to JSON Schema format compatible with AJV
*/
import { toJSON } from 'pg-json-schema-export';
import { writeFileSync } from 'fs';
/**
* Convert PostgreSQL database schema to JSON Schema
@Revadike
Revadike / free_steam_emoticons.user.js
Created April 16, 2024 08:12
Free Steam Emoticons
// ==UserScript==
// @name Free Steam Emoticons
// @namespace revadike
// @version 0.1
// @description Continuously requests Steam store search results and checks if total results are divisible by 100 or if no new results are found.
// @author revadike
// @match https://steam.tools/emoticons*
// @icon https://www.google.com/s2/favicons?sz=64&domain=steam.tools
// @grant GM_xmlhttpRequest
// @grant GM_setValue
{"data":{"Catalog":{"searchStore":{"elements":[{"title":"City of Brass","id":"ac2f9bdeb022454aab1ff77b59b2f3ed","namespace":"fa234e40c4d44dfa84fbcb302fef0233","description":"Become a daring thief in City of Brass, a first-person action adventure from senior BioShock developers. Armed with scimitar and a versatile whip, you’ll lash and slash, bait and trap your way to the heart of an opulent, Arabian Nights-themed metropolis – or face certain deat...","effectiveDate":"2019-05-28T15:00:00.000Z","offerType":"BASE_GAME","expiryDate":null,"status":"ACTIVE","isCodeRedemptionOnly":false,"keyImages":[{"type":"DieselStoreFrontWide","url":"https://cdn1.epicgames.com/undefined/offer/EGS_DEVELOPER_CITYOFBRASS_S1_DESCRIPTION-2560x1440-3e755e7016659f4e23e513a4042fb61e.jpg"},{"type":"DieselStoreFrontTall","url":"https://cdn1.epicgames.com/undefined/offer/EGS_DEVELOPER_CITYOFBRASS_S3_DESCRIPTION-1280x1440-b700c2cc1193dd2ef3906ca918c9d627.jpg"},{"type":"DieselGameBoxLogo","url":"https://cdn1.epicgames.com/epic/offer/EGS_DEVE
@Revadike
Revadike / steamtrades_users.json
Created August 24, 2018 14:12
SteamTrades Users JSON
[
{
"steamid": "76561198105197441",
"name": "SirIronMaiden",
"reputation": {
"positive": 2817,
"negative": 0
}
},
{
@Revadike
Revadike / licenses.json
Created January 10, 2018 18:59
My steam licenses (10-01-2018)
This file has been truncated, but you can view the full file.
[
{
"package_id": 182,
"time_created": 1316883771,
"time_next_process": 0,
"minute_limit": 0,
"minutes_used": 0,
"payment_method": 1,
"flags": 512,
"purchase_country_code": "NL",