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 ?

Hello

have you considered working with the actual DynamoDB? It has free tier usage so you shouldn't pay for playing with it. – Lout

Yes I know that 100 MB is free. Yes we are working with the actual DynamoDB. It's just we want to use local data for now. there are more people than just me so it would be better if we can use DynamoDB in local with some kind of UI. Let me know if you have any tool in mind that supports this. – Hello

Responded in answer to your latest Edit as best as I can. Quick answer: 1 - Yes there is, or you can use the tabs. 2 - You can, see example in Answer edit. 3 - See screenshot. – Bouillabaisse

Answer 1

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.

Bouillabaisse

I know you said "Mac" and fear not - the SQLite Browser says it supports Mac as well - don't get put off by my Windows demonstration! – Bouillabaisse

Thanks. It works. But I am still having some doubts in this. I edited my question Please have a look at it. – Hello

Hope they release new version for MAC with horizontal scrolling feature. Thanks for your help. – Hello

You may also try the web version of the tool here github.com/webavatar/dynamo-ui – Coactive

Answer 2

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.

Cuenca

This is a great solution and is easy to use with Docker via amazon/dynamodb-local – Circumpolar

Answer 3

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

Belshin

Required AWS Access and Secret Keys can be set to any string in case of DynamoDbLocal in RazorSQL connection profile. – Gearing

Answer 4

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

Collum

This is really a comment, not an answer. With a bit more rep, you will be able to post comments. Thanks! – Denim

Answer 5

For Eclipse users:

Amazon provides AWS Toolkit for Eclipse IDE. It can view local and cloud databases. Also if you are using different regions, it has ability to choose from different regions. You can create attributes, add keys etc.. For installation follow this link: http://docs.aws.amazon.com/toolkit-for-eclipse/v1/user-guide/getting-started.html

Outline

Answer 6

Dynobase is new DynamoDB GUI Client which also lets you browse and manipulate local DynamoDB instances: https://dynobase.dev/dynamodb-local-admin-gui/

Unfortunately, it's paid but there's free 7-days trial, works on Mac, Windows and Linux: https://dynobase.dev/

Nostrum

Found a similar tool which supports indexes as well github.com/webavatar/dynamo-ui – Coactive