Skip to content

Instantly share code, notes, and snippets.

@dsaiztc
dsaiztc / gmail_bookmarklet.js
Created June 13, 2022 11:48 — forked from rondevera/gmail_bookmarklet.js
Gmail bookmarklet: For quickly e-mailing the current page's URL (and the selected text, if any) via Gmail.
/*
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
dsaiztc / titleUrlMarkdownClip.js
Created June 13, 2022 11:25 — forked from idelem/titleUrlMarkdownClip.js
Bookmarklet to copy current page title and url in Markdown format to clipboard, like [title](url) - Usual for posting links to resources in README.md files
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;
new Date().getTime();
@dsaiztc
dsaiztc / postgres-cheatsheet.md
Created May 3, 2020 23:40 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

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
dsaiztc / gzip_str.py
Created March 13, 2020 16:07 — forked from Garrett-R/gzip_str.py
Demo of how to gzip and gunzip a string in Python 3
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
dsaiztc / queries.sql
Last active July 2, 2019 15:51 — forked from iconara/queries.sql
Low level Redshift cheat sheet
-- 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
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
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
pipenv install cython
pipenv install git+https://github.com/jswhit/pyproj.git#egg=pyproj

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