Skip to content

Instantly share code, notes, and snippets.

View Ptico's full-sized avatar

Andrii Savchenko Ptico

64 followers · 20 following
View GitHub Profile
@Ptico
Ptico / basic.sql
Created December 13, 2019 16:50 — forked from nesquena/basic.sql
PostgreSQL Common Utility Queries
/* How to calculate postgreSQL database size in disk ? */
SELECT pg_size_pretty(pg_database_size('thedbname'));
/* Calculate size of a table including or excluding the index */
SELECT pg_size_pretty(pg_total_relation_size('big_table'));
SELECT pg_size_pretty(pg_relation_size('big_table')); /* without index */
/* See indexes on a table with `\d tablename` */
@Ptico
Ptico / bench.rb
Created November 8, 2019 12:58
require 'benchmark'
require 'benchmark/ips'
require 'benchmark/memory'
require 'faker'
class Bench
attr_reader :benchmarks
attr_accessor :bmbm_iters
@Ptico
Ptico / problem.rb
Last active October 22, 2019 13:29
dry-schema partial
AddressSchema = Dry::Schema.Params do
required(:street).filled(:string)
required(:city).filled(:string)
required(:zipcode).filled(:string)
required(:email).filled(:string)
end
# ...
# CREATE { street: 'Baker Street', city: 'London', zipcode: 'NW1/W1', email: '[email protected]' }
@Ptico
Ptico / inflector.rb
Created November 25, 2017 15:24
class Parts
def initialize(parts)
@parts = parts
end
def join(part_divider, word_divider='')
@parts.map do |word|
word.join(word_divider)
end.join(part_divider)
end
@Ptico
Ptico / .babelrc
Last active June 22, 2016 12:49
Hanami gulp assets with digests
{
"plugins":
[
"transform-undefined-to-void",
"transform-es2015-arrow-functions",
"transform-es2015-block-scoping",
"transform-es2015-block-scoped-functions",
"transform-es2015-constants",
"transform-es2015-destructuring",
"transform-es2015-parameters",
@Ptico
Ptico / keybase.md
Created April 6, 2016 16:35

Keybase proof

I hereby claim:

  • I am ptico on github.
  • I am ptico (https://keybase.io/ptico) on keybase.
  • I have a public key ASD84JPGkyH33x0DJUEohQ0xz_lTuCLfGUu9cIAdS9XoIgo

To claim this, I am signing this object:

@Ptico
Ptico / gems.rb
Created October 6, 2015 14:42
My default rails gemfile
source 'https://rubygems.org'
BUNDLE_RAILS_VERSION = '~> 4.2.4'
# Rails
gem 'railties', BUNDLE_RAILS_VERSION
gem 'activesupport', BUNDLE_RAILS_VERSION
gem 'actionpack', BUNDLE_RAILS_VERSION
gem 'actionmailer', BUNDLE_RAILS_VERSION
gem 'activejob', BUNDLE_RAILS_VERSION
@Ptico
Ptico / site.conf
Created October 1, 2015 12:49 — forked from paskal/site.conf
Nginx configuration for best security and modest performance. Full info on https://terrty.net/2014/ssl-tls-in-nginx/
# read more at https://terrty.net/2014/ssl-tls-in-nginx/
# latest version on https://gist.github.com/paskal/628882bee1948ef126dd/126e4d1daeb5244aacbbd847c5247c2e293f6adf
# security test score: https://www.ssllabs.com/ssltest/analyze.html?d=terrty.net
# your nginx version might not have all directives included, test this configuration before using in production against your nginx:
# $ nginx -c /etc/nginx/nginx.conf -t
server {
# public key, contains your public key and class 1 certificate, to create:
# (example for startssl)
# $ (cat example.com.pem & wget -O - https://www.startssl.com/certs/class1/sha2/pem/sub.class1.server.sha2.ca.pem) | tee -a /etc/nginx/ssl/domain.pem > /dev/null
@Ptico
Ptico / SassMeister-input.scss
Last active August 29, 2015 14:25
Generated by SassMeister.com.
// ----
// libsass (v3.2.5)
// ----
.pretty-form {
input {
&[type="text"], &[type="password"], &[type="email"], &[type="url"], &[type="month"], &[type="number"], &[type="search"], &[type="tel"], &[type="week"] {
&:invalid, .invalid & {
color: red;
}
@Ptico
Ptico / 1_instructions.md
Created June 18, 2015 18:13
Список журналажи и тотальной зрады (пополняется)

Следуя данной инструкции вы избавитесь от паники, тотальной зрады, а так же улучшите настроение и аппетит.

Если у вас windows 8 и выше

  1. Читаете как править файл hosts здесь: http://skesov.ru/kak-izmenit-fayl-hosts-na-windows-8-1-ili-8/
  2. Вставляете в конец файла записи из списка ниже
  3. Сохраняете

Если у вас MacOS X или Linux