本地的DynamoDB客户端，具有PHPMyAdmin之类的UI [英] DynamoDB client in local with UI like PHPMyAdmin

问题描述

我正在使用DynamoDB的zend框架中创建Web服务。因此，我在本地安装了DynamoDB。但这并不容易使用。即使出于目的插入数据和更新任何数据以进行测试，我也必须编写脚本。

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.

是否有可用于MAC的DynamoDB客户端？我们可以在其中从UI中插入/更新/删除数据。

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

编辑

疑问

1）是否必须运行SQL才能查看表数据？我以为会有图形用户界面。

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

2）我无法在SQL中使用where子句。如果我想查看全部的一两个记录怎么办？

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）一行的所有字段都不可见，并且我无法水平滚动它吗？

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

推荐答案

是的！我自己为此苦苦挣扎后终于找到了解决方案：

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

1. 使用以下命令运行本地dynamodb jar： java -jar DynamoDBLocal.jar -dbPath。 [这将在Dynamo jar所在的任何目录中创建一个文件]。


2. 下载导航到目录。选择文件[在这种情况下，**** _ us-east-1]
   


3. 然后您应该看到数据库内容！！
   

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!

！！编辑！ -针对原始问题的编辑。

疑问

Doubts

1）我是否必须运行SQL才能查看表数据？我以为会有
GUI。

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

2）我无法在SQL中使用where子句。如果我想从全部中看到一个
或两个记录怎么办？

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）一行的所有字段都不可见，并且我无法水平滚动
吗？ / p>

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

1. 是-您可以执行简单的选择语句，例如在我的示例中： SELECT * FROM tweet_item返回以下屏幕截图：

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

看似inadvertanyl-虽然我无法直接使用SELECT * FROM XX WHERE XX进行工作，但是like语句确实可以。例如 SELECT * FROM tweet_item，其中tweet_item.hashKey之类的％425665354447462400％ 向我返回tweet_id [my hashKey]为425665354447462400的tweet：

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:

奇怪-我似乎可以滚动很多高兴地[尽管它不是Windows，而不是Mac]。它还会自动尝试调整外部框架的大小。

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.

这篇关于本地的DynamoDB客户端，具有PHPMyAdmin之类的UI的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！