davydany

PostgreSQL Cheat Sheet

My personal Cheatsheet for PostgreSQL

Quick Commands

Creating a DB and Setting its Ownership

To create a database, you need to first ensure that the database's role exists first. Role and User are synonymous in PostgreSQL. Once you create the ROLE, you can create the Database and set the OWNER as the ROLE.

davydany

# Runs perfectly on CentOS 7

# Read all pids for "VBoxHeadless" process, and kill (-9) them.
while read -r pid; do
  echo "Killing VirtualBox Process '${pid}'..."
  kill -9 ${pid}
  echo "  OK Done."
done <  <(pgrep VBoxHeadless)

# Read all VirtualBox VMs, and unregister, then delete them

davydany

IP Tables (iptables) Cheat Sheet

IPTables is the Firewall service that is available in a lot of different Linux Distributions. While modifiying it might seem daunting at first, this Cheat Sheet should be able to show you just how easy it is to use and how quickly you can be on your way mucking around with your firewall.

Resources

The following list is a great set of documentation for iptables. I used them to compile this documentation.

• How-To Geek: The Beginner’s Guide to iptables, the Linux Firewall: https://www.howtogeek.com/177621/the-beginners-guide-to-iptables-the-linux-firewall/
• IPTables Essentials: Common Firewall Rules and COmmands https://www.digitalocean.com/community/tutorials/iptables-essentials-common-firewall-rules-and-commands

davydany

# thanks to https://github.com/stevenhaddox
# Set Our Root Path
::ROOT = File.dirname( File.expand_path( __FILE__ ) )

ENV['RACK_ENV'] ||= 'development'

require 'rubygems'

# Serve our index file by default
use Rack::Static ,

davydany

# soupkitchen
# -----------
# Runs vagrant commands for kitchen vms
function soupkitchen {
    BROWN_ORANGE="\033[0;33m"
    RED="\033[0;31m"
    NC="\033[0m" # No Color

    command=$1;

davydany

# indexing 
set-option -g base-index 1

# synchronize panes with "Y"
bind-key y set-window-option synchronize-panes

# mouse & scroll configurations
set-option -g mode-mouse on # allows us to use the mouse for scrolling
set-option -g mouse-select-pane on # select a pane with mouse 
set-option -g history-limit 100000 # really large scroll-back

davydany

#!/usr/bin/python

import random

NUMBER_OF_PLAYS = 1000000


class GamblingGame(object):
	pass

davydany

BLACK="\033[0;30m"
DARK_GRAY="\033[1;30m"
LIGHT_GRAY="\033[0;37m"
WHITE="\033[1;37m"

BLUE="\033[0;34m"
LIGHT_BLUE="\033[1;34m"

GREEN="\033[0;32m"
LIGHT_GREEN="\033[1;32m"

davydany

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.davydany.hadoop</groupId>
  <artifactId>MapReduce</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>jar</packaging>

  <name>MapReduce</name>

davydany

"""
******************************************************************
WARNING: THIS DOES NOT TAKE INTO ACCOUNT NESTED SELECT QUERIES.
******************************************************************

Select Query query_extractor
============================

Takes a log file with multipe SELECT query that was split across
multiple lines, and extracts the SELECT query and prints it out on