Skip to content

Instantly share code, notes, and snippets.

View pioz's full-sized avatar
🧙‍♂️
[object Object]

Enrico pioz

🧙‍♂️
[object Object]
View GitHub Profile
@pioz
pioz / join_query_benchmark.rb
Last active November 19, 2019 10:52
Benchmark single join vs 2 with pluck
require 'active_record'
require 'activerecord-import'
require 'mysql2'
require 'benchmark'
ActiveRecord::Base.establish_connection(
adapter: 'mysql2',
host: 'localhost',
username: 'root',
database: 'joiner'
@pioz
pioz / gist:28668deb702b7a91fcb8fcff66e872b2
Created July 23, 2019 07:58
Delete Timemachine local snapshots
tmutil listlocalsnapshots /
sudo tmutil deletelocalsnapshots 2019-06-09-043259
@pioz
pioz / background_animated_gradient.css
Created August 9, 2019 13:37
Animate background gradient
background: linear-gradient(235deg, #ff8a00, #da1b60);
background-size: 400% 400%;
-webkit-animation: animateBackgroundGradient 20s ease infinite;
-moz-animation: animateBackgroundGradient 20s ease infinite;
animation: animateBackgroundGradient 20s ease infinite;
@-webkit-keyframes animateBackgroundGradient {
0%{background-position:0% 50%}
50%{background-position:100% 50%}
@pioz
pioz / engines.md
Created August 29, 2019 14:48
Using webpacker inside a Rails engine

Using in Rails engines

If the application UI consists of multiple frontend application, you'd probably like to isolate their building too (e.g. if you use different frameworks/versions). Hence we needed our webpack(-er) to be isolated too: separate package.json, dev server, compilation process.

You can do this by adding another Webpacker instance to your application.

This guide describes how to do that using Rails engines.

Step 1: create Rails engine.

@pioz
pioz / convert_db_encoding_to_utf8mb4.sh
Created September 10, 2019 09:57
Convert database charset encoding to utf8mb4 and collation to utf8mb4_unicode_ci
#!/bin/bash
DB="italian_spiderman"
CHARSET="utf8mb4"
COLL="utf8mb4_unicode_ci"
echo $DB
echo "ALTER DATABASE \`$DB\` CHARACTER SET $CHARSET COLLATE $COLL;" | mysql
echo "USE \`$DB\`; SHOW TABLES;" | mysql -s | (
@pioz
pioz / apache_proxy_pass.conf
Last active September 18, 2020 23:52
Apache Proxy Pass sample config file
<VirtualHost *:80>
ServerName example.com
Redirect permanent / https://example.com/
ErrorLog /var/log/apache2/example-error.log
CustomLog /var/log/apache2/example-access.log combined
ServerSignature Off
</VirtualHost>
@pioz
pioz / enkin.txt
Last active January 11, 2022 16:49
D&D Enkin PG description
Enkin è un mago. Ha passato molti anni a studiare presso svariate accademie di
magia in tutto l'occidente. Nonostante la sua ampia conoscenza teorica sulla
magia è uno pratico. È sfacciato di fronte al pericolo, gli piace rischiare,
impulsivo nelle scelte ed è disposto a qualsiasi cosa per difendere i suoi
compagni e per portare a termine la sua missione. La magia per Enkin è una
passione, vive per la magia, e forse per lui è anche una ossessione. Quando si
mette in viaggio in cerca di avventura, non lo fa per la gloria, la fama o il
danaro, lo fa per aumentare il suo sapere magico, scoprire nuovi incantesimi,
perfezionare la sua arte magica. Possiamo dire che se si trovasse di fronte a
un djinn e dovesse esprimere 3 desideri il primo sarebbe diventare il più
@pioz
pioz / cover.sh
Created September 30, 2020 17:37
Golang test coverage
go test -coverprofile cover.out
go tool cover -html=cover.out
@pioz
pioz / .bash_profile
Last active January 11, 2022 16:51
Pioz Bash prompt customization
parse_git_branch() {
test -d .git && echo "($(git rev-parse --abbrev-ref HEAD)) "
}
# PS1='\u@\h:\W $(parse_git_branch)\$ ' without colors
PS1='\e[0;33m\u@\h\e[m:\W \e[0;36m$(parse_git_branch)\e[m\e[0;33m\$\e[m '
@pioz
pioz / memcache.go
Created March 5, 2021 14:04
Restore array of structs from memcache in GO
package main
import (
"bytes"
"encoding/gob"
"fmt"
"github.com/bradfitz/gomemcache/memcache"
)