Skip to content

Instantly share code, notes, and snippets.

View firebotQL's full-sized avatar
Always keep shipping

Viaceslavas Duk firebotQL

Always keep shipping
  • fire_bot
  • Chester
View GitHub Profile
All possible locales:
en-IE = €1,205.34
ro-MD = 1.205,34 MDL
br = ¤ 1 205,34
en-GY = $1,205
es-GT = Q1,205.34
shi-Tfng-M = 1 205,34MAD
@jimmywarting
jimmywarting / readme.md
Last active July 27, 2024 17:49
Cors proxies
Exposed headers
Service SSL status Response Type Allowed methods Allowed headers
@githoov
githoov / redshift_metadata.md
Last active September 21, 2022 01:57
Redshift Metadata

Redshift Tables Used

pg_table_def, stl_query, stl_querytext, stl_tr_conflict, stl_explain, stl_alert_event_log, stl_ddltext, stl_scan, stl_save, stl_hashjoin, stl_hash, stl_plan_info, stl_return, and information_schema.table_constraints.

Queries to Extract Features

  • execution time
select (endtime - starttime) as execution_time_in_ms 
from stl_query 
where query = QUERY_ID;
@astanush
astanush / gmail-filter-google-cal.md
Last active October 12, 2018 11:11
Gmail filter - Google Calendar notifications

Google Calendar notifications

Create a Gmail filter that will find all Google Calendar-related emails. I use it to apply a label to the emails so I can go and bulk delete them later.

(("invitation" OR "updated invitation" OR "declined" OR "canceled event") AND (-collaborate OR -"invitation to edit")) AND (has:attachment)

Notes

@graymouser
graymouser / hb_all_books_dl.js
Created February 28, 2016 14:09
Humble bundle book bundles - download all books at once
/*
After purchasing a humble book bundle, go to your download page for that bundle.
Open a console window for the page and paste in the below javascript
*/
$('a').each(function(i){
if ($.trim($(this).text()) == 'MOBI') {
$('body').append('<iframe id="dl_iframe_'+i+'" style="display:none;">');
document.getElementById('dl_iframe_'+i).src = $(this).data('web');
}
});
@lopezjurip
lopezjurip / README.md
Last active September 10, 2023 06:27
Write to NTFS on OSX Yosemite and El Capitan

OUTDATED, see comments below

Install Homebrew:

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Update Homebrew formulae:

brew update
@MikeRixWolfe
MikeRixWolfe / steamsales.py
Last active February 29, 2024 22:22
Steam Sales Checker (via Big Picture data feeds)
#!/usr/bin/env python
import json
import os
import requests
import time
debug = False
debug_path = 'debug'
@kgorman
kgorman / gist:134896c7414fde8e090b
Last active May 7, 2024 13:34
MongoDB Profiler Cheat Sheet
// a list of useful queries for profiler analysis. Starting with the most basic.
// 2.4 compatible
//
// output explained:
//
{
"ts" : ISODate("2012-09-14T16:34:00.010Z"), // date it occurred
"op" : "query", // the operation type
"ns" : "game.players", // the db and collection
@rtfpessoa
rtfpessoa / java-8-ami.md
Last active March 21, 2022 14:46
[Guide] Install Oracle Java (JDK) 8 on Amazon EC2 Ami
@tsiege
tsiege / The Technical Interview Cheat Sheet.md
Last active July 27, 2024 16:51
This is my technical interview cheat sheet. Feel free to fork it or do whatever you want with it. PLEASE let me know if there are any errors or if anything crucial is missing. I will add more links soon.

ANNOUNCEMENT

I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!






\