4 ms·

As a developer, I really have a love-hate relationship with Dynamo. I love how fast and easy it is to setup and get rolling. The partitioning scheme came off a

As a developer, I really have a love-hate relationship with Dynamo. I love how fast and easy it is to setup and get rolling. The partitioning scheme came off as confusing and opaque but I think that says more about Amazon's documentation than the scheme itself. I do not like that there's no really third party tooling integration to be able to query. Their UI in the console is _so freaking terrible_ yet you have no other way than code to query it. This problem is so bad that I will avoid using it where I can despite it being a good option, performance-wise.

ejb999 5y ago
My experience exactly.
rmbyrro 5y ago
Don't think this is a fair reason to avoid DynamoDB. There are reasonably better alternatives: - DynamoDB Workbench (free, AWS official): https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.html https://docs.aws.amazon.com/amazondynamodb/latest/developerg... - Dynobase (paid, third-party): https://dynobase.dev/ https://dynobase.dev/
- belter 5y ago
  Plus there is the local install ( Only for Dev and Testing purposes...) "Deploying DynamoDB Locally on Your Computer" https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.DownloadingAndRunning.html https://docs.aws.amazon.com/amazondynamodb/latest/developerg...
deleted 5y ago
[deleted]
wnolens 5y ago
Yes the console UI is mind numbing, and was just made 10x worse in a recent redesign. But i like the python boto3 library https://boto3.amazonaws.com/v1/documentation/api/latest/guide/quickstart.html https://boto3.amazonaws.com/v1/documentation/api/latest/guid... Build yourself a few wrappers to make querying more convenient, and i query straight from a python repl pretty effectively
62951413 5y ago
* SQL support is so new (https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-can-use-a-sql-compatible-query-language-to-query-insert-update-and-delete-table-data-in-amazon-dynamodb/ https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-c...) I have not seen it used in real life yet. * No way to "DELETE * FROM T"

ejb999 5y ago

My experience exactly.

rmbyrro 5y ago

Don't think this is a fair reason to avoid DynamoDB. There are reasonably better alternatives: - DynamoDB Workbench (free, AWS official): https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/workbench.html https://docs.aws.amazon.com/amazondynamodb/latest/developerg... - Dynobase (paid, third-party): https://dynobase.dev/ https://dynobase.dev/

belter 5y ago
Plus there is the local install ( Only for Dev and Testing purposes...) "Deploying DynamoDB Locally on Your Computer" https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.DownloadingAndRunning.html https://docs.aws.amazon.com/amazondynamodb/latest/developerg...

deleted 5y ago

[deleted]

wnolens 5y ago

Yes the console UI is mind numbing, and was just made 10x worse in a recent redesign. But i like the python boto3 library https://boto3.amazonaws.com/v1/documentation/api/latest/guide/quickstart.html https://boto3.amazonaws.com/v1/documentation/api/latest/guid... Build yourself a few wrappers to make querying more convenient, and i query straight from a python repl pretty effectively

62951413 5y ago

* SQL support is so new (https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-can-use-a-sql-compatible-query-language-to-query-insert-update-and-delete-table-data-in-amazon-dynamodb/ https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-c...) I have not seen it used in real life yet. * No way to "DELETE * FROM T"