Skip to content

Instantly share code, notes, and snippets.

View noma4i's full-sized avatar
💭
🦑 Daily Kraken

Alexander Tsirel noma4i

💭
🦑 Daily Kraken
74 followers · 40 following
View GitHub Profile
@noma4i
noma4i / (OK method 1 --best--) sqlite.to.mysql.migration.procedure
Created September 12, 2016 02:20 — forked from toni-moreno/(OK method 1 --best--) sqlite.to.mysql.migration.procedure
Graphite SQLite to MySQL migration
0.- Stop graphite-web
/etc/init.d/apache2 stop
1.- Backup SQLite db
export GRAPHITE_ROOT=/opt/graphite
PYTHONPATH=$GRAPHITE_ROOT/webapp django-admin.py dumpdata --settings=graphite.settings -e contenttypes --natural > sqlite_graphite_dump.json
@noma4i
noma4i / deploy.rb
Created September 16, 2016 09:55 — forked from Kr00lIX/deploy.rb
Deploy Phoenix Elixir by mina
require 'mina/bundler'
require 'mina/git'
require 'mina/rbenv'
set :domain, 'your_domain.com'
set :deploy_to, '/home/deployer/app_name'
set :repository, 'git@github.com:user_name/app_name'
set :branch, ENV["brunch"] || 'master'
set :app_name, "app_name"
@noma4i
noma4i / find_broken_asset.rb
Created October 11, 2016 00:54
Snippet to find any broken asset which can lead to ExecJS punc error
JS_PATH = "app/assets/javascripts/**/*.js";
Dir[JS_PATH].each do |file_name|
puts "\n#{file_name}"
puts Uglifier.compile(File.read(file_name))
end
@noma4i
noma4i / init.lua
Created October 19, 2016 04:31
hammerspoon config
-- Settings
hs.window.animationDuration = 0
hs.hints.showTitleThresh = 0
--
-- Reload Config onChange
function reloadConfig(files)
doReload = false
for _,file in pairs(files) do
if file:sub(-4) == ".lua" then
@noma4i
noma4i / keybase.md
Created February 5, 2017 02:49

Keybase proof

I hereby claim:

  • I am noma4i on github.
  • I am noma4i (https://keybase.io/noma4i) on keybase.
  • I have a public key ASCtcIlOl0oZfkDAz8sj_-f4j27Cn_3KcwAoxqgBpq_2IQo

To claim this, I am signing this object:

@noma4i
noma4i / Dockerfile
Created December 12, 2017 00:16 — forked from renatosousafilho/Dockerfile
Deploy com Mina, Docker e Docker Compose
FROM rails:4.2.3
MAINTAINER Renato Filho <renatosousafilho@gmail.com>
ENV HOME /home/app
ENV RAILS_ENV development
RUN useradd -m -s /bin/bash app
RUN gem install -N bundler
@noma4i
noma4i / rails_ar_bug.rb
Created February 7, 2018 00:07
Rails 5.1.5 AR uses 3 queries to destroy 2 records
# frozen_string_literal: true
begin
require 'bundler/inline'
rescue LoadError => e
warn 'Bundler version 1.10 or later is required. Please update your Bundler'
raise e
end
gemfile(true) do
@noma4i
noma4i / postgres_queries_and_commands.sql
Created August 21, 2018 04:57 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@noma4i
noma4i / rw_ro_access.sql
Created September 7, 2018 00:17 — forked from checco/rw_ro_access.sql
How to create a read only user in AWS RDS PostgreSQL and a user with superuser privileges on AWS RDS PostgreSQL
--
-- Read only
--
-- Create a group
CREATE ROLE postgres_ro_group;
-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO postgres_ro_group;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO postgres_ro_group;
@noma4i
noma4i / README.md
Created September 19, 2018 03:35 — forked from mahemoff/README.md
MySQL thread-safe multi-database switching in Rails 5

The code here is a tech demo showing how to switch between databases in Rails 5, in a thread-safe manner.

BACKGROUND: HOW NOT TO CHANGE DATABASES

The simple way to switch databases is:

ActiveRecord::Base.establish_connection :user_shard1
puts User.find(1) # this is executed on the database keyed on "user_shard1" in database.yml
ActiveRecord::Base.establish_connection :development