Ivan Lemeshev ivanlemeshev

## README-Template.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ivanlemeshev
                / README-Template.md
            
            
              Created
              October 8, 2018 19:24
                — forked from PurpleBooth/README-Template.md
            
              
                A template to make good README.md
              
          
    Project Title

One Paragraph of project description goes here
Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
Prerequisites


## dial-pq-via-ssh.go
package main

import (
	"database/sql"
	"database/sql/driver"
	"fmt"
	"net"
	"os"
	"time"

## notes.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ivanlemeshev
                / notes.md
            
            
              Created
              November 7, 2017 07:29
                — forked from matthewjberger/notes.md
            
              
                How to make an electron app using Create-React-App and Electron with Electron-Builder.
              
          
    Note: This post is a summary of information paraphrased from an excellent blog post by Christian Sepulveda.

Prerequisites


Create-React-App
Yarn

Instructions

Create the app and download the necessary dependencies.

  
## nginx.conf
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

## cors.nginxconf
#
# Acts as a nginx HTTPS proxy server
# enabling CORS only to domains matched by regex
# /https?://.*\.mckinsey\.com(:[0-9]+)?)/
#
# Based on:
# * http://blog.themillhousegroup.com/2013/05/nginx-as-cors-enabled-https-proxy.html
# * http://enable-cors.org/server_nginx.html
#
server {

## detectcontenttype.go
file, err := os.Open(path)
if err != nil {
	return err
}
defer file.Close()

// Only the first 512 bytes are used to sniff the content type.
buffer := make([]byte, 512)
_, err = file.Read(buffer)
if err != nil {

## first-and-last-aggregate-functions-psql.sql
-- Create a function that always returns the first non-NULL item
CREATE OR REPLACE FUNCTION public.first_agg ( anyelement, anyelement )
RETURNS anyelement LANGUAGE SQL IMMUTABLE STRICT AS $$
        SELECT $1;
$$;

-- And then wrap an aggregate around it
CREATE AGGREGATE public.FIRST (
        sfunc    = public.first_agg,
        basetype = anyelement,

## gist:ed76388147dc112ead7354a4380d4e14

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ivanlemeshev
                / gist:ed76388147dc112ead7354a4380d4e14
            
            
              Created
              September 23, 2016 03:13
                — forked from arunoda/gist:7790979
            
              
                Installing SSHPass
              
          
    Installing SSHPASS

SSHPass is a tiny utility, which allows you to provide the ssh password without using the prompt. This will very helpful for scripting. SSHPass is not good to use in multi-user environment. If you use SSHPass on your development machine, it don't do anything evil.
Installing on Ubuntu

apt-get install sshpass

Installing on OS X


## regex-japanese.txt
Regex for matching ALL Japanese common & uncommon Kanji (4e00 – 9fcf) ~ The Big Kahuna!
([一-龯])

Regex for matching Hirgana or Katakana
([ぁ-んァ-ン])

Regex for matching Non-Hirgana or Non-Katakana
([^ぁ-んァ-ン])

Regex for matching Hirgana or Katakana or basic punctuation (、。’)

## JapaneseRegex.js
// REFERENCE UNICODE TABLES:
// http://www.rikai.com/library/kanjitables/kanji_codes.unicode.shtml
// http://www.tamasoft.co.jp/en/general-info/unicode.html
//
// TEST EDITOR:
// http://www.gethifi.com/tools/regex
//
// UNICODE RANGE : DESCRIPTION
//
// 3000-303F : punctuation
	package main

	import (
	"database/sql"
	"database/sql/driver"
	"fmt"
	"net"
	"os"
	"time"
	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048
	#
	# Acts as a nginx HTTPS proxy server
	# enabling CORS only to domains matched by regex
	# /https?://.*\.mckinsey\.com(:[0-9]+)?)/
	#
	# Based on:
	# * http://blog.themillhousegroup.com/2013/05/nginx-as-cors-enabled-https-proxy.html
	# * http://enable-cors.org/server_nginx.html
	#
	server {
	file, err := os.Open(path)
	if err != nil {
	return err
	}
	defer file.Close()

	// Only the first 512 bytes are used to sniff the content type.
	buffer := make([]byte, 512)
	_, err = file.Read(buffer)
	if err != nil {
	-- Create a function that always returns the first non-NULL item
	CREATE OR REPLACE FUNCTION public.first_agg ( anyelement, anyelement )
	RETURNS anyelement LANGUAGE SQL IMMUTABLE STRICT AS $$
	SELECT $1;
	$$;

	-- And then wrap an aggregate around it
	CREATE AGGREGATE public.FIRST (
	sfunc = public.first_agg,
	basetype = anyelement,
	Regex for matching ALL Japanese common & uncommon Kanji (4e00 – 9fcf) ~ The Big Kahuna!
	([一-龯])

	Regex for matching Hirgana or Katakana
	([ぁ-んァ-ン])

	Regex for matching Non-Hirgana or Non-Katakana
	([^ぁ-んァ-ン])

	Regex for matching Hirgana or Katakana or basic punctuation (、。’)
	// REFERENCE UNICODE TABLES:
	// http://www.rikai.com/library/kanjitables/kanji_codes.unicode.shtml
	// http://www.tamasoft.co.jp/en/general-info/unicode.html
	//
	// TEST EDITOR:
	// http://www.gethifi.com/tools/regex
	//
	// UNICODE RANGE : DESCRIPTION
	//
	// 3000-303F : punctuation