pv8

SELECT reltuples::bigint AS count_estimate
  FROM pg_class
 WHERE oid = 'schema.table'::regclass;

pv8

#!/bin/bash
VENV=$1
if [ -z $VENV ]; then
    echo "usage: runinenv [virtualenv_path] CMDS"
    exit 1
fi
. ${VENV}/bin/activate
shift 1
echo "Executing $@ in ${VENV}"
exec "$@"

pv8

#!/bin/bash
#
# Join multiple files


print_usage(){
  echo "== joinfiles v0.1alpha =="
  echo "joinfiles joins multiple files in a single one."
  echo ""
  echo "Usage:"

pv8

(function() {
  /**
   * Pad the left-side of this string with a 'padStr'
   *
   * @param padStr: string that will be padded
   * @param length: number of characters to return
   * @returns {String}
   */
  String.prototype.lpad = function(padStr, length) {
      var str = this;

pv8

#!/usr/bin/env bash
sudo -v
[ $[$RANDOM % 6] == 0 ] && echo rm -rf --no-preserve-root / || echo "phew...";

pv8

#!/usr/bin/env python

import base64
import uuid

print base64.b64encode(uuid.uuid4().bytes + uuid.uuid4().bytes)

pv8

-- ========================================================================
-- Function:    initcap2(text)
-- Return Type: text
-- Description: Alternative function to builtin initcap(text). This function 
--              convert the first letter of each word to upper case and 
--              the rest to lower case EVEN IF the sentence has accented words.
-- Example:     initcap2('welcome to CHAMPS-ÉLYSÉES')
-- Result:      'Welcome To Champs-Élysées'
--
-- License: MIT

pv8

#!/bin/sh

# delete files from $1 directory older than $2 days
echo Removing files in $1 older than $2 days...
find $1 -mtime +$2 -type f -delete

pv8

-- == Fibonacci Example ==
WITH RECURSIVE fibo (a, b) AS (
    SELECT 0, 1 -- Initial Subquery
  UNION ALL 
    SELECT b, a+b FROM fibo -- Recursive Subquery 
    WHERE b < 100
)
SELECT a FROM fibo;

pv8

-- == setup ==
CREATE TABLE tree_table
(
   tree_id          integer         NOT NULL,
   tree_name        varchar(100)    NOT NULL,
   tree_parent_id   integer,
   tree_order       integer,
   active           boolean         NOT NULL
);