Skip to content

Instantly share code, notes, and snippets.

@stricte
stricte / psql_useful_stat_queries.sql
Created May 22, 2019 10:11 — forked from anvk/psql_useful_stat_queries.sql
List of some useful Stat Queries for PSQL
--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192
-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.
------------
-- Basics --
------------
-- Get indexes of tables
@stricte
stricte / arch-linux-install-xps-9370-pl-luks
Last active January 17, 2019 07:08 — forked from binaerbaum/arch-linux-install
Minimal instructions for installing arch linux on an UEFI NVMe system with full system encryption using dm-crypt and luks
# Install ARCH Linux with encrypted file-system and UEFI
# The official installation guide (https://wiki.archlinux.org/index.php/Installation_Guide) contains a more verbose description.
# Download the archiso image from https://www.archlinux.org/
# Copy to a usb-drive
dd if=archlinux.img of=/dev/sdX bs=16M && sync # on linux
# Boot from the usb. If the usb fails to boot, make sure that secure boot is disabled in the BIOS configuration.
setfont Lat2-Terminus16.psfu.gz -m 8859-2
@stricte
stricte / README.md
Created May 6, 2016 09:11 — forked from magnetikonline/README.md
IE 7/8/9/10/11 Virtual machines from Microsoft - Linux w/VirtualBox installation notes.
jQuery(function(){
$.fn.formBackUp = function() {
if(!localStorage) {
return false;
}
var form = this;
var datas = {};
var ls = null;
datas.href = document.location.href;
@stricte
stricte / rails_admin_action_creator
Last active August 29, 2015 14:10
rails_admin_custom_action_plugin
say "Create stub for '#{action_name = name.sub('rails_admin_', '')}' in gem '#{name}'. This may take a while"
#cleaning
run "rm -rf script/ config/ lib/tasks/"
run "rm -rf app/assets app/controllers app/helpers app/mailers app/models"
run "mkdir -p app/views/rails_admin/main"
#view
inside "app/views/rails_admin/main" do
create_file "#{action_name}.html.haml", <<-END