Nate Hopkins hopsoft

## README.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                hopsoft
                / README.md
            
            
              Last active
              August 8, 2019 23:02
            
              
                Create and publish an NPM package cheat sheet
              
          
Create an account on NPM https://www.npmjs.com


Init your project
mkdir example
cd example
yarn init


Create a JavaScript file


## install-ruby.sh
sudo apt-get update
sudo apt-get install libjemalloc-dev
RUBY_CONFIGURE_OPTS='--with-jemalloc' rbenv install 2.6.3

# test (look for jemalloc warnings)
MALLOC_CONF=invalid_flag:foo ruby -v

## README.md

      
              2 files
            
          
              2 forks
            
          
              0 comments
            
          
              1 star
            
          
                hopsoft
                / README.md
            
            
              Last active
              April 17, 2021 02:27
            
              
                Query the recommended column order for PostgreSQL tables
              
          
    Optimize PostgreSQL Data Storage

Simply ordering your table's columnns for more efficient datatype storage can save up to 30% of disk utilization.
https://blog.2ndquadrant.com/on-rocks-and-sand/

  
## gist:4944d9c9ef85c5adfa29034b90a86222
brew link libffi --force
export PKG_CONFIG_PATH="/usr/local/opt/libffi/lib/pkgconfig"
gem install ffi

## README.md

      
              3 files
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                hopsoft
                / README.md
            
            
              Last active
              April 19, 2019 09:31
            
              
                Eliminate unauthorized ActionCable connection attempts
              
          
    Problem

Unauthorized ActionCable connection attempts that produce the following

Successfully upgraded to WebSocket (REQUEST_METHOD: GET, HTTP_CONNECTION: Upgrade, HTTP_UPGRADE: websocket)
Finished "/cable/" [WebSocket] for 127.0.0.1 at 2018-11-16 08:32:24 -0700
An unauthorized connection attempt was rejected


## prefetch.js
const hoverTime = 400
const fetchers = {}
const doc = document.implementation.createHTMLDocument('prefetch')

function fetchPage (url, success) {
  const xhr = new XMLHttpRequest()
  xhr.open('GET', url)
  xhr.setRequestHeader('VND.PREFETCH', 'true')
  xhr.setRequestHeader('Accept', 'text/html')
  xhr.onreadystatechange = () => {

## assignable_job.rb
class AssignableJob < ApplicationRecord
  has_many :assignments, as: :record, dependent: :destroy

  scope :assigned, -> do
    subquery = Assignment.where(record_type: name).where(Assignment.arel_table[:record_id].eq(arel_table[:id])).select(Assignment.arel_table[Arel.star].count)
    where "(#{subquery.to_sql}) > 0" # TODO: move to Arel & remove string interpolation
  end
end

## users.yml
<% 100.times do |i| %>
user_<%= i %>:
  id: <%= SecureRandom.uuid %>
  first_name: <%= Faker::Name.first_name %>
  last_name: <%= Faker::Name.last_name %>
  email: <%= Faker::Internet.email %>
  phone: <%= Faker::PhoneNumber.cell_phone %>
<% end %>

## action_controller_parameters.rb
module ActionControllerParameters
  def filtered
    filter_hash self.to_unsafe_hash
  end

  private

  def filterer
    @filterer ||= ActionDispatch::Http::ParameterFilter.new(Rails.application.config.filter_parameters)
  end

## model_supports_bulk_updates.rb
# frozen_string_literal: true
module ModelSupportsBulkUpdates
  extend ActiveSupport::Concern

  module ClassMethods

    # Performs a bulk update with an efficient single query for all the records in the list.
    # Note that the records are not reloaded form the database.
    # This means that ActiveRecord will still see these records as dirty after the bulk_update.
    def bulk_update(records)
	sudo apt-get update
	sudo apt-get install libjemalloc-dev
	RUBY_CONFIGURE_OPTS='--with-jemalloc' rbenv install 2.6.3

	# test (look for jemalloc warnings)
	MALLOC_CONF=invalid_flag:foo ruby -v
	brew link libffi --force
	export PKG_CONFIG_PATH="/usr/local/opt/libffi/lib/pkgconfig"
	gem install ffi
	const hoverTime = 400
	const fetchers = {}
	const doc = document.implementation.createHTMLDocument('prefetch')

	function fetchPage (url, success) {
	const xhr = new XMLHttpRequest()
	xhr.open('GET', url)
	xhr.setRequestHeader('VND.PREFETCH', 'true')
	xhr.setRequestHeader('Accept', 'text/html')
	xhr.onreadystatechange = () => {
	class AssignableJob < ApplicationRecord
	has_many :assignments, as: :record, dependent: :destroy

	scope :assigned, -> do
	subquery = Assignment.where(record_type: name).where(Assignment.arel_table[:record_id].eq(arel_table[:id])).select(Assignment.arel_table[Arel.star].count)
	where "(#{subquery.to_sql}) > 0" # TODO: move to Arel & remove string interpolation
	end
	end
	<% 100.times do \|i\| %>
	user_<%= i %>:
	id: <%= SecureRandom.uuid %>
	first_name: <%= Faker::Name.first_name %>
	last_name: <%= Faker::Name.last_name %>
	email: <%= Faker::Internet.email %>
	phone: <%= Faker::PhoneNumber.cell_phone %>
	<% end %>
	module ActionControllerParameters
	def filtered
	filter_hash self.to_unsafe_hash
	end

	private

	def filterer
	@filterer \|\|= ActionDispatch::Http::ParameterFilter.new(Rails.application.config.filter_parameters)
	end
	# frozen_string_literal: true
	module ModelSupportsBulkUpdates
	extend ActiveSupport::Concern

	module ClassMethods

	# Performs a bulk update with an efficient single query for all the records in the list.
	# Note that the records are not reloaded form the database.
	# This means that ActiveRecord will still see these records as dirty after the bulk_update.
	def bulk_update(records)