Skip to content

Instantly share code, notes, and snippets.

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.
View gmail_bookmarklet.js
Gmail bookmarklet
For quickly e-mailing the current page's URL (and the selected text, if any)
via Gmail.
- 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 / 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 files
View titleUrlMarkdownClip.js
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 /
Created May 3, 2020 23:40 — forked from Kartones/
PostgreSQL command line cheatsheet


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 /
Created March 13, 2020 16:07 — forked from Garrett-R/
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:
bytes_obj = out.getvalue()
dsaiztc / queries.sql
Last active July 2, 2019 15:51 — forked from iconara/queries.sql
Low level Redshift cheat sheet
View queries.sql
-- Table information like sortkeys, unsorted percentage
-- see
SELECT * FROM svv_table_info;
-- Table sizes in GB
SELECT, COUNT(tbl) / 1000.0 AS gb
SELECT DISTINCT datname, id, name
FROM stv_tbl_perm
JOIN pg_database ON pg_database.oid = db_id
View redshift_table_change
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 (
View barcelona.geojson
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+

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