dncpax

## wordpress_nginx_install.sh
#!/bin/bash

# Functions
ok() { echo -e '\e[32m'$domain'\e[m'; } # Green
die() { echo -e '\e[1;31m'$domain'\e[m'; exit 1; }

# Sanity check
[ $(id -g) != "0" ] && die "Script must be run as root."

# Connfigure WordPress

## postgresql_find_duplicates.sql
select * from (
  SELECT id,
  ROW_NUMBER() OVER(PARTITION BY column1, column2 ORDER BY id asc) AS Row
  FROM tbl
) dups
where
dups.Row > 1

## python_resources.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                dncpax
                / python_resources.md
            
            
              Last active
              August 29, 2015 14:21
                — forked from jookyboi/python_resources.md
            
              
                Python-related modules and guides.
              
          
    Packages


lxml - Pythonic binding for the C libraries libxml2 and libxslt.
boto - Python interface to Amazon Web Services
Django - Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.
Fabric - Library and command-line tool for streamlining the use of SSH for application deployment or systems administration task.
PyMongo - Tools for working with MongoDB, and is the recommended way to work with MongoDB from Python.
Celery - Task queue to distribute work across threads or machines.
pytz - pytz brings the Olson tz database into Python. This library allows accurate and cross platform timezone calculations using Python 2.4 or higher.

Guides


## javascript_resources.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                dncpax
                / javascript_resources.md
            
            
              Last active
              August 29, 2015 14:21
                — forked from jookyboi/javascript_resources.md
            
              
                Here are a set of libraries, plugins and guides which may be useful to your Javascript coding.
              
          
    Libraries


jQuery - The de-facto library for the modern age. It makes things like HTML document traversal and manipulation, event handling, animation, and Ajax much simpler with an easy-to-use API that works across a multitude of browsers.
Backbone - Backbone.js gives structure to web applications by providing models with key-value binding and custom events, collections with a rich API of enumerable functions, views with declarative event handling, and connects it all to your existing API over a RESTful JSON interface.
AngularJS - Conventions based MVC framework for HTML5 apps.
Underscore - Underscore is a utility-belt library for JavaScript that provides a lot of the functional programming support that you would expect in Prototype.js (or Ruby), but without extending any of the built-in JavaScript objects.
lawnchair - Key/value store adapter for indexdb, localStorage


## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

## postgresql_rowcount_database.sql
-- Function to execute some sql text and return a scalar (eg number);
-- original from stackoverflow: https://stackoverflow.com/questions/2596670/how-do-you-find-the-row-count-for-all-your-tables-in-postgres

CREATE OR REPLACE FUNCTION dsql2(i_text text)
  RETURNS integer AS
$BODY$
Declare
  v_val int;
BEGIN
  execute i_text into v_val;
	#!/bin/bash

	# Functions
	ok() { echo -e '\e[32m'$domain'\e[m'; } # Green
	die() { echo -e '\e[1;31m'$domain'\e[m'; exit 1; }

	# Sanity check
	[ $(id -g) != "0" ] && die "Script must be run as root."

	# Connfigure WordPress
	select * from (
	SELECT id,
	ROW_NUMBER() OVER(PARTITION BY column1, column2 ORDER BY id asc) AS Row
	FROM tbl
	) dups
	where
	dups.Row > 1
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console
	-- Function to execute some sql text and return a scalar (eg number);
	-- original from stackoverflow: https://stackoverflow.com/questions/2596670/how-do-you-find-the-row-count-for-all-your-tables-in-postgres

	CREATE OR REPLACE FUNCTION dsql2(i_text text)
	RETURNS integer AS
	$BODY$
	Declare
	v_val int;
	BEGIN
	execute i_text into v_val;