sydneyitguy

Index size/usage statistics

Table & index sizes along which indexes are being scanned and how many tuples are fetched. See Disk Usage for another view that includes both table and index sizes.

Works with PostgreSQL >=8.1

SELECT
    t.tablename,
    indexname,
    c.reltuples AS num_rows,

sydneyitguy

export const isChrome = function() {
  return /Chrome/.test(navigator.userAgent) && /Google Inc/.test(navigator.vendor);
}

export const detectExtension = function(extensionId, callback) {
  const xobj = new XMLHttpRequest();
  xobj.overrideMimeType("application/json");
  xobj.open('GET', 'chrome-extension://' + extensionId + '/manifest.json', true);
  xobj.onreadystatechange = function () {
    if (xobj.readyState === 4) {

sydneyitguy

Countries

• AW: Aruba
• AF: Afghanistan
• AO: Angola
• AI: Anguilla
• AX: Åland Islands
• AL: Albania
• AD: Andorra
• AE: United Arab Emirates
• AR: Argentina

sydneyitguy

sudo apt install wget ca-certificates
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'

psql --version

sudo apt update
sudo apt install postgresql-11
pg_lsclusters
sudo pg_dropcluster 11 main --stop

sydneyitguy

# Extracted from https://github.com/se3000/ruby-eth
#
# Dependencies:
# - gem 'digest-sha3'
# - gem 'rlp'
#
# Usage:
# - Eth::Utils.valid_address?('0x4Db7569F90bd836294B11c8b08B853d2de499Ced')
#   => true
# - Eth::Utils.format_address('0x4db7569f90bd836294b11c8b08b853d2de499ced')

sydneyitguy

const random_wait_time = (waitTime = 300) => new Promise((resolve, reject) => {
  setTimeout(() => {
    return resolve();
  }, Math.random() * waitTime);
});

const get_followers = async(userId, userFollowerCount) => {
  let userFollowers = [],
    batchCount = 20,
    actuallyFetched = 20,

sydneyitguy

rails new AppName -T -d=postgresql --skip-action-cable --skip-coffee --skip-spring --skip-turbolinks

sydneyitguy

# MARK: - System updates
sudo update-locale LANG=en_US.UTF-8 LANGUAGE= LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" LC_ALL=en_US.UTF-8
sudo locale-gen en_US.UTF-8
sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y dist-upgrade && sudo apt-get -y autoremove


git clone https://github.com/someguy123/steem-docker.git
cd ~/steem-docker
./run.sh dlblocks
./run.sh install_docker

sydneyitguy

#!/bin/sh
exec <"$0" || exit; read v; read v; exec /usr/bin/osascript - "$@"; exit
# The line above allows the rest of the file to be written in plain AppleScript.

repeat 99999999 times
  tell application "Google Chrome"
    activate
    tell application "System Events"
      tell process "Google Chrome"
        keystroke "r" using {command down, shift down}