Although Google Cloud SQL has room for improvement by addressing a minor lack of features, its features and services keep it high among other SQL database products. It is very fast compared to others. Since it is cloud-based, maintenance is also easier. Integration capabilities are also more than expected.
MonetDB is great when you are performing adhoc queries on a large set of data. For example, if you store data in a typical RDBMS such as MySQL or Postgres and want to join large tables for analytics but the query runs unacceptably slow then MonetDB can act as a second database to offload complex queries. Based on my experience, it may not be a production-ready database since there aren't many DBAs familiar with it and due to lack of documentation, maintenance can become a little tricky.
This is an open source software so there are obvious drawbacks, the biggest of which is a lack of documentation.
MonetDB does not seem to be well known outside of the academic environment so there is less information when you are searching for answers of any type.
I'd like to see more use cases and/or best practices so that commercial companies like ours can optimally use all of its highly performant features.
The code is written in C/C++ and this can be negative if you are a mainly java-shop and need UDF - User Defined Function.
On demand scalability helps us provision extra resources as per our requirement and load on the application. Reduced cost due to fully managed services and no need to manage underlying infrastructure which reduced time of patching and maintaining underlying infrastructure. Easy to configure as per application requirements. Supports monitoring which is not available in custom hosted database instance on own computing infrastructure
GCP support in general requires a support agreement. For small organizations like us, this is not affordable or reasonable. It would help if Google had a support mechanism for smaller organizations. It was a steep learning curve for us because this was our first entry into the cloud database world. Better documentation also would have helped.
Google SQL was great as a first SQL provision. It quickly enabled the apps to be built and scaled as needed for a while. It was robust and adaptable as needed and easy to export as needed when ready, depending on growth. Cost-wise, it's a good choice and requires little investment to get going.
We have used Five9 in my previous company but on a much smaller scale. It was more expensive, however we were using it for a max of 50 employees, now we need a much bigger platform. We also used Five9 for other things, like phone dialers etc. so it was a little different.
With managed database system, it has given us near 100% data availability
It has also improved web layer experience with faster processing and authentication using database fields
Google Cloud SQL also gels up well with Google Analytics and other analytics systems for us to join up different data points and process them for deeper dives and analysis
If you are familiar with a general database concept and played with open source products before then MonetDB will give you immediate return in terms of productivity since developers can quickly develop and verify their test cases involving back-end database with a large sample data set.
There is a stiff learning curve due to lack of documentation and sparse information available on the internet.
Overall experience has been positive since MonetDB gives you another option when it comes to building out a data warehouse.
