Month: December 2018

Developing and Hosting Web Applications Cost Effective – With Flask or Django and Lambda on AWS

Developing and Hosting Web Applications Cost Effective – With Flask or Django and Lambda on AWS Seems to be a very very very cost effective strategy if you want to host with a cloud provider.¬† Google that sentence above, you will find lots of references on how to get started. Here’s a quick start to …

Developing and Hosting Web Applications Cost Effective – With Flask or Django and Lambda on AWS Read More »

Using AWS CLI

AWS CLI Basics: Assuming you have aws cli setup – if you are using an ec2 amazon AMI the AWS CLI is preinstalled for you – verify version of CLI with: aws –version # show the regions available – will work if you have ec2 privs… aws ec2 describe-regions –output text | cut -f 3 …

Using AWS CLI Read More »

Redshift Grant Read On PG_CATALOG Objects To Normal / Non Superusers

Redshift is based on a version of PostgreSQL that only allows SuperUsers to see pg_catalog¬† objects. Here is a way to get around that – must be a superuser to do this: create group select_catalog_group; grant select on all the tables in pg_catalog your users want to see (see an example list below) alter group …

Redshift Grant Read On PG_CATALOG Objects To Normal / Non Superusers Read More »