aa21

-- Bruteforce. Index all the columns in all tables of a db.

-- Find the data types
-- select distinct data_type from information_schema.columns where table_schema="DATABASE";

select
concat( "ALTER TABLE  `DATABASE`.`", table_name ,  "` ADD INDEX (  `",column_name  ,"` );"   )
from information_schema.columns where table_schema='DATABASE' and
data_type not in ('text', 'longtext', 'mediumtext','tinytext' );

aa21

        //source: http://www.toao.net/48-replacing-smart-quotes-and-em-dashes-in-mysql
        //By Mango, March 5th, 2009
        
        //clean charset
        function c($text){
                // First, replace UTF-8 characters.
                $text = str_replace(
                                array("\xe2\x80\x98", "\xe2\x80\x99", "\xe2\x80\x9c", "\xe2\x80\x9d", "\xe2\x80\x93", "\xe2\x80\x94", "\xe2\x80\xa6"),
                                array("'", "'", '"', '"', '-', '--', '...'),
                                $text

aa21

<meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1.0 maximum-scale=1.0" />

aa21

apt-get update

#lamp
apt-get install apache2 mysql-server
mysql_secure_installation
apt-get install php5 php-pear php5-mysql git vim locate
updatedb

vim /etc/vim/vimrc
  syntax on

aa21

mysqltuner.pl
https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl

tuning primer sh
http://www.day32.com/MySQL/tuning-primer.sh

calculator
http://www.mysqlcalculator.com/

aa21

If frontpage:
  https://ecommerce.shopify.com/c/ecommerce-design/t/if-home-variable-5824 

aa21

Blockchain
  - Anything that can be mathematically represented
    - can be modelled
    - secured
    - traded

Privacy: 
  - Info, Identity, Funds are private

Contract: Program that runs everytime a message called a transaction is received

aa21

# Serve Static Files from public folder
 app.use(express.static('public'));

# Serve "public" folder's files as Static Files from path "/static"
 app.use('/static', express.static('public'));

# Hosting apache & NodeJS on same server
  <VirtualHost *:80>
    ServerName bms.komiapp.com
    ProxyPreserveHost on

aa21

#installing mongodb
    vim /etc/yum.repos.d/mongodb.repo
      [mongodb]
      name=MongoDB Repository
      baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/
      gpgcheck=0
      enabled=1
    
    yum install mongo-10gen mongo-10gen-server
    chkconfig mongod on

aa21

Javascript

Learning Javascript Design Patterns, Addy Osmani http://addyosmani.com/resources/essentialjsdesignpatterns/book/

Pro JavaScript™ Design Patterns, Ross Harmes and Dustin Diaz http://www.vashstile1.ru/assets/files/price.pdf