Skip to content

Instantly share code, notes, and snippets.

Avatar

gojimmypi gojimmypi

View GitHub Profile
@gojimmypi
gojimmypi / Makefile
Created Feb 8, 2019
TinyFGPA Makefile for picosoc example created on WSL using arachne-pnr
View Makefile
version = 1.2
riscvbin = /opt/riscv32i/bin/
tinyFPGA_COM ?= /dev/ttyS8
upload: hardware.bin firmware.bin
sudo chmod 0666 $(tinyFPGA_COM)
tinyprog --com $(tinyFPGA_COM) -p hardware.bin -u firmware.bin
@gojimmypi
gojimmypi / Makefile
Last active Feb 8, 2019
TinyFGPA Makefile for picosoc example created on WSL using nextpnr
View Makefile
version = 1.2
riscvbin = /opt/riscv32i/bin/
tinyFPGA_COM ?= /dev/ttyS8
upload: hardware.bin firmware.bin
sudo chmod 0666 $(tinyFPGA_COM)
tinyprog --com $(tinyFPGA_COM) -p hardware.bin -u firmware.bin
hardware.blif: hardware.v spimemio.v simpleuart.v picosoc.v picorv32.v
@gojimmypi
gojimmypi / TinyFPGA_WSL_Toolchain.sh
Last active Mar 25, 2019
TinyFPGA Verilog icestorm toolchain installer
View TinyFPGA_WSL_Toolchain.sh
#!/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
#
View cmake-3.13.3-install.sh
#!/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 Dec 31, 2018
wsl: strace -o lsusb.strace -f lsusb
View wsl_lsusb_strace_output.txt
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 Sep 7, 2018
Search all SQL tables for a specific value (useful for reverse engineering to find where data is stored in a database)
View search_all_tables.sql
-- 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 Dec 14, 2018
icestorm FPGA install
View install_icestorm.sh
#!/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 Jul 2, 2018
Raspberry Pi Upgrade from wheezy to jessie to stretch
View RPi-Upgrade
# 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
View gist:017686b4e8b2681ade12fe6b8525e409
sudo iwlist wlan0
sudo nano /etc/wpa_supplicant/wpa_supplicant.conf
add:
network={
ssid="testing"
psk="testingPassword"
}
@gojimmypi
gojimmypi / git-delete.sh
Created Jun 22, 2018
Delete a git file
View git-delete.sh
#!/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."