Amazon DynamoDB vs SingleStore (formerly MemSQL)

• It's very easy to get started, creating a table with a partition/sort key and you're on your way.
• You can scale up and down your read/write IO as needed.
• You can store structured and unstructured data.
• It works great with Web Development as it's JSON based.

Read full review

• Ease of use (installation, managed service, pipelines)
• Hybrid configuration (on-premise & cloud), analytical and transactional workload
• ANSI SQL as a standard
• Runs on any major cloud platform

Read full review

• Complex searching (no support for case-insensitive or full-text search).
• Only supports up to two-key indexes.
• Requires choosing the indexes up-front when doing searches.
• Does not have an SQL compatible query front-end.
• No join-table support (requires putting all data into one table).

Read full review

• Does not provide adequate support for data discovery apps, i.e. Power BI.
• It would be great to have a native load balancing component for dealing with aggregator failure. Otherwise having a Child Aggregator becomes optional since not all the customers can afford an external balancing solution and does not feel confortable with switching between aggregators manually.
• They used to have certifications and training in development and administration. That is very important to have, since other competitors does provide access to those sort of things and although they have free tutorials/videos, that doesn't provide an in-depth understanding.

Read full review

• Since the Amazon manages the instance, the amount of time a developer needs to spend configuring the database is less. For comparison, if we were to manage the same instance manually, we need to set up EC2 instance, install the DB, setup backup scripts, track backup failures, which is a great overhead for the dev. Using DynamoDB this overhead is reduced and hence having a great ROI.
• Great documentation and easy setup makes an easy learning curve to transition to DynamoDB. Only caveat is as with any database, the data structure should be thoroughly analyzed for types of querying because there are limitations with the DynamoDB API.
• Ties very well with rest of the Amazon eco system. Having rest of the applications in Amazon allows managing the application security a breeze.

Read full review

• License cost is lower than many of its competitors.
• Requires very little administration. We are getting by without even hiring an admin.
• Integrating the pipelines and the DB engine simplifies the solution architecture, which means less infrastructure is needed, less license cost, and shorter development cycle.

Read full review