Skip to content

Instantly share code, notes, and snippets.

View dlachasse's full-sized avatar
🕴️
_

David La Chasse dlachasse

🕴️
_
View GitHub Profile
@dlachasse
dlachasse / large_redshift_tables.sql
Created May 23, 2019 17:02 — forked from subelsky/large_redshift_tables.sql
Quick SQL command to find large tables in redshift
-- based on http://stackoverflow.com/questions/21767780/how-to-find-size-of-database-schema-table-in-redshift
SELECT name AS table_name, ROUND((COUNT(*) / 1024.0),2) as "Size in Gigabytes"
FROM stv_blocklist
INNER JOIN
(SELECT DISTINCT id, name FROM stv_tbl_perm) names
ON names.id = stv_blocklist.tbl
GROUP BY name
ORDER BY "Size in Gigabytes" DESC
@dlachasse
dlachasse / comparison.md
Created October 7, 2016 16:18
Shipping comparison

Services

IBS

  • Lacking support
  • Inflexible
  • Cannot ship to unverified addresses

ShippingEasy

  • Requires use of slow interface and poor batching functionality
  • No international address validation

Keybase proof

I hereby claim:

  • I am dlachasse on github.
  • I am delicious (https://keybase.io/delicious) on keybase.
  • I have a public key whose fingerprint is 1A5D 9C16 F04C AF86 39B5 F9F9 8930 BBA5 CC8C 4C6F

To claim this, I am signing this object:

export PATH=$PATH:$HOME/bin:/usr/local/bin/npm
alias gcb='git checkout -b'
alias ..="cd .."
alias ...="cd ../.."
alias ....="cd ../../.."
alias .....="cd ../../../.."
[
{
"class": "sidebar_container",
"layer0.tint": [88,110,117],
"layer0.opacity": 1.0,
"layer0.draw_center": false,
"layer0.inner_margin": [0, 0, 1, 0],
"content_margin": [0, 0, 1, 0]
},
#Model
@user.should have(1).error_on(:username) # Checks whether there is an error in username
@user.errors[:username].should include("can't be blank") # check for the error message
#Rendering
response.should render_template(:index)
#Redirecting
response.should redirect_to(movies_path)