Diego Kartones

## postgres-cheatsheet.md

      
              1 file
            
          
              1127 forks
            
          
              66 comments
            
          
              3490 stars
            
          
                Kartones
                / postgres-cheatsheet.md
            
            
              Last active
              May 3, 2024 20:51
            
              
                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)


## Win 10 Disable Forced Reboot After Update.bat
:checkPrivileges
NET FILE 1>NUL 2>NUL
if '%errorlevel%' == '0' ( goto gotPrivileges ) else ( goto getPrivileges )

:getPrivileges
if '%1'=='ELEV' (echo ELEV & shift /1 & goto gotPrivileges)

setlocal DisableDelayedExpansion
set "batchPath=%~0"
setlocal EnableDelayedExpansion

## Win 10 Disable Automatic Windows Updates.bat
:checkPrivileges
NET FILE 1>NUL 2>NUL
if '%errorlevel%' == '0' ( goto gotPrivileges ) else ( goto getPrivileges )

:getPrivileges
if '%1'=='ELEV' (echo ELEV & shift /1 & goto gotPrivileges)

setlocal DisableDelayedExpansion
set "batchPath=%~0"
setlocal EnableDelayedExpansion

## Win 10 Disable Automatic App Updates.bat
:checkPrivileges
NET FILE 1>NUL 2>NUL
if '%errorlevel%' == '0' ( goto gotPrivileges ) else ( goto getPrivileges )

:getPrivileges
if '%1'=='ELEV' (echo ELEV & shift /1 & goto gotPrivileges)

setlocal DisableDelayedExpansion
set "batchPath=%~0"
setlocal EnableDelayedExpansion

## mac-shortcuts.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Kartones
                / mac-shortcuts.md
            
            
              Last active
              December 20, 2023 18:37
            
              
                Mac Shorcuts (last used 2020)
              
          
    Moved to https://blog.kartones.net/page/macos-cheatsheet/

  
## image-and-video.md

      
              1 file
            
          
              2 forks
            
          
              1 comment
            
          
              7 stars
            
          
                Kartones
                / image-and-video.md
            
            
              Last active
              November 22, 2023 20:46
            
              
                image & video (Imagemagick, ffmpeg, webp...) commands
              
          
    Moved to https://blog.kartones.net/page/image-and-video-cli-cheatsheet/

  
## CURL-cheatsheet.md

      
              1 file
            
          
              20 forks
            
          
              0 comments
            
          
              36 stars
            
          
                Kartones
                / CURL-cheatsheet.md
            
            
              Last active
              November 8, 2023 23:16
            
              
                CURL Cheatsheet
              
          
    Moved to https://blog.kartones.net/page/curl-cheatsheet/

  
## statsd-local-server.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              9 stars
            
          
                Kartones
                / statsd-local-server.md
            
            
              Created
              August 19, 2015 09:55
            
              
                StatsD local server for testing
              
          
pip install pystatsd
python -c 'import pystatsd; pystatsd.Server(debug=True).serve()'
Config is localhost:8125


From https://pypi.python.org/pypi/pystatsd/
Kudos to @rochoa

  
## git-cheatsheet.md

      
              1 file
            
          
              17 forks
            
          
              1 comment
            
          
              26 stars
            
          
                Kartones
                / git-cheatsheet.md
            
            
              Last active
              February 7, 2023 21:44
            
              
                Git cheatsheet
              
          
    Moved to https://blog.kartones.net/page/git-cheatsheet/

  
## sublime-text-cheatsheet.md

      
              1 file
            
          
              5 forks
            
          
              0 comments
            
          
              8 stars
            
          
                Kartones
                / sublime-text-cheatsheet.md
            
            
              Last active
              January 18, 2021 17:43
            
              
                Sublime Text 3 Cheatsheet
              
          
    Keyboard shorcuts


CTRL + SHIFT + p: Command panel
CTRL + p: File search
CTRL + r: Method search inside current file
CTRL + g: Go to line #
CTRL + SHIFT + [: Fold code
CTRL + SHIFT + ]: Unfold code
ALT + SHIFT + 2: Double column/file mode
ALT + SHIFT + 1: Single column/file mode
	:checkPrivileges
	NET FILE 1>NUL 2>NUL
	if '%errorlevel%' == '0' ( goto gotPrivileges ) else ( goto getPrivileges )

	:getPrivileges
	if '%1'=='ELEV' (echo ELEV & shift /1 & goto gotPrivileges)

	setlocal DisableDelayedExpansion
	set "batchPath=%~0"
	setlocal EnableDelayedExpansion