InfluxDB vs. Oracle Autonomous Transaction Processing

InfluxDB is a time series database and should be used in that intent. Each data ingestion streams should be properly configured to ensure optimal database performance. InfluxDB works very well but like any other databases requires maintenance and tuning. We have been using the TICK stack and are very happy with the results.

Incentivized

If your company's value is not increased by maintaining databases, you should use the ATP.

• Time series data
• Very fast queries
• Many options to configure and tune database

Incentivized

• Quick and simple to deploy (less than 5 steps to create a new instance)
• No administrative tasks (backup, re-sizing) required

Incentivized

• Small, but growing community - This database engine's community is much smaller than alternatives. This can make finding a DBA or support less easy, but not impossible.
• Documentation could be improved - The docs for getting started don't effectively lead first-time users to understand how the underlying systems are designed.
• Performance Analysis - There seems to be a lack of tools to give context to slow queries or other performance issues
• Out-of-the-box security - The out of the box security is designed to operate in an internal network and is limited.

Incentivized

• Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly
• The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections

InfluxDB is a near perfect product for time series database engines. The relatively small list of cons are heavily outweighed by it's ability to just work and be a very flexible and powerful database engine. The community and support provided by the corporation are the only areas I have little experience.

Incentivized

You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.

Incentivized

We have worked with the InfluxDB support team a few times so far and it has been positive. Issues submitted are worked on promptly and we have good feedback.

Incentivized

We have looked around to find different options we had when we first started to move to cloud. At that time, the options we had is Google Cloud BigTable and InfluxDB. But quickly we realized that InfluxDB is the database specialized in time series database and performs better than other options we have.

Incentivized

Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.

Incentivized

• Provided us a time series DB.
• With the SQL-like language, it is very easy to learn.
• Empowered us to keep track of our events.

Incentivized

• Approx 100 times faster spin up than manual setup of an Oracle DB
• 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates