Skip to content

Instantly share code, notes, and snippets.

View gojimmypi's full-sized avatar

gojimmypi gojimmypi

View GitHub Profile
@gojimmypi
gojimmypi / TinyFPGA_WSL_Toolchain.sh
Last active March 25, 2019 12:06
TinyFPGA Verilog icestorm toolchain installer
#!/bin/bash
WORKSPACE=~/workspace
export TinyFPGA_COM=/dev/ttyS8
sudo ls # pause if copy/paste password prompt
# This WSL Ubuntu bash script will update the system, fetch all dependencies, and git clone
# all of the libraries for creating a picosoc RISC-V on the TinyFPGA with riscv-gnu-toolchain-rv32i toolchain,
# including icestorm, nextpnr (or arachne-pnr), yosys
#
@gojimmypi
gojimmypi / cmake-3.13.3-install.sh
Created January 18, 2019 00:19
cmake-3.13.3 install
#!/bin/bash
# see https://askubuntu.com/questions/610291/how-to-install-cmake-3-2-on-ubuntu
# see https://cmake.org/download/
# sudo apt-get remove cmake
cd ~/workspace/
sudo apt-get install build-essential
@gojimmypi
gojimmypi / wsl_lsusb_strace_output.txt
Created December 31, 2018 12:52
wsl: strace -o lsusb.strace -f lsusb
327 execve("/usr/bin/lsusb", ["lsusb"], [/* 19 vars */]) = 0
327 brk(NULL) = 0x13ba000
327 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
327 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
327 open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 3
327 fstat(3, {st_mode=S_IFREG|0644, st_size=45228, ...}) = 0
327 mmap(NULL, 45228, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fed18fa8000
327 close(3) = 0
327 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)
327 open("/lib/x86_64-linux-gnu/libusb-1.0.so.0", O_RDONLY|O_CLOEXEC) = 3
@gojimmypi
gojimmypi / search_all_tables.sql
Created September 7, 2018 17:24
Search all SQL tables for a specific value (useful for reverse engineering to find where data is stored in a database)
-- this stored proc will generate a list of SELECT statements to show the rows of all tables containing search results.
-- by gojimmypi
CREATE PROCEDURE dbo.proc_SEARCH_ALL_TABLES
@search_string as varchar(255), -- use exact text or SQL wildcards (e.g. '%XYZZY%')
@min_length as int = 0, -- give hints for performance, such as the minimum field size to search, or
@search_numeric as char(1) = 'N', -- could the data be in a numeric field?
@search_text as char(1) = 'Y', -- or perhaps the data could be in a text field?
@echo_output as varchar(8) = Null,
@debug_status as varchar(8) = Null
AS
@gojimmypi
gojimmypi / install_icestorm.sh
Last active December 14, 2018 22:03
icestorm FPGA install
#!/bin/bash
sudo apt-get update
sudo apt-get install build-essential clang bison flex libreadline-dev \
gawk tcl-dev libffi-dev git mercurial graphviz \
xdot pkg-config python python3 libftdi-dev
# RPi supplments needed:
@gojimmypi
gojimmypi / RPi-Upgrade
Last active July 2, 2018 21:27
Raspberry Pi Upgrade from wheezy to jessie to stretch
# In-place upghrade from wheezy to jessie
# https://raspberrypi.stackexchange.com/questions/27858/upgrade-to-raspbian-jessie
# https://raspberrypi.stackexchange.com/questions/80029/how-to-complete-upgrade-from-wheezy-to-stretch
# Backup any files which are important to you.
# Ensure there is plenty of disk space free df -h
# With your new or existing install:
sudo apt-get update
sudo iwlist wlan0
sudo nano /etc/wpa_supplicant/wpa_supplicant.conf
add:
network={
ssid="testing"
psk="testingPassword"
}
@gojimmypi
gojimmypi / git-delete.sh
Created June 22, 2018 23:50
Delete a git file
#!/bin/bash
git filter-branch --force --index-filter 'git rm --cached --ignore-unmatch FILE_TO_DELETE.TXT' --prune-empty --tag-name-filter cat -- --all
# see https://stackoverflow.com/questions/2004024/how-to-permanently-delete-a-file-stored-in-git
#
# "This command will run the entire history of every branch and tag, changing any commit that involved the file,
# and any commits afterwards. Commits that are empty afterwards (because they only changed the Rakefile) are removed entirely."
@gojimmypi
gojimmypi / icestorm toolchain
Created May 8, 2018 15:21
install FPGA icestorm toolchain (WSL Ubuntu)
# don't just copy & paste, there's a prompt for the first sudo command
sudo apt-get update
sudo apt-get install build-essential clang bison flex libreadline-dev \
gawk tcl-dev libffi-dev git mercurial graphviz \
xdot pkg-config python python3 libftdi-dev
# create workspace
mkdir -p ~/workspace
cd ~/workspace/
@gojimmypi
gojimmypi / add_cmd_prompt.reg
Created March 3, 2018 09:03
“Open with Command Prompt” when shift-right clicking in Explorer
Windows Registry Editor Version 5.00
; see https://superuser.com/questions/1201988/how-do-i-change-open-with-powershell-to-open-with-command-prompt-when-shift
; Command Prompt
[HKEY_CLASSES_ROOT\Directory\shell\01MenuCmd]
"MUIVerb"="Command Prompts"
"Icon"="cmd.exe"
"ExtendedSubCommandsKey"="Directory\\ContextMenus\\MenuCmd"