Description:

  • Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability.
  • database tables that can store and retrieve any amount of data and serve. scale up or scale down the table’s throughput capacity without downtime or performance issue. AWS Management Console to monitor resource utilization and performance metrics.
  • DynamoDB provides on-demand backup capability.
  • create on-demand backups and enable point-in-time recovery for Amazon DynamoDB tables. Point-in-time recovery helps protect the tables from accidental write or delete operations. With point-in-time recovery, you can restore a table to any point in time during the last 35 days.
  • DynamoDB allows to delete expired items from tables automatically to help you reduce storage usage and the cost of storing data.
  • High availability and durability

Use the below link to install AWS Dynamodb:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.html

 

To set up DynamoDB v1.x on your computer

  1. Download DynamoDB local v1.x for free from one of the following locations.

Zip for windows platform Tar.gz for Linux platform

 

  1. Note: To run DynamoDB on your computer, you must have the Java Runtime Environment (JRE) version 8.x or newer. The application doesn’t run on earlier JRE versions.
  2. After you download the file, extract the contents and copy the extracted directory to a location of your choice.
  3. To start DynamoDB on your computer, open a command prompt window, navigate to the directory where you extracted jar, and enter the following command.

E:\Dynamodb>

java -Djava.library.path=./DynamoDBLocal_lib -jar DynamoDBLocal.jar –sharedDb

 

DynamoDB uses port 8000 by default.

  • It will be connecting untill we stop it. To stop DynamoDB, press Ctrl+C at the command prompt.

AWS Command Line Interface

Designation:

  • The AWS Command Line Interface (AWS CLI) is an open source tool that enables you to interact with AWS services using commands in your command-line

Kindly use the below link to download.

Link: https://aws.amazon.com/cli/

Step 1: Click on Next

Step 2: Click on Next

Step 3: Accept the license and click on next

Step 4: Click on Install

Step 5: Installation progress

Step 6: Click on Finish

Before you can access DynamoDB programmatically or through the AWS Command Line Interface (AWS CLI), you must configure your credentials to enable authorization for your applications.

Downloadable DynamoDB requires any credentials to work, as shown in the following example.

 

AWS Access Key ID: “fakeMyKeyId”

AWS Secret Access Key: “fakeSecretAccessKey”

Default region name: us-west-2

Default output format: json/table/text

 

Execute command: aws configure

Use the following command to list DynamoDB tables

aws dynamodb list-tables –endpoint-url http://localhost:8000

Table creation:

aws dynamodb create-table –table-name Music –attribute-definitions AttributeName=Artist,AttributeType=S AttributeName=SongTitle,AttributeType=S –key-schema AttributeName=Artist,KeyType=HASH AttributeName=SongTitle,KeyType=RANGE –provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5 –table-class STANDARD –endpoint-url http://localhost:8000

Now, List the table using the following command.

aws dynamodb list-tables –endpoint-url http://localhost:8000

NoSQL workbench for Dynamodb

Designation:

  • NoSQL Workbench for Amazon DynamoDB is a cross-platform.
  • client-side GUI application that you can use for modern database development and operations.
  • It’s available for Windows, macOS, and Linux.
  • NoSQL Workbench is a visual development tool that provides data modeling, data visualization, and query development features to help you design, create, query, and manage DynamoDB tables.
  • NoSQL Workbench now includes DynamoDB local as an optional part of the installation process, which makes it easier to model your data in DynamoDB local.
  • Data modeling
  • Data visualization
  • Operation building

Step 1: Click on Next

Step 2: Installation folder

Step 3: DynamoDB local port

Step 4: Ready to install

Step 5: Installing progress

Step 6: Click on Finish

Workbench GUI:

Data Modeler:

Visualizer:

Operation Builder: (Interface-based operations)

Operation Builder: (PartiSQL operations)

Recent Posts

Start typing and press Enter to search