Skip to content

Instantly share code, notes, and snippets.

Avatar
🐧
Linux forever

Maurizio De Santis mdesantis

🐧
Linux forever
View GitHub Profile
@mdesantis
mdesantis / sidekiq-reset.rb
Created Apr 24, 2020
Sidekiq reset one-liner
View sidekiq-reset.rb
require 'sidekiq/api'; [Sidekiq::RetrySet.new, Sidekiq::ScheduledSet.new, Sidekiq::DeadSet.new, Sidekiq::Stats.new.queues].each(&:clear); Sidekiq::Stats.new.reset
@mdesantis
mdesantis / postgresql_like_index.rb
Last active Jul 23, 2020
Rails migration adding PostgreSQL index for LIKE when the pattern is both left-anchored and right-anchored
View postgresql_like_index.rb
# It supports queries like:
# ModelName.where(ModelName.arel_table[:columnname].lower.matches 'searchterm')
class PostgresqlLikeIIndex < ActiveRecord::Migration
def up
enable_extension 'pg_trgm'
execute <<~SQL
CREATE INDEX index_tablename_on_columnname_lower
ON tablename USING gin (lower(columnname) gin_trgm_ops)
SQL
@mdesantis
mdesantis / ruby-2-3-install.sh
Created Feb 29, 2020
Install Ruby 2.3 on Ubuntu 19.10 using asdf (ruby-build)
View ruby-2-3-install.sh
#!/bin/bash
# It assumes [asdf](https://github.com/asdf-vm/asdf) to be installed
# and asdf plugin for Ruby to be added
set -exuo pipefail
sudo apt install libreadline-dev
wget https://www.openssl.org/source/old/1.0.2/openssl-1.0.2u.tar.gz
tar -xzf openssl-1.0.2u.tar.gz
@mdesantis
mdesantis / guix-install.sh
Last active Sep 26, 2018
GNU Guix v0.15.0 installer, non interactive version (suitable for Docker; modified from https://git.savannah.gnu.org/cgit/guix.git/plain/etc/guix-install.sh?h=v0.15.0)
View guix-install.sh
#!/bin/bash
# GNU Guix --- Functional package management for GNU
# Copyright © 2017 sharlatan <sharlatanus@gmail.com>
# Copyright © 2018 Ricardo Wurmus <rekado@elephly.net>
# Copyright © 2018 Efraim Flashner <efraim@flashner.co.il>
#
# This file is part of GNU Guix.
#
# GNU Guix is free software; you can redistribute it and/or modify it
# under the terms of the GNU General Public License as published by
View tsung.xml
<?xml version="1.0"?>
<!DOCTYPE tsung SYSTEM "/usr/share/tsung/tsung-1.0.dtd" [] >
<tsung loglevel="info">
<clients>
<client host="localhost" use_controller_vm="true" maxusers="60000"/>
</clients>
<servers>
<server host="localhost" port="3334" type="tcp"></server>
</servers>
@mdesantis
mdesantis / sir-trevor.coffee.erb
Created Dec 21, 2017
Sir Trevor initializer for Rails
View sir-trevor.coffee.erb
$(document).on 'ready turbolinks:load', ->
SirTrevor.config.language = 'it'
SirTrevor.setDefaults(
language: 'it'
focusOnInit: false
blockTypes: ['Text', 'Image', 'List', 'Heading', 'Quote', 'Video']
defaultType: 'Text'
iconUrl: "<%= asset_path('sir-trevor/build/sir-trevor-icons.svg') %>"
uploadUrl: "/admin/uploads/images"
@mdesantis
mdesantis / upgrade-postgres-9.6-to-10.md
Last active Aug 17, 2020 — forked from delameko/upgrade-postgres-9.5-to-9.6.md
Upgrading PostgreSQL from 9.6 to 10 on Ubuntu 16.04
View upgrade-postgres-9.6-to-10.md

TL;DR

Install Postgres 10, and then:

sudo pg_dropcluster 10 main --stop
sudo pg_upgradecluster 9.6 main
sudo pg_dropcluster 9.6 main
View asd.rb
begin
require "bundler/inline"
rescue LoadError => e
$stderr.puts "Bundler version 1.10 or later is required. Please update your Bundler"
raise e
end
gemfile(true) do
source "https://rubygems.org"
# Activate the gem you are reporting the issue against.
View gist:214982b377e94020980347eaf21b8efc
> rails -v
Rails 5.1.0.rc1
> rails new rails_vue --webpack=vue
create
create README.md
create Rakefile
create config.ru
create .gitignore
create Gemfile
run git init from "."
@mdesantis
mdesantis / unique_constraint_handler.rb
Last active Aug 29, 2015
PostgreSQL unique constraint handler: it sets the record as invalid if a PostgreSQL unique constraint error is raised on record saving
View unique_constraint_handler.rb
# Usage example:
#
# class User < ActiveRecord::Base
# include UniqueConstraintHandler
# handle_unique_constraint_on :email
# end
#
# User.create email: 'test@example.com'
# user = User.create email: 'test@example.com'
# user.new_record? #=> true