While using TiDB Cloud, I noticed things I don't like as a developer. For instance, it doesn't support functions and procedures, which Oracle and other databases do. This means that for table-to-table operations, like data manipulation and functionality, I need to take that data to the application side, process it manually, and then re-insert it. Oracle and other databases have functions and procedures to handle this within the database itself. This is a key feature that I, as a developer, would like to see in TiDB Cloud. We are implementing our product for a major bank in Malaysia and setting up a disaster recovery environment. The client requires the ability to replicate auto-increment sequences from the production environment to the disaster recovery environment. This is not currently possible. We had a call with TiDB, and they said this feature is not available. They advised us to handle the auto-increment indexes from the application side. This means we are doing most things from the application side, which is a challenge we face with TiDB.
If you are using a product managed by a cloud provider, such as AWS or Google Cloud, you benefit from various management tools. For instance, AWS offers CloudWatch for tracking metrics, while Google Cloud provides Time Series Insights. These tools are managed by the cloud providers. As an end user, you primarily need to pay for the service, and the cloud provider handles most of the management tasks. If you choose to use open-source tools like Prometheus, you will need to manage them yourself. It's a trade-off between convenience and cost. Opting for a managed service means you pay more but have less management overhead. On the other hand, using open-source solutions can reduce costs but requires you to handle the entire management of the infrastructure and database, such as ensuring uptime and provisioning resources. TiDB Cloud offers a reliable, managed solution that ensures availability and performance without the hassle of self-management.
DBaaS offers scalable database management hosted in the cloud, eliminating the need for physical infrastructure. It is tailored for efficient data handling, providing flexibility and cost-effectiveness for businesses seeking streamlined data operations. Database as a Service provides organizations with managed database solutions, effectively reducing the complexity associated with traditional database management. Companies opting for DBaaS benefit from its scalability, automated backups,...
While using TiDB Cloud, I noticed things I don't like as a developer. For instance, it doesn't support functions and procedures, which Oracle and other databases do. This means that for table-to-table operations, like data manipulation and functionality, I need to take that data to the application side, process it manually, and then re-insert it. Oracle and other databases have functions and procedures to handle this within the database itself. This is a key feature that I, as a developer, would like to see in TiDB Cloud. We are implementing our product for a major bank in Malaysia and setting up a disaster recovery environment. The client requires the ability to replicate auto-increment sequences from the production environment to the disaster recovery environment. This is not currently possible. We had a call with TiDB, and they said this feature is not available. They advised us to handle the auto-increment indexes from the application side. This means we are doing most things from the application side, which is a challenge we face with TiDB.
If you are using a product managed by a cloud provider, such as AWS or Google Cloud, you benefit from various management tools. For instance, AWS offers CloudWatch for tracking metrics, while Google Cloud provides Time Series Insights. These tools are managed by the cloud providers. As an end user, you primarily need to pay for the service, and the cloud provider handles most of the management tasks. If you choose to use open-source tools like Prometheus, you will need to manage them yourself. It's a trade-off between convenience and cost. Opting for a managed service means you pay more but have less management overhead. On the other hand, using open-source solutions can reduce costs but requires you to handle the entire management of the infrastructure and database, such as ensuring uptime and provisioning resources. TiDB Cloud offers a reliable, managed solution that ensures availability and performance without the hassle of self-management.