Skip to content

Instantly share code, notes, and snippets.

View Trolldemorted's full-sized avatar

Benedikt Radtke Trolldemorted

39 followers · 8 following
  • Berlin
View GitHub Profile
@Miesvanderlippe
Miesvanderlippe / user-data
Created May 1, 2020 12:19
Hack to enable true auto-install for Ubuntu 20.04 with cloud-init nocloud
#cloud-config
runcmd:
- [eval, 'echo $(cat /proc/cmdline) "autoinstall" > /root/cmdline']
- [eval, 'mount -n --bind -o ro /root/cmdline /proc/cmdline']
- [eval, 'snap restart subiquity.subiquity-service']
autoinstall:
version: 1
identity:
hostname: hack-nation
@adam-p
adam-p / Local PR test and merge.md
Last active September 18, 2025 16:14
Testing a pull request, then merging locally; and avoiding TOCTOU

It's not immediately obvious how to pull down the code for a PR and test it locally. But it's pretty easy. (This assumes you have a remote for the main repo named upstream.)

Getting the PR code

  1. Make note of the PR number. For example, Rod's latest is PR #37: Psiphon-Labs/psiphon-tunnel-core#37

  2. Fetch the PR's pseudo-branch (or bookmark or rev pointer whatever the word is), and give it a local branch name. Here we'll name it pr37:

$ git fetch upstream pull/37/head:pr37
@jmc734
jmc734 / php.patch
Last active May 14, 2016 11:55
--- php.original.xml 2014-12-06 16:28:15.000000000 -0500
+++ php.xml 2014-12-06 16:27:42.000000000 -0500
@@ -10331,6 +10331,7 @@
<Param name="[int options=PGSQL_DML_EXEC]"/>
</Overload>
</KeyWord>
+ <KeyWord name="php" func="no"/>
<KeyWord name="pg_version" func="yes">
<Overload retVal="array">
<Param name="[resource connection]"/>
@rxaviers
rxaviers / gist:7360908
Last active December 11, 2025 15:03
Complete list of github markdown emoji markup

People

:bowtie: :bowtie: 😄 :smile: 😆 :laughing:
😊 :blush: 😃 :smiley: ☺️ :relaxed:
😏 :smirk: 😍 :heart_eyes: 😘 :kissing_heart:
😚 :kissing_closed_eyes: 😳 :flushed: 😌 :relieved:
😆 :satisfied: 😁 :grin: 😉 :wink:
😜 :stuck_out_tongue_winking_eye: 😝 :stuck_out_tongue_closed_eyes: 😀 :grinning:
😗 :kissing: 😙 :kissing_smiling_eyes: 😛 :stuck_out_tongue:
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active December 5, 2025 09:56
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%'