I hereby claim:
- I am duydev on github.
- I am duydev (https://keybase.io/duydev) on keybase.
- I have a public key ASAAPrAWTn5gX1lvn9lJyczoDT5SvSkKYpxMchb7-dIV1Qo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
-- 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%' |
function trigger() { | |
var keyboardEvent = document.createEvent('KeyboardEvent'); | |
var initMethod = | |
typeof keyboardEvent.initKeyboardEvent !== 'undefined' | |
? 'initKeyboardEvent' | |
: 'initKeyEvent'; | |
keyboardEvent[initMethod]( | |
'keydown', // event type: keydown, keyup, keypress | |
true, // bubbles |
const user_id = document.cookie.split('c_user=')[1].split(';')[0]; | |
const fb_dtsg = document.querySelector("input[name='fb_dtsg']").value; | |
const data = | |
"source=SETTINGS_MENU&nctr%5B_mod%5D=pagelet_bluebar&__user=" + user_id + "&__a=1&fb_dtsg=" + fb_dtsg; | |
const xhr = new XMLHttpRequest(); | |
xhr.withCredentials = true; | |
xhr.addEventListener("readystatechange", function() { | |
if (this.readyState === 4) { |
# Backup | |
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
# Restore | |
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
{"lastUpload":"2019-06-29T18:33:36.500Z","extensionVersion":"v3.3.1"} |
Other people's projects:
My projects (tutorials are on my blog at http://maxoffsky.com):
public static IEnumerable<IEnumerable<T>> Split<T>(this T[] array, int size) | |
{ | |
for (var i = 0; i < (float)array.Length / size; i++) | |
{ | |
yield return array.Skip(i * size).Take(size); | |
} | |
} |