Run with Python:
pip-2.7 install cffi PYTHON=python2.7 sh go.sh
Run with PyPy:
pip-pypy install cffi PYTHON=pypy sh go.sh
| #!/bin/bash | |
| # | |
| # Script to setup a Elastic Beanstalk AMI with geospatial libraries and postGIS | |
| # | |
| # sh aws_ami_prep.sh > aws_ami_prep.log 2>&1 & | |
| # Go to ec2-user home directory | |
| cd /home/ec2-user | |
| # yum libraries |
Run with Python:
pip-2.7 install cffi PYTHON=python2.7 sh go.sh
Run with PyPy:
pip-pypy install cffi PYTHON=pypy sh go.sh
| -- Decoding | |
| SELECT CONVERT_FROM(DECODE(field, 'BASE64'), 'UTF-8') FROM table; | |
| -- Encoding | |
| SELECT ENCODE(CONVERT_TO(field, 'UTF-8'), 'base64') FROM table; |