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); | |
| } | |
| } |