xiaolei everdance
everdance
/ postgres_queries_and_commands.sql
Created
February 15, 2024 15:59
— forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 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%' |
everdance
/ feature_upsell.json
Created
July 8, 2020 20:56
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "name": "1000 dvr", | |
| "type": "single", | |
| "group": "storage", | |
| "addon_codes": ["1000-dvr"], | |
| "price": 699, | |
| "description": "1000 dvr storage", | |
| "replaces": ["basic-dvr"] | |
| } |
everdance
/ gist:30dd23eae48bfe7e920e74fee0f3d8da
Last active
March 6, 2020 23:45
simple go emacs init
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (require 'package) | |
| (setq package-archives | |
| '(("gnu" . "https://elpa.gnu.org/packages/") | |
| ("melpa-stb" . "https://stable.melpa.org/packages/") | |
| ("melpa" . "https://melpa.org/packages/")) | |
| tls-checktrust t | |
| tls-program '("gnutls-cli --x509cafile %t -p %p %h") | |
| gnutls-verify-error t) | |
| (package-initialize) |
everdance
/ land_page.csv
Created
November 16, 2018 18:07
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| category | id | path | |
|---|---|---|---|
| league | 9524337 | /watch/xxx | |
| match | 16218622 | /watch/yyy |
everdance
/ black_out.csv
Last active
November 16, 2018 18:22
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| league_id | matches_excluded | |
|---|---|---|
| 16092084 | 16092623 16092636 | |
| 191260 | ||
| 7900709 | 16222396 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$": { | |
| "href": "" | |
| }, | |
| "account": { | |
| "$": { | |
| "href": "https://fubotv.recurly.com/v2/accounts/5bdb2049913ba56461567485" | |
| } | |
| }, | |
| "address": { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$": { | |
| "href": "" | |
| }, | |
| "account": { | |
| "$": { | |
| "href": "https://fubotv.recurly.com/v2/accounts/5bda406979b087753eb32f5b" | |
| } | |
| }, | |
| "address": { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ;;;; XIAOLEI'S .emacs file | |
| (setq user-full-name "Xiaolei liu") | |
| (setq user-mail-address "tristones.liu@gmail.com") | |
| (add-to-list 'load-path "~/.emacs.d/vendor") | |
| (require 'package) | |
| (add-to-list 'package-archives | |
| '("melpa" . "http://melpa.org/packages/") t) | |
| (package-initialize) |