How to Use Cloud Spanner to Create and Manage NoSQL Databases

In database management cloud spanner by google cloud platform stands for powerful and highly scalable NoSQL database solution. Cloud spanner offers the consistency of traditional databases and the scalability of NoSQL databases.

Primary Technologies Used:

Cloud Spanner: A globally distributed, consistent and horizontally scalable database service offered by google cloud platform.

NoSQL database: A type of database that provides a mechanism for storage and retrieval data that is modeled.

Strong Consistency: For the database for any read operation, the most recent write operation will be available.

Horizontal Scaling: The ability to connecting multiple hardwares and softwares that they work as single logic unit.

Steps:

Create the cloud spanner instance: To create the cloud spanner instance follow up the below

Log in to the google cloud console.
navigate to the cloud spanner section.
Click the 'create instance' and fill the instance ID and configuration.

Creating the database: Create the database from google cloud spanner.

Within cloud spanner instance go to the "Databases" section.
click on "Create database" and specify the database name and schema.

Data insertion query: Use this below SQL query to insert data into cloud spanner database.

INSERT INTO Users (UserID, Username, Email) VALUES (1, 'Abcde', '[e-mail]');

In modern application cloud spanner offers a robust and scalable NoSQL database solution with flexibility and performance.