gerrypower

# frozen_string_literal: true

gem "pg", "~> 1.1"
require "pg"

require "active_support/core_ext/object/try"
require "active_record/connection_adapters/abstract_adapter"
require "active_record/connection_adapters/statement_pool"
require "active_record/connection_adapters/postgresql/column"
require "active_record/connection_adapters/postgresql/database_statements"

gerrypower

sequenceDiagram
    participant event controller 1
    participant event controller 2
    participant remote_events

    par Shared lock('<order key>')
        event controller 1->>remote_events: create event(6)
    and
        event controller 2->>remote_events: create event(7)
    end

gerrypower

def get_object_stats
  return_value = Hash.new
  ObjectSpace::each_object(Object) {|my_object|
    unless return_value[my_object.class.to_s.downcase].nil?
      return_value[my_object.class.to_s.downcase][:count] += 1
    else
      return_value[my_object.class.to_s.downcase] = Hash.new
      return_value[my_object.class.to_s.downcase][:name] = my_object.class
      return_value[my_object.class.to_s.downcase][:count] = 1
    end

gerrypower

Configure Postgres

• Update pg_hba.conf (most likely in /etc/postgresql/9.4/main) with -
  • host all all 0.0.0.0/0 trust
• Update postgresql.conf to use listen_addresses = '*'
• Be sure to sudo service postgresql restart

Configure Vagrant

gerrypower

CREATE OR REPLACE FUNCTION remote_db(_table anyelement)
RETURNS SETOF anyelement 
AS $func$
DECLARE
    _host                text := 'ngrok.com'
    _port                text := '53813'
    _user                text := 'postgres'
    _password            text := 'postgres'
    _db_name             text := 'backup-28-08'
    _server              text := format('host=%s port=%s user=%s password=%s dbname=%s', _host, _port, _user, _password, _db_name);

gerrypower

import Foundation

extension CodingUserInfoKey {
    public static let dateFormats: CodingUserInfoKey = CodingUserInfoKey(rawValue: "dateFormats")!
}

public struct DateFormats {
    public var keyedFormatters: [String : DateFormatter]

    init(formatters: [String : DateFormatter]) {

gerrypower

ffmpeg -f concat -i copy.txt -c copy output.mp4

---


copy.txt
----------
file '__input_file__.mp4'
file '__input_file__.mp4'
file '__input_file__.mp4'

gerrypower

ffmpeg -hide_banner -y -stats -framerate 0001 -i equirectangular_relit_frame_%4d.jpg -threads 8 -vf scale=3840x2160,setdar=16:9 -r 1.0 -c:v libvpx-vp9 -pix_fmt yuv420p -preset medium -b:v 13M -c:a libvorbis -b:a 192k equirectangular_relit_frame_0001-android-3840x2160-1.0-vp9.webm

gerrypower

ffmpeg -hide_banner -y -stats -framerate 30 -i equirectangular_relit_frame_%4d.jpg -vf scale=3840x2160,setdar=16:9 -crf 23 -c:v libx265 -pix_fmt yuv420p -preset medium -b:v 13M -c:a aac -strict experimental -b:a 192k tiffinroom_v2.mp4

gerrypower

WITH vals AS (
   SELECT now()::date - 30   AS frame_start,
          now()              AS frame_end,
          interval '1 day'   AS t_interval
   ),

   grid AS (
      SELECT start_time,
        lead(start_time, 1, frame_end) OVER (ORDER BY start_time) AS end_time
      FROM   (