| -- create the read-only role. | |
| create role if not exists YOUR_ROLE_NAME; | |
| -- allow the role to access a specific warehouse | |
| grant usage on warehouse YOUR_WAREHOUSE_NAME to role YOUR_ROLE_NAME; | |
| -- allow the role to access a specific schema (most likely public?) | |
| //grant usage on all schemas in database YOUR_DATABASE_NAME to role YOUR_ROLE_NAME; | |
| grant usage on schema PUBLIC to role YOUR_ROLE_NAME; | |
| # List databases | |
| sudo su postgres | |
| psql | |
| \list | |
| # Create a compressed backup | |
| sudo su postgres | |
| pg_dump -Fc <database_name> > <file> | |
| # Example |
🚨 2020 Update: I recommend using mkcert to generate local certificates. You can do everything below by just running the commands brew install mkcert and mkcert -install. Keep it simple!
This gives you that beautiful green lock in Chrome. I'm assuming you're putting your SSL documents in /etc/ssl, but you can put them anywhere and replace the references in the following commands. Tested successfully on Mac OS Sierra and High Sierra.
sudo nano /etc/ssl/localhost/localhost.conf
by Jonathan Rochkind, http://bibwild.wordpress.com
Capistrano automates pushing out a new version of your application to a deployment location.
I've been writing and deploying Rails apps for a while, but I avoided using Capistrano until recently. I've got a pretty simple one-host deployment, and even though everyone said Capistrano was great, every time I tried to get started I just got snowed under not being able to figure out exactly what I wanted to do, and figured I wasn't having that much trouble doing it "manually".
| class Api::RegistrationsController < Api::BaseController | |
| respond_to :json | |
| def create | |
| user = User.new(params[:user]) | |
| if user.save | |
| render :json=> user.as_json(:auth_token=>user.authentication_token, :email=>user.email), :status=>201 | |
| return | |
| else |
| # Ruby file to use the Google Prediction API, with a very hacked OAuth2 | |
| # You'll want to replace all the custom variables including.. | |
| # 1. Your google storage bucket name | |
| # 2. Your google storage access credentials (note that gstore only works with "legacy" google storage access so you'll need to enabled this) | |
| # 3. Your OAuth credentials which you setup from here https://code.google.com/apis/console/ by selecting "API Access" | |
| # Note that I choose "Create client ID" and then "Installed Application". | |
| # | |
| # This script is intended to be run as a regular background process (like a cron job) to process data. It has no access to a browser and no web server to expose a callback url. Hence the hacking of OAuth2. This seems completely wrong to me but I haven't gotten any other authentication with the API to work. If anyone knows a better way please post a comment! | |
| # |
| =begin | |
| Capistrano deployment email notifier for Rails 3 | |
| Do you need to send email notifications after application deployments? | |
| Christopher Sexton developed a Simple Capistrano email notifier for rails. You can find details at http://www.codeography.com/2010/03/24/simple-capistrano-email-notifier-for-rails.html. | |
| Here is Rails 3 port of the notifier. | |
| The notifier sends an email after application deployment has been completed. |
| // usage: | |
| // | |
| // TesseractOCR ocr = TesseractOCR(@"C:\bin\tesseract.exe"); | |
| // string result = ocr.OCRFromBitmap(bmp); | |
| // textBox1.Text = result; | |
| // | |
| using System; | |
| using System.IO; | |
| using System.Diagnostics; | |
| using System.Drawing; |
