What is our primary use case?
Google Bigtable and Google Cloud Spanner are the same. We can forward all the Cloud SQLs on Google Cloud Spanner, which is used for integration purposes. We use Cloud SQL with Google Cloud Spanner. If you have support for Cloud SQL, the same can be used for Google Cloud Spanner. I believe the storage will be in the Firestore or Datastore.
What is most valuable?
The product's advantages revolve around its similarity to Cloud SQL storage. The same can be said about Low-Code Microsoft SQL Server. The same set of advantages is available in Microsoft and Google Cloud Spanner. The advantages are associated with the product because they were also early available in the tool, and they are all the same to this day.
What needs improvement?
The tool lacks to offer AI features. In the future, I would like the product to offer AI features to users.
Nowadays, we are creating small acronyms for our SQL Server. We put some templates. If I just put your name and stop it, the entire cloud can be explored, but such features are not there in Google Cloud Spanner. As a layman rather than a developer, if I create a tool or a procedure. If I write a procedure and then when you describe a procedure, a dummy procedure will be written for you, and it will be available for you as a template in SQL Server, but such kind features are not there in Google Cloud Spanner.
For how long have I used the solution?
I have been using Google Cloud Spanner for three to four years.
What do I think about the scalability of the solution?
It is a very scalable solution. You can increase the number of node as much as you want. It depends upon the region where you stay.
How are customer service and support?
The support is excellent with Google.
How was the initial setup?
You need to know how to deploy it. You need to have the GCP certification. Once you have a GCP certification, then it won't take much time to deploy the application. Unless you have a deployed GCP-certified employee, you will need to study GCP very well. There is a lot of focus needed to study Google and its cloud functions are there, the App Engine Application Platform is there, and then there are Kubernetes, which is for containers. You put all your applications in Kubernetes. You need to study Google Cloud Spanner to be able to maintain the data and everything. If you know everything, then Google Cloud is better compared to Azure. I have been using Google Cloud for a very long time; I prefer Google Cloud for everyone over Azure.
Only one person is required to deploy the product.
If you know how to deploy the product, then maximum within a day, you finish the deployment process. If the configurations and everything are done, it won't take much time. You just deploy the application. The time required to deploy the product also depends on the region where the tool will be used. Suppose we are doing employment in the Asia Pacific region. In that case, the tool should only be accessed in that region, but if you are going to access the same in North America and all, you need to know how to deploy the tool as per the timings in the North American region while also taking care of GCP. If your application is running only in Asia, you can deploy the application in the Mumbai region, which is in the Asia Pacific region. When you see the same application running in Northern America, you need to consider the same for the Northern America region in the GCP cloud, and such a consideration is something you should have before you start with the deployment.
What's my experience with pricing, setup cost, and licensing?
Price-wise, I heard that Google Cloud Spanner is on the higher side. I am not sure if this is a rumor or if it's fake news, but I believe that having BigQuery and GCP together could be a little costly compared to other tools like Azure. In the product, if I look at the advantages, I can see that the tool has speech recognition, translation, machine learning, and everything else is accessible in GCP. I am using Google Cloud, and I know which features are already there in the tool. When you are using all the tools, you need to pay for them.
What other advice do I have?
Performance-wise, the tool is working fine. With the tool, the trigger is not there. That is one of the things I noticed, as we cannot see or create a trigger. It is not possible to create a trigger, update a trigger, or delete a trigger. There could be some alternative in Google Cloud Spanner to create the trigger and all. Definitely, there must be some solution and I am very eager to explore such areas.
If you ask me, I would say that I can easily maintain the product because I know about it if somebody is not aware of how to configure or how to do App Engine's configuration in Google Cloud, where App Engine and Kubernetes are core parts of the application. If you know App Engine and Kubernetes, then you can maintain it easily. Google Stackdriver allows you to trace all your configurations.
There are a lot of features in Google products. Firstly, try to explore all the features before start to use the tool since then only you can use it. All the features are available in the tool and one should not doubt over why one can't utilize them.
I rate the tool a nine out of ten.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google