本地 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 才能查看表数据?我以为会有 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) 一行的所有字段都不可见，我无法水平滚动它?

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!

<强>！！编辑 ！！- 回应原始问题编辑.

怀疑

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 ?

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:

看似不经意 - 虽然我无法让直接 SELECT * FROM XX WHERE XX 工作，但 like 语句可以.例如 SELECT * FROM tweet_item where tweet_item.hashKey like "%425665354447462400%" 返回 tweet_id [my hashKey] 为 425665354447462400 的推文:

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屋！