Skip to content

Instantly share code, notes, and snippets.

View Teraskull's full-sized avatar
💻
Working from home

Anton Grouchtchak Teraskull

💻
Working from home
74 followers · 6 following
View GitHub Profile
@Kartones
Kartones / postgres-cheatsheet.md
Last active July 2, 2024 22:38
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)
@tkrotoff
tkrotoff / RemoveWin10DefaultApps.ps1
Last active April 6, 2024 01:52
Remove Windows 10 default apps
# See Remove default Apps from Windows 10 https://thomas.vanhoutte.be/miniblog/delete-windows-10-apps/
# See Debloat Windows 10 https://github.com/W4RH4WK/Debloat-Windows-10
# Command line to list all packages: Get-AppxPackage -AllUsers | Select Name, PackageFullName
Get-AppxPackage Microsoft.Windows.ParentalControls | Remove-AppxPackage
Get-AppxPackage Windows.ContactSupport | Remove-AppxPackage
Get-AppxPackage Microsoft.Xbox* | Remove-AppxPackage
Get-AppxPackage microsoft.windowscommunicationsapps | Remove-AppxPackage # Mail and Calendar
#Get-AppxPackage Microsoft.Windows.Photos | Remove-AppxPackage
Get-AppxPackage Microsoft.WindowsCamera | Remove-AppxPackage
@JKirchartz
JKirchartz / country
Created December 27, 2016 21:34
Gravity Forms' List of Countries (comma-delimited)
Afghanistan,
Albania,
Algeria,
American Samoa,
Andorra,
Angola,
Antigua and Barbuda,
Argentina,
Armenia,
Australia,
@suberb
suberb / elementaryos.md
Last active December 25, 2023 19:14
elementaryOS | Things To Do After Installing Elementary OS Loki [Best OS For Switching From Windows & Mac]

FIRST THING FIRST


  • Update OS
sudo apt-get update && sudo apt-get upgrade

@mauricesvay
mauricesvay / free-PBR-textures.md
Last active June 21, 2024 20:28
List of websites for free PBR textures
@Surendrajat
Surendrajat / elementaryos.md
Last active December 2, 2021 21:16 — forked from suberb/elementaryos.md
elementaryOS | Things I Do After Installing elementary OS Hera

First Things First

  • Enable PPA

     sudo apt update
 sudo apt install software-properties-common apt-transport-https curl

  • Install apt-fast [Yes! it's really fast]

    

    • 




  


  




    


          
    

      

        
        

          

              @JerryLokjianming
          

          

            
                JerryLokjianming
                / Crack Sublime Text Windows and Linux.md
            
            

              Last active
              July 5, 2024 19:54
            

              
                Crack Sublime Text 3.2.2 Build 3211 and Sublime Text 4 Alpha 4098 with Hex
              
          

        

      

        

  

      

    


How to Crack Sublime Text 3.2.2 Build 3211 with Hex Editor (Windows | Without License) ↓


    

  1. Download & Install Sublime Text 3.2.2 Build 3211
    2. 

  2. Visit https://hexed.it/
    3. 

  3. Open file select sublime_text.exe
    4. 

  4. Offset 0x8545: Original 84 -> 85
    5. 

  5. Offset 0x08FF19: Original 75 -> EB
    6. 

  6. Offset 0x1932C7: Original 75 -> 74 (remove UNREGISTERED in title bar, so no need to use a license)
    7. 




  


  




    


          
    

      

        
        

          

              @bradtraversy
          

          

            
                bradtraversy
                / mongodb_cheat_sheet.md
            
            

              Last active
              July 3, 2024 13:28
            

              
                MongoDB Cheat Sheet
              
          

        

      

        

  

      

    
MongoDB Cheat Sheet


Show All Databases


show dbs



Show Current Database



  


  




    


          
    

      

        
        

          

              @sharunkumar
          

          

            
                sharunkumar
                / adb-dns.bat
            
            

              Created
              February 7, 2020 07:08
            

              
                Enabling / Disabling private DNS in android via ADB
              
          

        

      

        

  

    
    


        



  


  

        

          
          rem to disable private dns
        

        

          
          adb shell settings put global private_dns_mode off
        

        

          
          

        

        

          
          rem to enable private dns with hostname (example with dns.adguard.com)
        

        

          
          adb shell settings put global private_dns_mode hostname
        

        

          
          adb shell settings put global private_dns_specifier dns.adguard.com
        

  





    


  




    


          
    

      

        
        

          

              @atc1441
          

          

            
                atc1441
                / Philips Sonicare NFC Password generation
            
            

              Last active
              June 16, 2024 12:33
            

          

        

      

        

  

    
    


        



  


  

        

          
          #include <stdio.h>
        

        

          
          #include <stdint.h>
        

        

          
          // Philips Sonicare NFC Head Password calculation by @atc1441 Video manual: https://www.youtube.com/watch?v=EPytrn8i8sc
        

        

          
          uint16_t CRC16(uint16_t crc, uint8_t *buffer, int len) // Default CRC16 Algo
        

        

          
          {
        

        

          
            while(len--)
        

        

          
            {
        

        

          
              crc ^= *buffer++ << 8;
        

        

          
              int bits = 0;
        

        

          
              do