Need advice about which tool to choose?Ask the StackShare community!
Amazon DynamoDB vs Knex.js: What are the differences?
Amazon DynamoDB: Fully managed NoSQL database service. All data items are stored on Solid State Drives (SSDs), and are replicated across 3 Availability Zones for high availability and durability. With DynamoDB, you can offload the administrative burden of operating and scaling a highly available distributed database cluster, while paying a low price for only what you use; Knex.js: SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle. Knex.js is a "batteries included" SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.
Amazon DynamoDB belongs to "NoSQL Database as a Service" category of the tech stack, while Knex.js can be primarily classified under "Database Tools".
"Predictable performance and cost" is the top reason why over 53 developers like Amazon DynamoDB, while over 3 developers mention "Write once and then connect to almost any sql engine" as the leading cause for choosing Knex.js.
Knex.js is an open source tool with 9.79K GitHub stars and 1.22K GitHub forks. Here's a link to Knex.js's open source repository on GitHub.
According to the StackShare community, Amazon DynamoDB has a broader approval, being mentioned in 430 company stacks & 173 developers stacks; compared to Knex.js, which is listed in 10 company stacks and 9 developer stacks.
We are building a social media app, where users will post images, like their post, and make friends based on their interest. We are currently using Cloud Firestore and Firebase Realtime Database. We are looking for another database like Amazon DynamoDB; how much this decision can be efficient in terms of pricing and overhead?
Hi, Akash,
I wouldn't make this decision without lots more information. Cloud Firestore has a much richer metamodel (document-oriented) than Dynamo (key-value), and Dynamo seems to be particularly restrictive. That is why it is so fast. There are many needs in most applications to get lightning access to the members of a set, one set at a time. Dynamo DB is a great choice. But, social media applications generally need to be able to make long traverses across a graph. While you can make almost any metamodel act like another one, with your own custom layers on top of it, or just by writing a lot more code, it's a long way around to do that with simple key-value sets. It's hard enough to traverse across networks of collections in a document-oriented database. So, if you are moving, I think a graph-oriented database like Amazon Neptune, or, if you might want built-in reasoning, Allegro or Ontotext, would take the least programming, which is where the most cost and bugs can be avoided. Also, managed systems are also less costly in terms of people's time and system errors. It's easier to measure the costs of managed systems, so they are often seen as more costly.
Pros of Amazon DynamoDB
- Predictable performance and cost62
- Scalable56
- Native JSON Support35
- AWS Free Tier21
- Fast7
- No sql3
- To store data3
- Serverless2
- No Stored procedures is GOOD2
- ORM with DynamoDBMapper1
- Elastic Scalability using on-demand mode1
- Elastic Scalability using autoscaling1
- DynamoDB Stream1
Pros of Knex.js
- Write once and then connect to almost any sql engine11
- Faster10
- Nice api, Migrations/Seeds8
- Flexibility in what engine you choose7
- Free7
- Multi support and easy to use5
- Simple query API1
Sign up to add or upvote prosMake informed product decisions
Cons of Amazon DynamoDB
- Only sequential access for paginate data4
- Scaling1
- Document Limit Size1
Cons of Knex.js
Sign up to add or upvote consMake informed product decisions
What is Amazon DynamoDB?
What is Knex.js?
Need advice about which tool to choose?Ask the StackShare community!
What companies use Amazon DynamoDB?
Sign up to get full access to all the companiesMake informed product decisions
What tools integrate with Amazon DynamoDB?
Sign up to get full access to all the tool integrationsMake informed product decisions
Blog Posts
+17
+47+46
+30
+23+37+25+17