jordiwes

#1 get latest iconv php extension which is included in the php-src 
git clone http://git.php.net/repository/php-src.git

#2.0 find your PHP Version
php -v

#2.1 check out your specific branch of PHP
git checkout PHP-5.6.7 

#3 If you dont have libiconv.a, Get libiconv from perzl and then fix it

jordiwes

#!/usr/bin/env python
#coding: utf-8

import os
import imp
import time
import signal
import argparse
import commands

jordiwes

stop;

-- Publish the data within a table using SQL
with json_rows (j) as (
    select json_object(
        key 'EMPNO' value empno, key 'FIRSTNME' value firstnme,
        key 'MIDINIT' value midinit, key 'LASTNAME' value lastname,
        key 'WORKDEPT' value workdept, key 'PHONENO' value phoneno,
        key 'HIREDATE' value hiredate, key 'JOB' value job,

jordiwes

#!/bin/bash

###################################################
# HOW TO RUN THIS SCRIPT
#  copy this script to target server
#  run these commands from a bash terminal:
#    `cd /path/to/folder`
#    `chmod +x www-install.sh`
#    `./www-install.sh`
#  if you want to overwrite .nginx/.php folders:

jordiwes

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

jordiwes

mysql -h