dsaiztc

/*
Gmail bookmarklet
rondevera.com

For quickly e-mailing the current page's URL (and the selected text, if any)
via Gmail.

Usage:
- Create a new item in your bookmark bar with the name "Gmail" (or just "Gm",
  or your favorite Unicode character), and the code below as the location.

dsaiztc

javascript:(function() {

function copyToClipboard(text) {
    if (window.clipboardData && window.clipboardData.setData) {
        /*IE specific code path to prevent textarea being shown while dialog is visible.*/
        return clipboardData.setData("Text", text); 

    } else if (document.queryCommandSupported && document.queryCommandSupported("copy")) {
        var textarea = document.createElement("textarea");
        textarea.textContent = text;

dsaiztc

new Date().getTime();

dsaiztc

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

dsaiztc

import gzip
import io

def gzip_str(string_):
    out = io.BytesIO()

    with gzip.GzipFile(fileobj=out, mode='w') as fo:
        fo.write(string_.encode())

    bytes_obj = out.getvalue()

dsaiztc

-- Table information like sortkeys, unsorted percentage
-- see http://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html
SELECT * FROM svv_table_info;

-- Table sizes in GB
SELECT t.name, COUNT(tbl) / 1000.0 AS gb
FROM (
  SELECT DISTINCT datname, id, name
  FROM stv_tbl_perm
  JOIN pg_database ON pg_database.oid = db_id

dsaiztc

START TRANSACTION ;

ALTER TABLE schema_name.table_name RENAME TO table_name_old;

CREATE TABLE schema_name.table_name_new
-- Creation statement
;

INSERT INTO schema_name.table_name_new (
  SELECT

dsaiztc

dsaiztc

pipenv install cython
pipenv install git+https://github.com/jswhit/pyproj.git#egg=pyproj

dsaiztc

One thing you can do from the command line is activate the virtual environment then install the kernel specification from within the environment:

python -m ipykernel install --user --name some-env --display-name "Python (some-env)"

ipython kernelspec list