Convert AWS DynamoDB Table JSON to Simple PHP Array or JSON

Amazon DynamoDB support these datatype for data – String – Binary – Number – StringSet – NumberSet – BinarySet – Map – List – Boolean – Null AWS provides command line tool to SCAN DynamoDB Tables and export as JSON file # /usr/local/bin/aws dynamodb scan –table-name Users –query ‘Items[*]’ –region us-east-1 –output json Amazon DynamoDB … Read more

Amazon DynamoDB Formatted JSON using JQ

Linux sed is useful tool to format and transform plain text. But sed is not so useful for structured data like JSON. JQ is a sed-like tool easily deal with JSON. ./jq is a lightweight and flexible command-line JSON processor. Install jq on OS X: brew install jq Install jq on Ubuntu: apt-get install jq … Read more

Amazon DynamoDB PHP CRUD using aws.phar

DynamoDB is fully managed, fast and low cost NoSQL database service by Amazon. DynamoDB allows you to offload the administrative operations and scale highly distributed database cluster. The AWS SDK PHP enables you to use Amazon Web Services like Amazon S3, EC2, RDS, CloudFront, Redshift, DynamoDB, Push Notification Service (SNS) and more from your PHP … Read more

SQL OR NOSQL?

If you are searching for SQL or noSQL solutions, it is very difficult to decide among top SQL / noSQL Databases. MySQL is the best for multi-document transactions, complex security, complex join, extreme compression. NoSQL is good for linear scalability, high performance, schema flexibility. But both depend on data need to manage 😉 Scalability MySQL … Read more