Production Use Case – Amazon DynamoDB Index Design Best Practices for Optimum Performance

Programming Amazon Web Services : PageView Item Global Secondary Index

Ok so you have read all the good things about DynamoDB and decided to use for your production application. One of the major thing which amazon web service developers, DB architects really struggle while working with DynamoDB is efficient index design. DynamoDB is: db => tables => items => attributes db = a list of […]

Amazon Redshift User Management Productive Queries

Amazon Redshift User Management Queries & Query Examples

Amazon Redshift works really great for big data. You can run complex analytical queries on petabyte-scale data. If you are beginner with Amazon Web Service you can get started with below articles. AWS Free Tier Unknown facts Setup Amazon CloudWatch Alarm for Billing Alerts Amazon Redshift documentation is quite good. Having said that I find […]

Amazon Redshift – Working with JSON Data

Amazon Web Services Tutorial : Amazon Redshift JSON Query

Amazon Redshift JSON Functions Amazon Redshift has some built in JSON functions that allow extracting data out of JSON. You can easily modify JSON strings to store additional key=value pairs without needing to add columns to a table. Amazon Redshift JSON functions are alias of PostgreSQL JSON functions. JSON_EXTRACT_PATH_TEXT Amazon Redshift function is the most […]