Adeel Ahmad realadeel

I'm hunting for the best solution on how to handle keeping large sets of DB records "sorted" in a performant manner.

Problem Description

Most of us have work on projects at some point where we have needed to have ordered lists of objects. Whether it be a to-do list sorted by priority, or a list of documents that a user can sort in whatever order they want.

A traditional approach for this on a Rails project is to use something like the acts_as_list gem, or something similar. These systems typically add some sort of "postion" or "sort order" column to each record, which is then used when querying out the records in a traditional order by position SQL query.

This approach seems to work fine for smaller datasets, but can be hard to manage on large data sets with hundreds (or thousands) of records needing to be sorted. Changing the sort position of even a single object will require updating every single record in the database that is in the same sort group. This requires potentially thousands of wri

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

Disclaimer: I'm super new to DynamoDB, so if you found I wrote something incorrect or stupid, just kindly send me a comment :)

Learn DynamoDB

database -> tables -> items -> attributes
db = a collection of tables

AWS query-instance_method docs

export AWS_ACCESS_KEY_ID=‘XXXX’
export AWS_SECRET_ACCESS_KEY=‘XXXX’

# ENV['AWS_ACCESS_KEY_ID']
# ENV['AWS_SECRET_ACCESS_KEY']

	# in spec/support/omniauth_macros.rb
	module OmniauthMacros
	def mock_auth_hash
	# The mock_auth configuration allows you to set per-provider (or default)
	# authentication hashes to return during integration testing.
	OmniAuth.config.mock_auth[:twitter] = {
	'provider' => 'twitter',
	'uid' => '123545',
	'user_info' => {
	'name' => 'mockuser',

	#!/usr/bin/ruby

	# This script acts as a command-line filter to convert a BSON file (such as from mongodump) to an equivalent JSON file
	# The resulting JSON file will be an array of hashes
	# Any binary values from the BSON file are converted to base64 (such as Mongo's _id fields)
	# I originally wrote this script so that Mongo files can be easily used with jsawk for
	# offline data processing -- https://github.com/micha/jsawk
	#
	# To invoke, assuming mycollection.bson is a file from mongodump:
	# ruby bson2json.rb < mycollection.bson > mycollection.json

	# This is a skeleton for testing models including examples of validations, callbacks,
	# scopes, instance & class methods, associations, and more.
	# Pick and choose what you want, as all models don't NEED to be tested at this depth.
	#
	# I'm always eager to hear new tips & suggestions as I'm still new to testing,
	# so if you have any, please share!
	#
	# @kyletcarlson
	#
	# This skeleton also assumes you're using the following gems:

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">

	<style>
	body {
	font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
	}

	group :production do
	gem 'unicorn'

	# Enable gzip compression on heroku, but don't compress images.
	gem 'heroku-deflater'

	# Heroku injects it if it's not in there already
	gem 'rails_12factor'
	end

	require 'rails_helper'

	RSpec.describe TodosController, :type => :controller do

	describe "GET #index" do
	#describe "POST #create" do
	#describe "GET #show" do
	#describe "PATCH #update" do (or PUT #update)
	#describe "DELETE #destroy" do
	#describe "GET #new" do