DynamoDB client in local with UI like PHPMyAdmin

Question

I am creating web service in zend framework which uses DynamoDB. So I installed DynamoDB in local. But it's not easy to use. Even for inserting data and update any data for testing for purpose I have to write a script.

Is there any DynamoDB client available for MAC ? In which we can insert/update/delete data from UI.

EDIT

Doubts

1) Do I have to run a SQL to see table data? I thought there would be GUI for this.

2) I am not able to use where clause in SQL. What if I want to see one or two records from all? Is there a way to use conditions in this?

3) All fields of a row is not visible and I am not able to scroll it horizontally ?

Answer 1

I ran into this problem and found a relatively new solution : https://github.com/aaronshaf/dynamodb-admin

It has provision for GET/POST/PUT/DELETE.

Answer 2

Here is a very useful ui tool https://github.com/YoyaTeam/dynamodb-manager，It supports almost all data operations。

Answer 3

YES! I've finally found a solution after struggling with this myself:

1. Run your local dynamodb jar with the following command java -jar DynamoDBLocal.jar -dbPath . [this will create a file in whatever directory the Dynamo jar is located in].
2. Download SQLite Database Browser and extract/install it.
3. Start SQLite Database Browser
4. Navigate to "Open Database" from the file menu
5. Navigate to the directory from 1. Select the file [in this case, ****_us-east-1]
6. You should then see the database contents!!

Hope this helps - it's been frustrating me no end!

!! EDIT !! - in response to original question edit.

Doubts

1) Do I have to run a SQL to see table data? I thought there would be GUI for this.

2) I am not able to use where clause in SQL. What if I want to see one or two records from all? Is there a way to use conditions in this?

3) All fields of a row is not visible and I am not able to scroll it horizontally ?

1. Yes - you can do a simple "select" statement, for instance in my examples: "SELECT * FROM tweet_item" returns me the following screenshot:

2. Seemingly inadvertanyl - whilst I couldn't get the direct SELECT * FROM XX WHERE XX to work, the like statement does. For instance SELECT * FROM tweet_item where tweet_item.hashKey like "%425665354447462400%" returns me the tweet with tweet_id [my hashKey] of 425665354447462400:

3. Strange - I seem to be able to scroll quite happily [although it is Windows not Mac]. It also automatically tries to re-size the outer frame, too.

Answer 4

Although its a paid product, which is a bummer, RazorSQL now supports DynamoDB as well, and does let you change the AWS endpoint to point to a local installation.

The mac version (with a free trial) is available here: http://razorsql.com/download_mac.html