


In SQL, we have indexes whereas in case of dynamoDB, local secondary indexes exists. The mandatory attribute is called as partition key and the optional attribute is called as a sort key. SQL tables have primary keys that can have several columns whereas dynamoDB tables have a primary key that can have minimum one and maximum two attributes. SQL tables have rows and tables and dynamoDB tables have items and attributes. In SQL's we have tables and in DynamoDB, we have tables as well. With DynamoDB accelerators and tags caching services, you can bring down these response times further into microseconds.ĭynamoDB provides seamless scaling and predictable performance is serverless cloud database meaning you don't have to specify how many servers's you need or what kind of backend infrastructure you need, all you must tell them dynamoDB is how many tables reads and writes your application perform per second and that's it and you are good to go with dynamoDB.īefore we get into dynamoDB integration with Nodejs, let's quickly compare SQL and NoSQL technologies. The goal of this blog to understand about AWS DynamoDB database and connect the Nodejs application with AWS DynamoDB database in AWS Lambda environment.Īmazon DynamoDB is a fast high-performance cost-effective serverless NoSQL database that can scale on demand to support the virtually unlimited number of read-write operations with response times under single milliseconds.
