Invisi

itsmefox / gw2-api-response.md

Last active November 25, 2023 11:48

GW2 API Error Codes

400:

{
  "text": "invalid key"
}

TerrorBite / gw2.py

Created December 15, 2016 09:07

This file was a work in progress

	import struct
	import crc32c
	import errno

	import gw2util

	# Headers
	gw2_header1 = struct.Struct("<B3sIII")
	gw2_header2 = struct.Struct("<IIQII")
	# GW1 header

rgreenjr / postgres_queries_and_commands.sql

Last active October 26, 2025 14:44

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'