Skip to content

Instantly share code, notes, and snippets.

View jameswpierce's full-sized avatar

James Pierce jameswpierce

13 followers · 17 following
View GitHub Profile
@jameswpierce
jameswpierce / gist:2679166f48e203f034af814685e6e87f
Created September 17, 2023 20:21
bin/dev
#!/usr/bin/env sh
if ! gem list foreman -i --silent; then
echo "Installing foreman..."
gem install foreman
fi
exec foreman start -f Procfile.dev "$@"
@jameswpierce
jameswpierce / PostgreSQL_index_naming.rst
Created June 8, 2022 02:44 — forked from popravich/PostgreSQL_index_naming.rst
PostgreSQL index naming convention to remember

The standard names for indexes in PostgreSQL are:

{tablename}_{columnname(s)}_{suffix}

where the suffix is one of the following:

  • pkey for a Primary Key constraint;
  • key for a Unique constraint;
  • excl for an Exclusion constraint;
  • idx for any other kind of index;
@jameswpierce
jameswpierce / gist:4e684c4d0d0c5cc9393f9c211f14678e
Created July 9, 2021 00:12
keybase.md
### Keybase proof
I hereby claim:
* I am jameswpierce on github.
* I am jameswpierce (https://keybase.io/jameswpierce) on keybase.
* I have a public key ASABJUlv5Y4VYrJIzC0Jg45malZpk-nLFq3UW63NpTcdugo
To claim this, I am signing this object:
@jameswpierce
jameswpierce / index.html
Created October 4, 2020 19:18
JS Bin // source https://jsbin.com/mabotom
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pixi.js/5.1.3/pixi.min.js"></script>
</head>
<body>
@jameswpierce
jameswpierce / tmux_cheatsheet.markdown
Created February 11, 2020 16:27 — forked from henrik/tmux_cheatsheet.markdown
tmux cheatsheet

tmux cheatsheet

As configured in my dotfiles.

start new:

tmux

start new with session name:

@jameswpierce
jameswpierce / emoji_food.json
Created February 26, 2019 20:46
emoji food location
This file has been truncated, but you can view the full file.
[
{
"label": "🍤",
"coordinates": [
-73.9864,
40.73097
],
"weight": 1
},
{
@jameswpierce
jameswpierce / shellcolors.sublime-completions
Created December 18, 2015 21:59
{
"completions":
[
{ "trigger": "shellgrey", "contents": "\\x1b[39;49;10m" },
{ "trigger": "shellred", "contents": "\\x1b[39;31;10m" },
{ "trigger": "shellgreen", "contents": "\\x1b[39;32;10m" },
{ "trigger": "shellyellow", "contents": "\\x1b[39;33;10m" },
{ "trigger": "shellblue", "contents": "\\x1b[39;34;10m" },
{ "trigger": "shellmagenta", "contents": "\\x1b[39;35;10m" },
{ "trigger": "shellcyan", "contents": "\\x1b[39;36;10m" },