Skip to content

Instantly share code, notes, and snippets.

View skatkov's full-sized avatar
🏠
Working from home

Stanislav (Stas) Katkov skatkov

🏠
Working from home
View GitHub Profile
@skatkov
skatkov / test.rb
Last active January 3, 2024 18:20
speed up testsuit by using unlogged tables in PG
# config/environments/test.rb
ActiveSupport.on_load(:active_record_postgresqladapter) do
# For this optimization to work, you need to recreate your test database
self.create_unlogged_tables = true
end
@skatkov
skatkov / schema.sql
Created September 2, 2022 18:21
contact book
CREATE TABLE people ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT NOT NULL, last_name TEXT, dob TEXT, name TEXT, photo TEXT, notes TEXT);
CREATE TABLE sqlite_sequence(name,seq);
CREATE TABLE IF NOT EXISTS "contacts" (
"id" integer NOT NULL,
"type" text NOT NULL CHECK(type in ('work', 'mobile', 'home', 'email')),
"value" text NOT NULL,
"people_id" integer NOT NULL,
PRIMARY KEY("id" AUTOINCREMENT),
FOREIGN KEY("people_id") REFERENCES "people"("id"),
UNIQUE("type","value")
@skatkov
skatkov / .ruby-version
Last active July 11, 2022 12:43
Benchmarking content-type and http_headers/content_type gems
2.7.6
FROM ghcr.io/renderinc/heroku-app-builder:heroku-20 AS builder
# The FROM statement above triggers the following steps
# 1. Copy the contents of the directory containing this Dockerfile to a Docker image
# 2. Detect the language
# 3. Build the app using the appropriate Heroku buildpack. All Heroku's official buildpacks are supported.
# For running the app, we use a clean base image and also one without Ubuntu development packages
# https://devcenter.heroku.com/articles/heroku-20-stack#heroku-20-docker-image
FROM ghcr.io/renderinc/heroku-app-runner:heroku-20 AS runner
@skatkov
skatkov / dep-extract.rb
Created October 12, 2020 12:10
extract Ruby dependencies
#!/usr/bin/env ruby
require 'bundler'
require 'csv'
lock_file = Bundler::LockfileParser.new(Bundler.read_file("Gemfile.lock"))
def url_for(spec)
case spec.source
when Bundler::Source::Rubygems
@skatkov
skatkov / ruby_data_object_comparison.rb
Last active September 17, 2020 12:24 — forked from palexander/ruby_data_object_comparison.rb
Benchmark to compare hash, OpenStruct, struct, and classes in Ruby
require 'ostruct'
require 'benchmark'
COUNT = 10_000_000
NAME = "Test Name"
EMAIL = "[email protected]"
class Person
def initialize(name:, email:)
@name = name
source 'https://rubygems.org'
git_source(:github) do |repo_name|
repo_name = "#{repo_name}/#{repo_name}" unless repo_name.include?("/")
"https://github.com/#{repo_name}.git"
end
ruby '2.6.6'
gem 'pronto'
@skatkov
skatkov / lefthook.yml
Created June 10, 2020 12:25
lefthook config
pre-commit:
parallel: true
commands:
eslint:
glob: "*.{js}"
run: yarn prettier --write {staged_files} && yarn eslint {staged_files} && git add {staged_files}
css:
glob: "*.{css}"
run: yarn prettier --write {staged_files} && git add {staged_files}
rubocop:
@skatkov
skatkov / bundle-checkinstall
Last active April 10, 2020 23:16
lefthook.yml
#!/bin/bash
BRANCH_CHANGE=$3
[[ $BRANCH_CHANGE -eq 0 ]] && exit
PREV_HEAD=$1
CURR_HEAD=$2
[ $PREV_HEAD == $CURR_HEAD ] && exit
# Don't run bundler if there were no changes in gems
@skatkov
skatkov / .env
Last active April 8, 2023 10:08
Progressive mailchimp subscription on Netlify
MAILCHIMP_API_KEY="...-us19"
MAILCHIMP_LIST_ID="..."