DynamoDB client in local with UI like PHPMyAdmin
YES! I've finally found a solution after struggling with this myself:
- 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]. - Download SQLite Database Browser and extract/install it.
- Start SQLite Database Browser
- Navigate to "Open Database" from the file menu
- Navigate to the directory from 1. Select the file [in this case, ****_us-east-1]
- 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 ?
Yes - you can do a simple "select" statement, for instance in my examples: "SELECT * FROM tweet_item" returns me the following screenshot:
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: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.
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.