arattian/dynamodb-gui-client

DynamoDb GUI Client

dynamodb-gui-client's Issues

support for Multiple Filter Params

I thank god, when I found this repository! I personally feel this is much better compared to what aws has :D

Is your feature request related to a problem? Please describe.
I'm always frustrated when I looked at the filtering param only support 1 filter

Describe the solution you'd like
It would be cool, if I could add how many filter that I want with maximum up to 5 filter

Sort lost on Refresh, Cancelled Scan looses Row-Count setting

Describe the bug
Two similar issues:

1. When using "refresh table", column sort gets reset.
2. When cancelling/resetting "scan" (removing parameter), the row-count setting gets reset...note that it still displays it, just does not observe/negates it.

To Reproduce
Steps to reproduce the behavior #1:

1. Sort table
2. Click on 'refresh table'
3. Observe sorting not apply and disappear from display

Steps to reproduce the behavior #2:

1. Set row count setting on the bottom to something other than the default 15 and/or click "No Limit" checkbox.
2. Add a scan parameter and scan the table
3. Click on 'X' to remove the parameter
4. Observe newly scanned/refreshed table limited by default row count of 15, independent of what the original setting in 1 was set to.
5. Note that if you've set "No Limit" earlier in 1, it will still show as checked as if there is "No Limit" setting being applied, even though that is not being done.

Desktop (please complete the following information):

• OS: macOS 10.14.6
• Version: 3.3.1

How are you supposed to specify a region and access key for a local dynamodb?

I see no options for specifying anything other than the endpoint.

Long string values get invalid content

Describe the bug
Long string values can have invalid content. The issue comes from a library used by vue-json-editor.

To Reproduce
Steps to reproduce the behavior:
Demo:

Expected behavior
Long values have correct content.

Screenshots

Desktop (please complete the following information):

• OS: macOS 10.15.4
• Browser NA
• Version 3.3.1

Additional context

Please put in comments plz

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Update documents with fields with strings array leads to changes type: SS->LIST

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. View document
   { "username": "[email protected]", "grps": [ "group-id-1", "group-id-2" ] }
2. Press Save button
3. Get document with dynamoose where scheme looks like this:

const schema = new Schema({
  username: {
    type: String,
    hashKey: true
  },
 grps: {
    type: [String],
    default: []
  }
});

export default dynamoose.model<SomeInterfaceSchema, unknown>("Name", schema );

Dynamoose will fail because type of "grps" is changed from SS to LIST

Expected: step 2 should not change the type of "grps" to LIST

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: Windows
• Browser chrome
• Version [e.g. 22]

Additional context
Add any other context about the problem here

Gives "Error Network failure. Can't process your request." instead of more informative message on local db

Describe the bug
When I tried to create a new table in the local database with the wrong JSON format or wrong value format, it just gives the same error message. Instead, we should receive a more informative message as we receive in the remote database.

What I got on the local db

What I got on the remote db using the same JSON input for table creation

To Reproduce
Steps to reproduce the behavior:

1. Go to Local Database
2. Click on table creation button
3. Select "Code" to give the JSON input for table creation
4. Use this JSON

{
  "AttributeDefinitions": [
    {
      "AttributeName": "test_field",
      "AttributeType": "S"
    }
  ],
  "KeySchema": [
    {
      "AttributeName": "test_field",
      "KeyType": "HASH"
    }
  ],
  "ProvisionedThroughput": {
    "ReadCapacityUnits": 1,
    "WriteCapacityUnits": 1
  },
  "TableName": "test-db",
  "GlobalSecondaryIndexes": [
    {
      "IndexName": "",
      "KeySchema": [
        {
          "AttributeName": "",
          "KeyType": "HASH | RANGE"
        }
      ],
      "Projection": {
        "NonKeyAttributes": [
          ""
        ],
        "ProjectionType": "ALL | KEYS_ONLY | INCLUDE"
      },
      "ProvisionedThroughput": {
        "ReadCapacityUnits": 0,
        "WriteCapacityUnits": 0
      }
    }
  ],
  "SSESpecification": {
    "Enabled": false,
    "KMSMasterKeyId": "",
    "SSEType": "AES256 | KMS"
  },
  "StreamSpecification": {
    "StreamEnabled": false,
    "StreamViewType": "NEW_IMAGE | OLD_IMAGE | NEW_AND_OLD_IMAGES | KEYS_ONLY"
  }
}

Expected behavior
Error message on local DB should have a similar message as we got from remote DB.

Desktop (please complete the following information):

• OS:
  LSB Version: core-11.1.0ubuntu2-noarch:printing-11.1.0ubuntu2-noarch:security-11.1.0ubuntu2-noarch
  Distributor ID: Ubuntu
  Description: Ubuntu 20.04 LTS
  Release: 20.04
  Codename: focal

Support AWS SSO

Is your feature request related to a problem? Please describe.
It is more secure to use AWS SSO than an AccessKey

Describe the solution you'd like
Adding a remote database should offer to select the authentication option (SSO, AccessKey)

Describe alternatives you've considered
For now we have an alternative: AccessKey

Additional context
N/A

Cannot view or delete a record that contains Map data

Describe the bug
Cannot expand (view as a modal) or delete a record row that contains DynamoDB Map data.

To Reproduce
Steps to reproduce the behaviour:

1. Ensure you have a DynmoDB table that includes one attribute who's schema is of type Map.
2. Create a record with values for that map and persist it in DynamoDB
3. Navigate to the table in the DynamoDb Gui
   4.a Double click the record in the table list view
   5.a The record should display in the modal but in actuality the modal displays empty/no record data.
   4.a Click the rows trash icon in order to delete the record
   4.b Click confirm delete - it does not delete the record

Expected behavior

1. When clicking a record row, that contains 'map' data, it should display that data in the modal view.
2. When click the trash (delete icon) for a record row, that contains 'map' data, it should delete that record upon confirmation.

Screenshots

The below shows a record containing 'map' data.

The below shows what the record displays as when expanded into the modal view. You can see that it shows as empty instead of showing the nested data structure.

The delete operation does not work on this row either.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context
I'd be keen to help solve this and have started looking through the code. It just may take me a little while to get familiar with the setup and understand how Vue works.

Thank you
I just wanted to say a big thanks for this DynamoDB Gui. I tried a few alternatives before landing on this and I really appreciate the effort you have put in. It's a great client and it's a pleasure to work with. Thanks!!!

Does it support 'query' command?

Thanks for the DynamoDb-GUI-Client, I can work on dynamodb in GUI tool. I have some questions:

1. I saw 'Scan' in the tab 'Records', does it equal to 'scan' API in DDB? Does the DynamoDb-GUI-Client support 'query'?
2. Only one filter condition in the DynamoDb-GUI-Client? Can I have more filter conditions?
3. Scan or Query only on Table? Can I Scan or Query on GSI?
   All the questions refer to AWS console.
   Thanks.

Data not rendered in fields with a dot in their name

Describe the bug

Fields that have a dot in their name render empty table cells regardless of their content.

To Reproduce

1. View a table that has fieldnames containing dots.

Expected behavior

You see the data.

Screenshots

Here we see the table view, row ont_2 has no data visible in modelInfo.manufacturer.

Here we can see the detail view, and the data in the field.

Desktop (please complete the following information):

• OS: Ubuntu 18.04
• Electron build
• 95af1830ca5babfe79a9ef617954cf7f3a636dc8 (HEAD of master as of 2019-12-02T11:34 )

Additional context

No data saved at all on DynamoDB local.

Is it normal to not see any Table from the command line aws tool

test@testmac test (master) $ aws dynamodb list-tables --endpoint http://localhost:8000
{
    "TableNames": []
}

Even if I created thousands of rows on DynamoDBGui Client ?!?!?

Am i missing something ?!! Whats the goal of that tool ?!

Add an "Exit" item to the main menu, with keyboard shortcut

Is your feature request related to a problem? Please describe.

When running this app under a window manager such as i3wm, there's no way to quit the app. I have to use xkill to terminate it.
There's no menu item to exit.
There's no standard keyboard shortcut to exit.
i3wm does not (by default) provide (x) button on the title bar to close the application.

Describe the solution you'd like

Add a menu item and standard keyboard shortcut to exit the application; I would suggest CTRL-Q.

Describe alternatives you've considered

I have to use xkill to forcibly quit the app.

Question: Rewrite in progress

Hey there!

Just pulled this down and started tinkering, and it's great! The project works great for our simple usecase, but it's also built with tech we're familiar with and we'd love to contribute.

I saw in #34 you mentioned a rewrite's in progress, so we don't want to jump in and rock the boat / contribute to the wrong places. Any chance you could give us some visibility into that, or even want some additional help on it?

Support for indexes ?

Is your feature request related to a problem? Please describe.
No support for indexes makes this somewhat unusable :-(

Describe the solution you'd like
Support for global and local indexes

Additional context
Brings feature parity with the AWS console

Exposes AWS keys and secrets

Describe the bug
Remote connection option shows full AWS access key id and AWS secret access key. At least the secret should be a password field

To Reproduce
Steps to reproduce the behavior:

1. Go to the initial screen
2. Click on Remote tab
3. Type/Paste your AWS access key id and AWS secret access key in the according fields
4. Observe both of the keys being visible

Expected behavior
The AWS secret access key should not be visible. Instead, it should behave as a password field, ideally with a show/hide option.

Desktop (please complete the following information):

• OS: any
• Browser: N/A
• Version: Version 3.2.4 (3.2.4)

No eu-north-1 AWS region.

Describe the bug
My dynamoDB is hosted in Stockholm (eu-north-1), and when adding a new database, there is no eu-north-1 option.

To Reproduce
Click on add database. Under AWS region you can see there is no option for eu-north-1.

Expected behavior
I expected there to be an option for eu-north-1.

Screenshots
imgur img

Desktop (please complete the following information):

• OS: pop!_os
• Browser Firefox
• Version V2.1.1

Ability to use .aws/credentials instead of typing in the keys

Is your feature request related to a problem? Please describe.
It is frustrating to type/paste in your keys each time for each DB you want to connect.

Describe the solution you'd like
Would be great if the app allowed to select a profile from .aws/credentials instead of typing in the keys. You usually have your credentials handy in the config files for AWS.

Additional context
AWS credentials parser should probably populate the available profiles as a dropdown list.

Hi, can you support AWS_SESSION_TOKEN ?

Normally, AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY is enough. But my account is temporary，they assigned me an extra token AWS_SESSION_TOKEN. Right now i can not input AWS_SESSION_TOKEN. so please, can you support this one? thankyou！

Please upload to GitHub Releases

Please upload the AppImage for Linux to GitHub Releases rather than to Dropbox. This will make it much easier to find the download Thank you.

Custom region support

Is your feature request related to a problem? Please describe.

We use dynamodb local to work with dynamodb in our development cycle, and use a custom region of local to make sure we're really touching a local dynamo and not a remote one since local wouldn't be supported on an actual AWS dynamodb instance.

Describe the solution you'd like
Maybe a checkbox that enables a text box instead of the region dropdown to specify a custom region.

Invalid FilterExpression: Syntax error; token: "_", near: "_type"

Describe the bug
Onetable automatically creates a _type attribute, however, underscore doesn't seem to be supported in this application.

To Reproduce
Steps to reproduce the behavior:

1. Use underscore in attribute

Expected behavior
To be able to use underscore in attributes.

Screenshots

Desktop (please complete the following information):

• OS: MacOs
• Browser: Chrome
• Version 102.0.5005.61

Table not showing on dynamodb-local

Describe the bug
When using dynamodb-local on Mac OSX, a blank table is not displaying in GUI Client even though aws cli will display it

To Reproduce
Steps to reproduce the behavior:

1. Use Mac OSX and homebrew
2. Install dynamodb-local (brew cask install dynamodb-local)
3. Run dynamodb local, will default to localhost:8000, output shown:

$ dynamodb-local
Initializing DynamoDB Local with the following configuration:
Port:	8000
InMemory:	false
DbPath:	null
SharedDb:	false
shouldDelayTransientStatuses:	false
CorsParams:	*

4. Create a table. In my case it was a local node app creating the default example Music table:

     const profile = {
      region: 'us-west-2',
      endpoint: 'http://localhost:8000',
      convertEmptyValues: true,
    };

    const dynamoDb = new DynamoDB(profile);
    DynamoDB.DocumentClient(profile);

    const params = {
      AttributeDefinitions: [
        {
          AttributeName: 'Artist',
          AttributeType: 'S',
        },
        {
          AttributeName: 'SongTitle',
          AttributeType: 'S',
        },
      ],
      KeySchema: [
        {
          AttributeName: 'Artist',
          KeyType: 'HASH',
        },
        {
          AttributeName: 'SongTitle',
          KeyType: 'RANGE',
        },
      ],
      ProvisionedThroughput: {
        ReadCapacityUnits: 5,
        WriteCapacityUnits: 5,
      },
      TableName: 'Music',
    };

    return dynamoDb.createTable(params).promise();

5. With aws cli, conirm table exists:

aws dynamodb list-tables --endpoint-url http://localhost:8000
{
    "TableNames": [
        "Music"
    ]
}

6. Connect to same localhost:8000 with Gui client, will always show "Empty database", even with refreshing on TABLES menu option.

Expected behavior
Should display created blank table

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: Mac OSX Mojave
• node v8 to create table with code

Additional context
Add any other context about the problem here.

Better support for date-time

Is your feature request related to a problem? Please describe.
It is very hard to work with date-time fields (eg "query" on them). The interface already supports unix datetime as a number, but a better support for it would be appreciated. EG. I can scan for event_times > "number" 1564072758970 right now, but I have to figure out said number. Note, this is not about the string (eg 2019-07-25T20:17:45.046226) based values as those I believe are much tougher to work w/in Dynamo as it is. Similarly not covering Date and Calendar types (https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBMapper.DataTypes.html) as they don't seem to be as prevalent at this time/yet.

Describe the solution you'd like
It would be nice to be able to select it via a date-time picker (and better yet, to also have some common choices in addition to it, eg last 15 minutes and the like).

Describe alternatives you've considered
Currently using number based approach, eg. scan for event_times > "number" 1564072758970

Additional context
Add any other context or screenshots about the feature request here.

Windows build

Is there any technical issue that prevents a Windows build to be created?
I'd love to be able to use it on my Windows laptop on top of my Linux workstation.

Ability to change local url

Is your feature request related to a problem? Please describe.
The local tab only supports localhost. Using localstack, the location of dynamo could be behind a different url.

Describe the solution you'd like
Allow setting the url in the local tab.

Describe alternatives you've considered

Additional context

String scan operators are the same as number ones

Describe the bug
I can not scan a table using a string being contained, starting or ending.
It just use the numerical operator (<, >, etc...) althought I select a key containing strings and selectig the string type.

To Reproduce
Steps to reproduce the behavior:

1. Open a table
2. On the top, select string key, and change the type to string
3. Try to find contains on the second inout

Desktop (please complete the following information):

• OS: Mac Mojave 10.14.5
• Version 3.3.0

Can't paste into connection setup fields

Describe the bug
On a Mac, Shortcut keys and right-click context menus do not work for the textboxes used to create a new database connection.

To Reproduce
Steps to reproduce the behavior:

1. Opened the application as a brand new user
2. Copy your AWS Access Key ID from where-ever you have it stored
3. Click on the "Access Key Id" text box
4. Press CMD+V on your keyboard
5. Nothing happens

Expected behavior
I would expect to be able to paste in my API key information instead of having to enter it manually by hand.

Screenshots
Since nothing happens, I don't think a screenshot would show anything...

Desktop (please complete the following information):

• OS: macOS Mojave 10.14.2
• Client Version 2.1.1 and 3.0.0

Additional context
I opened the application as a brand new user, and tried to paste my AWS Access Key ID into the text box. Pressing CMD+V did nothing. I then tried to right click the box, but no menu appeared. I manually entered some random characters and pressed CMD+A, and it did not select all of the text in the textbox.

I tried this in the Access Key ID, Secret Access Key, and Database Name fields. None of them allowed me to paste or Select All using keyboard shortcuts, nor did they allow me to right click to get a context menu.

I tried this in both version 2.1.1 and 3.0.0 on a MacBook Pro running macOS Mojave 10.14.2

Build broken for contributors

Hi,
I'm using macOS to develop and I'd like to contribute.
I pulled the master branch and I got stuck with this error: nklayman/vue-cli-plugin-electron-builder#1229
Then I pulled the 2 npm updates from the branch npm_and_yarn and I'm now getting
INFO Launching Electron... App threw an error during load TypeError: electron__WEBPACK_IMPORTED_MODULE_0__.protocol.registerStandardSchemes is not a function

Would it be possible to get a clean state of this app for development?
Thank you!

The security token in the request is invalid

Describe the bug
I got the exact message in the title of the post every time I try to connect into DynamoDB in AWS.

Info of Interest

1. I'm trying to connect from this client into a federated AWS.
2. I'm using aws-okta to perform the login and the configuration of the things into AWS, I had this previously configured in my machine and the authentication has been granted, so I don't think is a permission thing.

Expected behavior
Makes login.

Screenshots

Desktop (please complete the following information):

• OS: Linux Debian 10
• Browser Firefox
• Version 68.2.0esr

Additional context
Many thanks.

Tables are deleted when I edit Databases Color.

Describe the bug
Tables are deleted when I edit Databases Color.

To Reproduce
Steps to reproduce the behavior:

1. Create a table
2. Click on Edit Databases little pen icon.
3. Choose a color from the dropdown
4. Click Save
5. Your table are gone.

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS] MacOs.
• Browser [e.g. chrome, safari] Chrome
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

Light Mode

Is your feature request related to a problem? Please describe.
Not everybody likes Dark Mode/Themes

Describe the solution you'd like
A plain jane "light" mode

Inconsistent sidebar resizing behavior

Describe the bug
When resizing the size bar, there is a max set. If you continue dragging the mouse gets far from the line, when you move it back the sidebar starts to resize back, the cursor being far from sidebar resize line.

To Reproduce
Resize the sidebar to far right and back without releasing the mouse button.

Expected behavior
The sidebar should wait for the mouse cursor to get back on the line before shrinking back.

Desktop (please complete the following information):

• OS: any
• Browser: N/A
• Version: Version 3.2.4 (3.2.4)

Error when column is reserved keyword

Describe the bug
When a column is a reserver keyword (such as 'time'), I get "Invalid FilterExpression: Attribute name is a reserved keyword; reserved keyword: time"

To Reproduce

1. Create a table with primary key named time
2. Select the "time" column condition in records window.
3. Press SCAN

Expected behavior
No error should occur

Desktop (please complete the following information):
MacOS 10.14.4

Sidebar icons sizing inconsistency

Describe the bug
When connected to a database with long table names the table icons in front of the lines have random small or big (and in between) sizes.

To Reproduce
Steps to reproduce the behavior:

1. Connect to a database
2. Create tables with short and long (very long, 2 lines or more) names
3. If not visible immediately, try to resize the sidebar
4. Observe smaller icons in front of tables with longer names and bigger icons for tables with shorter names.

Expected behavior
The icons should have the same size for all of the lines.

Desktop (please complete the following information):

• OS: any
• Browser: N/A
• Version: Version 3.2.4 (3.2.4)

Additional context
The icons are not really needed. Try removing them.

Table row count (bottom summary view) does not update on refresh

Describe the bug
The current table row count (in the bottom-right summary view) does not update on refresh/change (or updates way later?)

To Reproduce
Steps to reproduce the behavior:

1. Pull table information
2. Make note of the total count of rows displayed on the very bottom right
3. Add more records to the table
4. Refresh/rescan
5. Observe more records displayed successfully, yet the count not changing

Expected behavior
Correct count of number of rows being displayed after refresh/rescan

Screenshots

Desktop (please complete the following information):

• OS: Mac
• Browser Firefox
• Version 3.3.1

Additional context

Maximum number of tables viewable is limited

Describe the bug
I can't see the full list of tables in one region. There are 118 tables, I'm guessing I can only see the first 100.

To Reproduce
Steps to reproduce the behavior:

1. Run dynamodb-gui-client
2. configure a dynamodb database/endpoint with 100+ tables
3. click on the table selector
4. scroll to the bottom and verify the entire list of tables is there

Expected behavior
The entire list should be visible but only the first 100 or so are visible.

There are no errors listed on the console.

Desktop (please complete the following information):

• OS: MacOS Mojave
• Browser electron
• Version : 3.0.10 (3.0.10) (electron?)
• Version: either 3b328aa or what was installed with npm install -g dynamodb-gui-client. which would be dynamodb-gui-client-2.0.3.tgz.