Amazon Athena vs. DigitalOcean

Best suited for analyzing huge amounts of data by just querying on Amazon Athena. Amazon Athena is also best to integrate with Amazon Quickight for visualization and reporting of data. Easy to work with CSV, JSON, and columnar data formats like Parquet, and ORC. Less appropriate to work with AVRO data format and also stored procedures are not supported in Amazon Athena. The size of a single row is also limited to 32 MB.

Incentivized

DigitalOcean is a powerful tool with respect to the services and pricing that it offers. It is easier than other products and also provides servers that are inexpensive with great performance. DigitalOcean also offers additional add-ons such as additional IP addresses, scheduling of backups, etc. One of the best advantages is that it is efficient and is open source. Although, it is suited for a firm that is looking to cut down cost. Also, it is not suited for an organization where the dev/platform/DBA team is less experienced.

Incentivized

• Load Balance traffic analysis
• Big data report generation
• Micro services pattern query analysis

Incentivized

• Ease of use - You can get set up with a new server in a matter of minutes. It doesn't get any easier than that.
• Support - The public forums are incredibly helpful as are the official help articles. I've never needed to contact the support team because of this. All of the information is at my fingertips.
• Pricing - We're only paying $10/mo for a solution that gives our customers more confidence in us and is a selling point for us.

Incentivized

• Every dialect of SQL has some missing functions. I wish there was automated GROUP BY options here.
• There are connection problems back to Power BI occasionally.
• If you don't watch certain queries, it's possible that it takes a long time to run and charges you a lot of money.

Incentivized

• Some products/services available on other Cloud providers aren't available, but they seem to be catching up as they add new products like Managed SQL DBs.
• While they have FreeBSD droplets (VMs), support for *BSD OSs is limited. I.e. the new monitoring agent only works on Linux.
• There are no regions available on South America.
• They don't seem to offer enterprise-level products, even basic ones as Windows Server, MS SQL Server, Oracle products, etc.

Incentivized

I've been very happy with it for my purposes and I plan to continue to use DigitalOcean for the foreseeable future!

Incentivized

Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.

Incentivized

With DigitalOcean it is very easy to start up a server/droplet. They have several templates and server images to select from, and they have good instructions on how to get a server set up and started. The monitoring tools in the dashboard look good and are easy to understand.

Incentivized

Have not found a single second of down time myself. Superior availability.

Incentivized

Very quick response and high performance, you have to fine tune configurations on your machines though.

Incentivized

They have always been fast, and the process has been straight-forward. I haven't had to use it enough to be frustrated with it, to be honest, and when I have an issue they fix it. As with all support, I wish it felt more human, but they are doing aces.

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

I chose DigitalOcean over Oracle Cloud because it's simpler, more cost-effective, and quicker to deploy. DigitalOcean’s intuitive interface allows me to manage servers easily, while Oracle Cloud is more complex and suited for larger enterprises. Also, DigitalOcean’s transparent pricing helps control costs, unlike Oracle’s more intricate and complex pricing model.

Incentivized

Great scalability, you can start with small plans and move up to premium features at a very good price.

Incentivized

• It's easy to store and query data on S3. Multiple teams can query the same data to generate their reports. It removes the need for a full-fledged data warehouse for a startup. Saves costs.
• Improved team efficiency on monitoring user activities by easy logging and reporting.
• As the dataset gets heavier on S3, one needs to understand partitioning and that leads to the requirement of expertise.

Incentivized

• DigitalOcean has very competitive egress pricing, which has been positive for reducing our costs when running services with a large amounts of data transfer
• DigitalOcean templates have helped us quickly launch services that would otherwise require a lot of configuration (saving time)
• We haven't had much in the way of negative ROI impacts using DigitalOcean as we don't use it extensively for our core product, but based on personal project experience it can require more engineering time to get up and running with than some other infrastructure services like Heroku. This has been one of the greatest barriers in pushing its adoption in our organization.

Incentivized