Skip to content

Instantly share code, notes, and snippets.

View shmdt's full-sized avatar
💭
🇺🇦

Kovalenko Anton shmdt

💭
🇺🇦
View GitHub Profile
@ruslan-oliinyk
ruslan-oliinyk / deploy_with_kamal.md
Last active September 20, 2024 20:30
Deploy Rails app with Kamal

Deploying a Rails app to cloud services using Docker and Kamal (a library for deploying apps containerized with Docker).

https://kamal-deploy.org/

1. Create a new app

rails new APP_NAME -d postgresql -j esbuild -c bootstrap --skip-test

cd APP_NAME
@ruslan-oliinyk
ruslan-oliinyk / env_variables.md
Last active May 27, 2021 10:08
How to use the same variables inside Ruby ​​and JS code at the same time

How to use the same variables inside Ruby and JS code at the same time

Prerequisites:

  • Ruby 2.3+
  • Rails 5.1+
  • Webpacker 4.x.x
  • Node.js 8.16.0+
  • Yarn 1.x+
@VasylShevchenko
VasylShevchenko / 1 SETUP Ubuntu 20.04 LTS (DigitalOcean)
Last active September 22, 2023 19:31
Deploy Rails to VPS(Ubuntu 20.04LTS). Nginx mainline + pagespeed, Puma with Jungle, Capistrano3, PostgreSQL, RVM, Certbot
//------ ROOT --------
root# apt-get update
root# apt-get upgrade
// Dependencies
apt-get install -y git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev \
libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev software-properties-common libffi-dev \
libpcre3-dev unzip htop zip
@giannisp
giannisp / gist:ebaca117ac9e44231421f04e7796d5ca
Last active July 14, 2024 18:27
Upgrade PostgreSQL 9.6.5 to 10.0 using Homebrew (macOS)
After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work.
The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0."
Database files have to be updated before starting the server, here are the steps that had to be followed:
# need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default
brew unlink postgresql
brew install postgresql@9.6
brew unlink postgresql@9.6
brew link postgresql
@PavloBezpalov
PavloBezpalov / 1 setup vps
Last active August 19, 2024 15:09
Deploy Rails 5.1.1 to VPS(Ubuntu 16.04.2 LTS). Nginx mainline + pagespeed, Puma with Jungle, Capistrano3, PostgreSQL 9.6, RVM, Certbot
root# apt-get update
root# apt-get upgrade
// dependencies for Ruby
root# apt-get install -y git-core curl zlib1g-dev build-essential libssl-dev libreadline-dev libyaml-dev \
libsqlite3-dev sqlite3 libxml2-dev libxslt1-dev libcurl4-openssl-dev python-software-properties libffi-dev \
libpcre3-dev unzip
// Node.js v7
root# curl -sL https://deb.nodesource.com/setup_7.x | sudo -E bash -
@shmdt
shmdt / 1 Gist conventions
Created March 24, 2017 07:49 — forked from PavloBezpalov/1 Gist conventions
Deploy Rails 5.0.0.beta3 to VPS(Ubuntu 14.04.4 LTS). Nginx, Puma, Capistrano3, PostgreSQL, RVM.
<<APP>> change this variables
@mankind
mankind / rails-jsonb-queries
Last active July 30, 2024 05:01
Ruby on Rails-5 postgresql-9.6 jsonb queries
http://stackoverflow.com/questions/22667401/postgres-json-data-type-rails-query
http://stackoverflow.com/questions/40702813/query-on-postgres-json-array-field-in-rails
#payload: [{"kind"=>"person"}]
Segment.where("payload @> ?", [{kind: "person"}].to_json)
#data: {"interest"=>["music", "movies", "programming"]}
Segment.where("data @> ?", {"interest": ["music", "movies", "programming"]}.to_json)
Segment.where("data #>> '{interest, 1}' = 'movies' ")
Segment.where("jsonb_array_length(data->'interest') > 1")
@shmdt
shmdt / pg_hba.conf
Last active March 24, 2017 07:43 — forked from slenderock/pg_hba.conf
# ubuntu: sudo nano /etc/postgresql/<< version >>/main/pg_hba.conf
# Позволяет любому пользователю локальной системы подключиться
# к любой базе данных, используя любое имя базы данных через
# доменные сокеты Unix (по умолчанию для локальных подключений).
#
# TYPE DATABASE USER ADDRESS METHOD
local all all trust
# То же, но для локальных замкнутых подключений по TCP/IP.
upstream puma_<%= fetch(:nginx_config_name) %> { <%
flags = 'fail_timeout=0'
@backends = [fetch(:puma_bind)].flatten.map do |m|
etype, address = /(tcp|unix|ssl):\/{1,2}(.+)/.match(m).captures
if etype =='unix'
"server #{etype}:#{address} #{fetch(:nginx_socket_flags)};"
else
"server #{address.gsub(/0\.0\.0\.0(.+)/, "127.0.0.1\\1")} #{fetch(:nginx_http_flags)};"
end
end
@slenderock
slenderock / pg_hba.conf
Last active April 29, 2017 16:53
Позволяет любому пользователю локальной системы подключиться к любой базе данных, используя любое имя базы данных через доменные сокеты Unix (по умолчанию для локальных подключений).
# sudo vi /etc/postgresql/9.5/main/pg_hba.conf
# Позволяет любому пользователю локальной системы подключиться
# к любой базе данных, используя любое имя базы данных через
# доменные сокеты Unix (по умолчанию для локальных подключений).
#
# TYPE DATABASE USER ADDRESS METHOD
local all all trust
# То же, но для локальных замкнутых подключений по TCP/IP.