sahidursuman

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

sahidursuman

# encoding: UTF-8

module ApplicationHelper
  # ...
  
  def concat_content_tag(*args, &blk)
    concat content_tag(*args, &blk)
  end
end

sahidursuman

# config/locales/en.yml

en:
  exception:
    show:
      not_found:
        title: "Not Found"
        description: "The page you were looking for does not exists."
      internal_server_error:
        title: "Internal Server Error"

sahidursuman

#Scoped Invitation System for User Groups with Rails#

Starting out with the following models and associations:

####User

• has_many :memberships
• has_many :organizations through :memberships

####Organization (User Group)

• has_many :memberships

sahidursuman

#app/views/businesses/_form.html.erb
<%= form_with(model: business, scope: :business, local: true, :html => {multipart: true}) do |form| %>

    <div class="row">
      
      <div class="col-md-12">
        <%= form.file_field :logo_image, id: :business_logo_image %>
        <%= form.label :logo_image, class: 'upload' do %>
          <i class="material-icons">file_upload</i>
          <span>Choose image</span>

sahidursuman

class Client < ActiveRecord::Base
  has_many :projects

  scope :active, -> { where(active: true) }
end

class Project < ActiveRecord::Model
  belongs_to :client

  scope :active, -> {

sahidursuman

http://stackoverflow.com/questions/22667401/postgres-json-data-type-rails-query
http://stackoverflow.com/questions/40702813/query-on-postgres-json-array-field-in-rails

#payload: [{"kind"=>"person"}]
Segment.where("payload @> ?", [{kind: "person"}].to_json)

#data: {"interest"=>["music", "movies", "programming"]}
Segment.where("data @> ?",  {"interest": ["music", "movies", "programming"]}.to_json)
Segment.where("data #>> '{interest, 1}' = 'movies' ")
Segment.where("jsonb_array_length(data->'interest') > 1")

sahidursuman

1. Get You a Hug, Every Friday

FridayHug.com http://fridayhug.com

2. Run From a Single File

The Smallest Rails App http://thesmallestrailsapp.com

%w(action_controller/railtie coderay).each &method(:require)

sahidursuman

1. Get You a Hug, Every Friday

FridayHug.com http://fridayhug.com

2. Run From a Single File

The Smallest Rails App http://thesmallestrailsapp.com

%w(action_controller/railtie coderay).each &method(:require)

sahidursuman

root# apt-get update
root# apt-get upgrade

// dependencies for Ruby
root# apt-get install -y git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev \
  libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties libffi-dev \
  libpcre3-dev unzip

// Node.js v7
root# curl -sL https://deb.nodesource.com/setup_7.x | sudo -E bash -