Skip to content

Instantly share code, notes, and snippets.

@ssavva05
ssavva05 / mysql_query_log.md
Last active April 29, 2020 10:39 — forked from joseluisq/mysql_query_log.md
How to enable the MySQL/MariaDB general query logs

How to enable the MySQL/MariaDB general query logs

  1. Enter to MySQL/MariaDB server command-line tool (change root with your username and password):
mysql -u root -proot
  1. Set the general log file path:
SET GLOBAL general_log_file='/var/log/mysql/mycustom.log';
@ssavva05
ssavva05 / gist:4699064d979c807b96ed8d3d78cfb282
Created May 20, 2020 10:10 — forked from psayre23/gist:c30a821239f4818b0709
Runtime Complexity of Java Collections
Below are the Big O performance of common functions of different Java Collections.
List | Add | Remove | Get | Contains | Next | Data Structure
---------------------|------|--------|------|----------|------|---------------
ArrayList | O(1) | O(n) | O(1) | O(n) | O(1) | Array
LinkedList | O(1) | O(1) | O(n) | O(n) | O(1) | Linked List
CopyOnWriteArrayList | O(n) | O(n) | O(1) | O(n) | O(1) | Array
@ssavva05
ssavva05 / generate-ssh-key.sh
Created June 22, 2020 11:36 — forked from grenade/01-generate-ed25519-ssh-key.sh
Correct file permissions for ssh keys and config.
ssh-keygen -t rsa -b 4096 -N '' -C "[email protected]" -f ~/.ssh/id_rsa
ssh-keygen -t rsa -b 4096 -N '' -C "[email protected]" -f ~/.ssh/github_rsa
ssh-keygen -t rsa -b 4096 -N '' -C "[email protected]" -f ~/.ssh/mozilla_rsa
@ssavva05
ssavva05 / fix_exfat_drive.md
Created July 27, 2020 16:58 — forked from scottopell/fix_exfat_drive.md
Fix corrupted exFAT disk macOS/OSX

exFAT support on macOS seems to have some bugs because my external drives with exFAT formatting will randomly get corrupted.

Disk Utility is unable to repair this at first, but the fix is this:

  1. Use diskutil list to find the right drive id.
  2. You want the id under the IDENTIFIER column, it should look like disk1s1
  3. Run sudo fsck_exfat -d <id from above>. eg sudo fsck_exfat -d disk1s3
  4. -d is debug so you'll see all your files output as they're processed.
  5. Answer YES if it gives you the prompt Main boot region needs to be updated. Yes/No?
@ssavva05
ssavva05 / cmd-colors.reg
Created December 5, 2020 23:52 — forked from Zantier/cmd-colors.reg
Registry file: Add WSL Ubuntu Bash to the context menu of folders in File Explorer.
Windows Registry Editor Version 5.00
; Delete directories under HKEY_CURRENT_USER\Console, then run this
; Examples: https://gist.github.com/P4/4245793
[HKEY_CURRENT_USER\Console]
"WindowAlpha"=dword:000000cd
"DefaultBackground"=dword:00000000
; black dgray
"ColorTable00"=dword:00141414
List with Compatible devices:
Look under About on the watch for the device Id.
looks something like this:
MOY-TEH5-1.7.7
the middle section is the interesting part, if that is in this list here
it has the compatible bootloader and the same pinout as pinetime for Display and External Flash
@ssavva05
ssavva05 / UpdateProtocolDafit.txt
Created December 9, 2020 10:59 — forked from atc1441/UpdateProtocolDafit.txt
DaFit App Update Protocol manual
Basic Manual for DaFit Fitness Tracker firmware update protocol, works for nearly any nRF52832 tracker from Company DaFit
The minimum size of update file is 0x10000(can be filled with garbage to get to size) and the maximum size is 0x2F000
the update will first get stored onto the external flash at position 0x3D1000 by the stock firmware(not by the bootloader)
the size of the update will get stored at 0x3D0000 on external flash with 4 bytes uint32_t
when bootloader gets activated it will copy the update from external flash to 0x23000 of the nRF52 internal flash.
Connect to device,
@ssavva05
ssavva05 / OpenVPN on Docker and Raspberry Pi.md
Created January 17, 2021 21:08 — forked from odarriba/OpenVPN on Docker and Raspberry Pi.md
How to install OpenVPN with Docker on Raspberry Pi

First of all, we are going to store all the data in a Docker shared volume, called openvpn_data.

To initialise the OpenVPN configuration and CA:

$ docker run -v openvpn_data:/etc/openvpn --rm evolvedm/openvpn-rpi ovpn_genconfig -u udp://your-vpn.address.com
$ docker run -v openvpn_data:/etc/openvpn --rm -it evolvedm/openvpn-rpi ovpn_initpki

To start daemon (and auto-restart it):

@ssavva05
ssavva05 / Final Cut Pro Trial DMG
Created February 6, 2021 01:52 — forked from b0gdanw/Final Cut Pro Trial DMG
Direct links for Final Cut Pro Trial DMGs
Final Cut Pro 10.1.3
https://secure-appldnld.apple.com/Final_Cut_Pro_X/031-05296.20140814.VRR4r/FinalCutProTrial10.1.3.dmg
Final Cut Pro 10.1.4
https://secure-appldnld.apple.com/Final_Cut_Pro_X/031-02980.20141202.Jgt44/FinalCutProTrial10.1.4.dmg
Final Cut Pro 10.2
https://secure-appldnld.apple.com/Final_Cut_Pro_X/031-08830.20150413.HPPE4/FinalCutProTrial10.2.dmg
Final Cut Pro 10.2.2
@ssavva05
ssavva05 / tar-gz-reader.go
Created February 12, 2021 09:31 — forked from indraniel/tar-gz-reader.go
Reading through a tar.gz file in Go / golang
package main
import (
"archive/tar"
"compress/gzip"
"flag"
"fmt"
"io"
"os"
)