Skip to content

Instantly share code, notes, and snippets.


Nate Ritter nateritter

View GitHub Profile
# Converts a mysqldump file into a Sqlite 3 compatible file. It also extracts the MySQL `KEY xxxxx` from the
# CREATE block and create them in separate commands _after_ all the INSERTs.
# Awk is choosen because it's fast and portable. You can use gawk, original awk or even the lightning fast mawk.
# The mysqldump file is traversed only once.
# Usage: $ ./mysql2sqlite mysqldump-opts db-name | sqlite3 database.sqlite
# Example: $ ./mysql2sqlite --no-data -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite

find . | grep .git | xargs rm -rf

nateritter / SemaphoreCI-PHPUnit-Codeception-Laravel5.3.txt
Last active Oct 25, 2016
SemaphoreCI setup for Laravel 5.3 + PHPUnit (unit, integration, API functional) + Codeception (acceptance) tests
View SemaphoreCI-PHPUnit-Codeception-Laravel5.3.txt
* NOTE: Earlier versions of this file used `php artisan serve`.
* However, Codeception and/or PhantomJS is not too fond of
* running that way for some reason. I ended up switching
* to Apache since that's what worked for all our devs
* locally. This script now includes how to get that
* setup properly. Please enjoy this responsibly.
* Assumptions:
* Using site5/phantoman to run phantomjs as the headless browser
nateritter / blockstack-verification
Created Apr 10, 2017
Verifying that "" is my Blockstack ID.
View blockstack-verification
Verifying that "" is my Blockstack ID.

Keybase proof

I hereby claim:

  • I am nateritter on github.
  • I am nateritter ( on keybase.
  • I have a public key ASDyOcfden9PCRYaj9zoHav_wy90hzrQHtGpPnXMLPgoWAo

To claim this, I am signing this object:

View gist:fbe411b039835c59a6c9d074c8995ef2
Verifying my Blockstack ID is secured with the address 17nLjB6jRaTKztxPS3bNRVswxLjhhyp4AQ
nateritter /
Last active Feb 15, 2021
Nate Ritter's personal principles

Here's the deal

  • These are in no particular order.
  • Principles are ideas by which we live.
  • Ideas are not sacred. Ideas change. Ideas are not people nor identification marks.
  • People change their value systems all the time.
  • Principles are an attempt to retain some version of consistency between contexts, thus simplifying one's life with generalities.
  • Specific instances may require these ideas to be adapted or thrown out entirely.
  • To be offended by an idea means you are offended by a magical, make believe thing. Don't be.
  • Get your own.
nateritter /
Created Mar 19, 2020
Interesting Questions for Remote Work Icebreakers

Interesting Questions for Remote Work Icebreakers

  • Who is your hero?
  • If you could live anywhere, where would it be?
  • What is your biggest fear?
  • What is your favorite family vacation?
  • What would you change about yourself if you could?
  • What is your favorite book to read?
  • What makes you laugh the most?
  • What was the last movie you watched? What did you think?
nateritter /
Last active Apr 13, 2020
Optimism: A Manifesto


A Manifesto by Trevor McKendrick (

  1. Focus your time & attention on the things you can influence.

  2. Do something today instead of daydreaming about tomorrow.

  3. See problems as opportunities to learn, grow, and give meaning to our lives.

nateritter / keybindings.json
Last active May 27, 2020
VSCode keybindings.json
View keybindings.json
* Activity Bar
"key": "cmd+k cmd+e",
"command": "workbench.view.explorer"
"key": "cmd+k cmd+v",