DynamoDB client in local with UI like PHPMyAdmin

keen picture keen · Dec 31, 2013 · Viewed 7.9k times · Source

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

Al Sweetman picture Al Sweetman · Jan 21, 2014

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 Open Database
  5. Navigate to the directory from 1. Select the file [in this case, ****_us-east-1] Open database
  6. You should then see the database contents!! 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: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: enter image description here

  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. enter image description here