Skip to content

Instantly share code, notes, and snippets.

View jbhamilton's full-sized avatar

Bradley Hamilton jbhamilton

14 followers · 17 following
View GitHub Profile
@Chintan7027
Chintan7027 / currency-symbols.csv
Last active May 20, 2021 08:09 — forked from bzerangue/currency-symbols.xml
World currencies with their symbols in csv,JSON,sql and, xml
_code _unicode-decimal _unicode-hex __text
ALL 76, 101, 107 4c, 65, 6b Albania Lek
AFN 1547 60b Afghanistan Afghani
ARS 36 24 Argentina Peso
AWG 402 192 Aruba Guilder
AUD 36 24 Australia Dollar
AZN 1084, 1072, 1085 43c, 430, 43d Azerbaijan New Manat
BSD 36 24 Bahamas Dollar
BBD 36 24 Barbados Dollar
BYR 112, 46 70, 2e Belarus Ruble
@alojzije
alojzije / connectHTMLelements_SVG.png
Last active March 24, 2024 19:36
Connect two elements / draw a path between two elements with SVG path (using jQuery)
connectHTMLelements_SVG.png
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 1, 2024 13:31
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%'
@lukaslundgren
lukaslundgren / python27_on_debian.sh
Created May 11, 2012 12:58
How to install python 2.7 on debian
sudo apt-get install build-essential libsqlite3-dev zlib1g-dev libncurses5-dev libgdbm-dev libbz2-dev libreadline5-dev libssl-dev libdb-dev
wget http://www.python.org/ftp/python/2.7.3/Python-2.7.3.tgz
tar -xzf Python-2.7.3.tgz
cd Python-2.7.3
./configure --prefix=/usr --enable-shared
make
sudo make install
cd ..
@hgmnz
hgmnz / query_planner.markdown
Created March 23, 2011 14:14
PostgreSQL query plan and SQL performance notes

Types of index scans

Indexes

Sequential Scan:

  • Read every row in the table
  • No reading of index. Reading from indexes is also expensive.