Skip to content

Instantly share code, notes, and snippets.

@fike
fike / facebook
Created July 27, 2016 21:21
Curl HTTP Headers / HTTP2
fike@corellia:~$ curl -s -D - -o /dev/null -H "Accept-Encoding: br" https://www.facebook.com/
HTTP/2.0 200
p3p:CP="Facebook does not have a P3P policy. Learn why here: http://fb.me/p3p"
strict-transport-security:max-age=15552000; preload
cache-control:private, no-cache, no-store, must-revalidate
expires:Sat, 01 Jan 2000 00:00:00 GMT
pragma:no-cache
public-key-pins-report-only:max-age=500; pin-sha256="WoiWRyIOVNa9ihaBciRSC7XHjliYS9VwUGOIud4PB18="; pin-sha256="r/mIkG3eEpVdm+u/ko/cwxzOMo1bk4TyHIlByibiA5E="; pin-sha256="q4PO2G2cbkZhZ82+JgmRUyGMoAeozA+BSXVXQWB8XWQ="; report-uri="http://reports.fb.com/hpkp/"
x-content-type-options:nosniff
x-xss-protection:0
#!/usr/bin/env ruby
#--
# Copyright 2016 by Fernando Ike <fike@midstorm.org>.
# All rights reserved.
# This script is under LGPL-2
#
# har2csv exports some har headers and values to csv.
#++
require 'addressable/uri'
@fike
fike / pgbr2015.sql
Created September 16, 2015 13:45
Email reply with answer my talk proposal to PostgreSQL Brasil Conference 2015 (pgbr205)
Obrigado por ter enviado sua proposta de palestra 'Caiu a lista do PostgreSQL Brasil! E agora?' para o PGBR 2015 e gostaríamos de informá-lo que ela foi aceita!
Nós até preparamos um script especial:
BEGIN;
INSERT INTO pgbr2015.palestras
SELECT titulo, palestrante
FROM pgbr2015.propostas
WHERE palestrante = 'Fernando Ike'
@fike
fike / keybase.md
Last active August 29, 2015 14:22
my keybase check

Keybase proof

I hereby claim:

  • I am fike on github.
  • I am fernandoike (https://keybase.io/fernandoike) on keybase.
  • I have a public key whose fingerprint is DC10 8A85 1446 7ECD 270D 2E64 FE8C 2935 E2A9 D67E

To claim this, I am signing this object:

@fike
fike / httparchive_biqueries.sql
Created December 15, 2014 20:15
HTTP archive (Using Bigqueries) queries to know "What are TOP CDNs"
// These queries were used this HTTP archive (Bigqueries)
// http://bigqueri.es/t/whats-the-percent-of-http-request-that-are-outside-of-the-cdns/477
// HTTP requests with and without CDN
SELECT cdn, num, ROUND(ratio*100) as percent FROM (
SELECT cdn, COUNT(cdn) as num, RATIO_TO_REPORT(num) OVER() ratio FROM (
SELECT CASE
WHEN _cdn_provider IN ('')
THEN 'None'
ELSE 'CDN'
@fike
fike / recovery_octopress_p.rb
Last active March 30, 2021 01:11
Recovery Octopress post to markdown
#!/usr/bin/env ruby
# This script (recovery_octopress_p.rb) convert Octopress post, more specific the body in
# Octopress markdown files and it need that pages stay in local computer.
# Its license is LGPL-2.1 and more details, you can look this FSF link:
# - https://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
#
# It was developed for Fernando Ike de Oliveira <fike@midstorm.org>.
#
# Some bugs knows:
# - A problem to convert "." in title to dot word. Octopress was do much better
function addBlankTargetForLinks () {
$('a[href^="http"]'||'a[href^="https"]').each(function(){
$(this).attr('target', '_blank');
});
}
$(document).bind('DOMNodeInserted', function(event) {
addBlankTargetForLinks();
});
@fike
fike / sqlite2pg.sh
Last active December 14, 2015 12:58 — forked from eclubb/sqlite2pg.sh
#!/bin/sh
# This script will migrate schema and data from a SQLite3 database to PostgreSQL.
# Schema translation based on http://stackoverflow.com/a/4581921/1303625.
# Some column types are not handled (e.g blobs).
SQLITE_DB_PATH=$1
PG_DB_NAME=$2
PG_USER_NAME=$3
@fike
fike / gist:5030235
Last active December 14, 2015 04:39
Show pgvm errors
pgvm install 9.2.2
downloading 'http://ftp.postgresql.org/pub/source/v9.2.2/postgresql-9.2.2.tar.gz', please be patient... done.
checking 'postgresql-9.2.2.tar.gz' integrity... done.
extracting postgresql-9.2.2.tar.gz ... done.
configuring PostgreSQL Version: 9.2.2 ... done.
compiling ... ERRO: can not compile PostgreSQL 9.2.2, see make.error.log for details.
#!/bin/bash
#
# Simple script to length image optimization.
# Fernando Ike - fike@midstorm.org.
#
#
#
DIR=$HOME/d/octopress/source/images
CONVERT=$(which convert)