| # apt install postgresql-client | |
| # apt-get -y install bash-completion wget | |
| # wget --no-check-certificate --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add - | |
| # echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list | |
| # apt-get update | |
| # apt-get -y install postgresql-client-12 | |
| namespace :db do | |
| desc "Dumps the database to backups" |
| @binkmail.com | |
| @bobmail.info | |
| @chammy.info | |
| @devnullmail.com | |
| @letthemeatspam.com | |
| @mailinater.com | |
| @mailinator.net | |
| @mailinator2.com | |
| @notmailinator.com | |
| @reallymymail.com |
| @binkmail.com | |
| @bobmail.info | |
| @chammy.info | |
| @devnullmail.com | |
| @letthemeatspam.com | |
| @mailinater.com | |
| @mailinator.net | |
| @mailinator2.com | |
| @notmailinator.com | |
| @reallymymail.com |
This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.
No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!
I chose [pgloader][1] because it's extremely fast. YMMV.
mysql2 gem with pg in Gemfile.config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.
| require 'socket' | |
| require 'json' | |
| class AircraftPositionStream | |
| def initialize host, port | |
| @host = host | |
| @port = port | |
| end |
| /** | |
| * Chrome-Last.fm-Scrobbler - Saavn.com Connector | |
| * | |
| * Author: Vikas Kumar [vikas@cs.umn.edu] | |
| * Derived from Sitesh Shrivastava code on gaana.js | |
| */ | |
| // DOM Nodes to keep track for song details | |
| var SONG_TRACK_DOM = '#player-track-name'; | |
| var SONG_ALBUM_DOM = '#player-album-name'; |
| namespace :db do desc "Backup database to AWS-S3" | |
| task :backup => [:environment] do | |
| datestamp = Time.now.strftime("%Y-%m-%d_%H-%M-%S") | |
| backup_filename = "#{Rails.root.basename}-#{datestamp}.sql" | |
| db_config = ActiveRecord::Base.configurations[Rails.env] | |
| # process backup | |
| `mysqldump -u #{db_config['username']} -p#{db_config['password']} -i -c -q #{db_config['database']} > tmp/#{backup_filename}` | |
| `gzip -9 tmp/#{backup_filename}` | |
| puts "Created backup: #{backup_filename}" |
| # = Icebox : Caching for HTTParty | |
| # | |
| # First stab at implementing caching for HTTParty (http://github.com/jnunemaker/httparty/) | |
| # Modeled after Martyn Loughran's APICache (http://github.com/newbamboo/api_cache/) | |
| # | |
| # = Usage | |
| # 1. <tt>include Icebox</tt> in YourPartyAnimalClass | |
| # 2. Use <tt>YourPartyAnimalClass.get_cached()</tt> instead of simple <tt>get()</tt> | |
| require 'logger' |