Skip to content

Instantly share code, notes, and snippets.

@Kartones
Kartones / postgres-cheatsheet.md
Last active May 16, 2024 12:40
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)

"POOR BILL"
2019-Nov-07

@teddyschleifer wrote:

"Bill Gates on a wealth tax:

'I've paid over $10 billion in taxes. I've paid more than anyone in taxes. If I had to pay $20 billion, it's fine.'

'But when you say I should pay $100 billion, then I'm starting to do a little math over what I have left over.'"

@robert-moore
robert-moore / README.md
Last active January 17, 2021 08:38
A New Pattern for Updatable D3.js Charts

Using a new updatable chart format. Update functions are made accessible to the caller, handing over chart controls with full functionality to the caller in a modular manner. Data binding is done with method chaining, like any other configuration variable, and can be changed after initialization. This allows for changes to be rendered in the context of chart history, leveraging D3's transitions and update logic.

@Lana-chan
Lana-chan / login.py
Created February 19, 2018 22:27
interactive script for generating persistent clientcred and usercred files for mastodon.py
#!/usr/bin/python3
# interactive script for generating persistent
# clientcred and usercred files for mastodon.py
from mastodon import Mastodon
from getpass import getpass
import sys
if __name__ == "__main__":