Charles FD freiden

Installing Postgres via Brew

Pre-Reqs

In your command-line run the following commands:

brew doctor
brew update

Installing `pg` gem on macOS

If you're trying to install the postgresql gem pg and it is failing with the following error message:

Installing pg 1.2.3 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

    current directory: ~/.rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/gems/pg-1.2.3/ext
~/.rbenv/versions/3.0.0/bin/ruby -I ~/.rbenv/versions/3.0.0/lib/ruby/3.0.0 -r ./siteconf20210125-97201-pycpo.rb extconf.rb

How to set up stress-free SSL on an OS X development machine

One of the best ways to reduce complexity (read: stress) in web development is to minimize the differences between your development and production environments. After being frustrated by attempts to unify the approach to SSL on my local machine and in production, I searched for a workflow that would make the protocol invisible to me between all environments.

Most workflows make the following compromises:

Use HTTPS in production but HTTP locally. This is annoying because it makes the environments inconsistent, and the protocol choices leak up into the stack. For example, your web application needs to understand the underlying protocol when using the secure flag for cookies. If you don't get this right, your HTTP development server won't be able to read the cookies it writes, or worse, your HTTPS production server could pass sensitive cookies over an insecure connection.
Use production SSL certificates locally. This is annoying

Project documentation

The project documentation (stored in the docs directory) is a git subtree of the project wiki. This allows for the documentation to be referenced and edited from within the main project.

Initial local setup

When cloning the main project repository for the first time, the wiki repository must be added as a remote.

git remote add wiki https://github.com//.wiki.git

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

	# gem 'rails'
	gem "activerecord"
	gem "actionpack"
	gem "actionview"
	gem "actionmailer"
	gem "activejob"
	gem "activesupport"
	gem "railties"
	gem "sprockets-rails"
	gem 'sqlite3'

	class RouteRecognizer
	attr_reader :paths

	# To use this inside your app, call:
	# `RouteRecognizer.new.initial_path_segments`
	# This returns an array, e.g.: ['assets','blog','team','faq','users']

	INITIAL_SEGMENT_REGEX = %r{^\/([^\/\(:]+)}

	def initialize

	# First the end result of what we want:

	class Foo
	before_hook :whoa
	before_hook :amazing

	def test
	puts "This is kinda cool!"
	end

	address=/.localhost/127.0.0.1
	address=/.test/127.0.0.1
	address=/.lvh.me/127.0.0.1