Command | Description |
---|---|
.backup ?DB? FILE | Backup DB (default "main") to FILE |
.bail ON | OFF | Stop after hitting an error. Default OFF |
.databases | List names and files of attached databases |
.dump ?TABLE? | Dump the database in an SQL text format. If TABLE specified, only dump tables matching LIKE pattern TABLE. |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env ruby | |
require 'mail' | |
Mail.defaults do | |
delivery_method :smtp, { :address => "email-smtp.us-east-1.amazonaws.com", | |
:port => 587, | |
:user_name => "YOUR_IAM_SMTP_USER_FOR_SES", | |
:password => "YOUR_VERY_LONG_PASSWORD", | |
:authentication => 'plain', |
A sample script for connecting to MS SQL Server database using Sequel ORM with the TinyTDS (FreeTDS) adapter.
#!/usr/bin/env ruby
require 'sequel'
require 'tiny_tds'
I hereby claim:
- I am albertico on github.
- I am albertico (https://keybase.io/albertico) on keybase.
- I have a public key whose fingerprint is 42E4 0469 E7C9 BE31 4B3D AFDC 7329 438E B0AD E560
To claim this, I am signing this object:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env ruby | |
require 'goliath' | |
class CORS | |
include Goliath::Rack::AsyncMiddleware | |
def post_process(env, status, headers, body) | |
headers['Access-Control-Allow-Origin'] = '*' | |
[status, headers, body] |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env ruby | |
require 'mail' | |
Mail.defaults do | |
delivery_method :smtp, { :address => "smtp.mandrillapp.com", | |
:port => 587, | |
:user_name => "YOUR_MANDRILL_USERNAME", | |
:password => "YOUR_API_KEY", | |
:authentication => 'plain', |