Skip to content

Instantly share code, notes, and snippets.

Avatar

Daniel Gonçalves danielgoncalves

  • Base4 Sistemas
  • Catanduva/SP
  • Twitter @spanazzi
View GitHub Profile
@danielgoncalves
danielgoncalves / postgres-cheatsheet.md
Created Jan 22, 2020 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet
View postgres-cheatsheet.md

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)
@danielgoncalves
danielgoncalves / git-apply-patch.md
Created Feb 21, 2020 — forked from emmanueltissera/git-apply-patch.md
Generate a git patch for a specific commit
View git-apply-patch.md

Creating the patch

git format-patch -1 <sha>
OR
git format-patch -1 HEAD

Applying the patch

git apply --stat file.patch # show stats.
git apply --check file.patch # check for error before applying

@danielgoncalves
danielgoncalves / lazy_qs_demo.py
Last active Oct 9, 2020 — forked from jsbueno/lazyquicksort.py
Lazy sorter - an iterator that yields items in sorted order, lazily
View lazy_qs_demo.py
import random
import string
from lazyquicksort import lazy_sort
def chars(length):
options = string.ascii_lowercase
return ''.join([random.choice(options) for i in range(length)])
View installing_pyenv_on_ubuntu_based_distros.md

Tested only on Ubuntu 20.04, KDE Neon User Edition (based on Ubuntu 20.04) and OSX Mojave.

will probably work on other newer versions, with no changes, or with few changes in non-python dependencies (apt-get packages)

NOTE: Don't create a .sh file and run it all at once. It will not work. Copy, paste, and execute each command below manually. :-)

Ubuntu

# DO NOT RUN THIS AS A ROOT USER
@danielgoncalves
danielgoncalves / responsive_example.py
Created Jan 17, 2022 — forked from tshirtman/responsive_example.py
Making a simple responsive app layout.
View responsive_example.py
from kivy.app import App
from kivy.lang import Builder
from kivy.properties import OptionProperty
from kivy.core.window import Window
from kivy.factory import Factory
KV = '''
#:import A kivy.animation.Animation
<RLabel@Label>: