How to Use Named Variables with Postgres and PHP PDO Driver
You can write reusable scripts with Postgres by taking advantage of named variables.
A named variable starts with a `:` in your sql script. Here is an example
select :a_number
You can then use this statement with `psql` and the `--variable` fl...
Written by Sean Behan on 11/11/2017
Class
# Define a class with a class method "find"
# Usage
# Apple.find("macintosh")
class Apple
def self.find(variety)
# code goes here
end
end
# Same as above but notice the lack of self prefix before the method name
# Usage
# Apple.find("macin...
Written by Sean Behan on 06/17/2012
How to Boot Up Multiple Sinatra Applications at the Same Time with Foreman
Foreman is a process management gem for ruby applications. It is used in combination with a Procfile for configuration instructions.
A typical Procfile looks something like this
[name] : [script to execute]
Example Rack application Procfile
...
Written by Sean Behan on 10/15/2013
How to Just Get SQL Statement Error with SQLAlchemy Python Database Wrapper
If you're working with SQLAlchemy, the best database driver for Python, and want to see only SQL syntax errors, you need to use the StatementError exception class. On it, is an attribute `orig`, that contains just the SQL syntax error... and not any data...
Written by Sean Behan on 05/10/2018
summer 2008 picnic at tidal falls
Written by Sean Behan on 06/17/2012
