Amazon Athena vs. DigitalOcean Droplets

If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

Incentivized

DigitalOcean Droplets are the best choice for developers teams that need reliable Linux servers to deploy their projects, the ability to create a droplet for testing purposes then destroy it, and only get charged for the few hours used makes the chances of messing up very slim. DigitalOcean Droplets is a great solution because the servers are scalable and the process of adding more resources like CPU or RAM to an existing droplet takes only a few minutes and once a server is scaled up it can also be scaled down if necessary which is perfect for supporting a temporary peak in traffic for example.

Incentivized

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

Incentivized

• Simplicity to scale services--the interface is very quick and effective to use
• Reliability--this is key for us, as any downtime effects our reputation
• Keeps the costs down--hosting our own equivalent infrastructure would cost a lot more

Incentivized

• Query manager can incoperate GUI based query designer
• Auto-completion engine sometimes overwrite the query
• Time range selection should be implicit

Incentivized

• In terms of an availability zone, they have limitations not available in most of the geographical locations.
• No live support is available which can cause problem if you have outage.
• Number of service is quite limited.

Incentivized

Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

Incentivized

DigitalOcean Droplets is continuously evolving to be more and more powerful. It has great features and has low cost options, which is really great for developers. Its CDN, Loadbalancer, etc. make it a good place to host a high-traffic application. Moroever, DigitalOcean Droplets has a nonprofit program that helps nonprofit sites to run their infrastructure, which is tremendous and no competitor of DigitalOcean Droplets does that.

Incentivized

• Easy to query terabytes of data with faster response
• Pricing model is also cheap
• No indexing and partitioning

Incentivized

• Digital Ocean has been great helping us move web apps to the cloud
• Digital Ocean has been really helpful when hiring contractors
• The interface could use some work, but overall its not terrible

Incentivized