I optimize bulk anagram record creation from ~15 minutes (using the "naive" ActiveRecord approach) to ~10 seconds.
I'm making an app to practice for anagram games (think Scrabble, Words with Friends, etc.). Given a list of words, I need a way to quickly lookup anagrams that exist as words in that list.
I'll be using the TWL06 (tournament word list used for Scrabble in the US and Canada), which has ~180k words, stored as a .txt file separated with line breaks.
| # bin/rails | |
| # | |
| # drop the following into bin/rails to list files as they load -- useful for tracking down order dependency issues | |
| files = [] | |
| tp = TracePoint.new(:line) do |tp| | |
| if tp.path =~ /<repository_name>/ | |
| unless files.include? tp.path | |
| puts "#{tp.path}".inspect | |
| files.push(tp.path) |
Patch mode allows you to stage parts of a changed file, instead of the entire file. This allows you to make concise, well-crafted commits that make for an easier to read history. This feature can improve the quality of the commits. It also makes it easy to remove parts of the changes in a file that were only there for debugging purposes - prior to the commit without having to go back to the editor.
It allows you to see the changes (delta) to the code that you are trying to add, and lets you add them (or not) separately from each other using an interactive prompt. Here's how to use it:
from the command line, either use
| gem 'active_model_serializers' | |
| gem 'activeadmin' | |
| gem 'jquery-ui-rails' |
| #!/usr/bin/env ruby | |
| module HerokuImport | |
| class Db < Thor | |
| method_option :keep, :type => :boolean, :default => false | |
| method_option :remote, :type => :string, :default => "heroku" | |
| method_option :host, :type => :string, :default => "localhost" | |
| method_option :user, :type => :string, :default => `whoami`.strip | |
| method_option :dbname, :type => :string | |
| method_option :dump, :type => :string, :default => "latest.dump" |
| sass-convert -F scss -T sass application_styles.css.scss application_styles.css.sass |
| Get the Heroku db as detailed here: | |
| http://devcenter.heroku.com/articles/pgbackups#exporting_via_a_backup | |
| 1. heroku pgbackups:capture | |
| 2. heroku pgbackups:url <backup_num> #=>backup_url | |
| - get backup_num with cmd "heroku pgbackups" | |
| 3. curl -o latest.dump <backup_url> | |
| Then locally do: | |
| $ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump |
| =Navigating= | |
| visit('/projects') | |
| visit(post_comments_path(post)) | |
| =Clicking links and buttons= | |
| click_link('id-of-link') | |
| click_link('Link Text') | |
| click_button('Save') | |
| click('Link Text') # Click either a link or a button | |
| click('Button Value') |
