Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

Entity Framework (EF) Core is a lightweight, extensible, open source and cross-platform version of the popular Entity Framework data access technology. EF Core can now serve as an object-relational mapper (O/RM) for Google Cloud Spanner using its open source provider. …


Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

One of the advantages of working with a relational database is the large set of standard tooling available. Cloud Spanner now also offers integration with the popular Visual Studio Code extension SQL Tools. This integration enables you to execute queries, DML statements and DDL statements directly from Visual Studio Code.

Installing

Before you can install…


Google Cloud Spanner Change Watcher is an open-source library for Google Cloud Spanner for watching and publishing changes from a Cloud Spanner database. The library supports different standard implementations for watching tables for changes. The examples in this article require version 1.1.0 or higher of Spanner Change Watcher.

One of the most important aspects when using Spanner Change Watcher is how to keep the queries that watch the table(s) for changes as efficient as possible. Adding a secondary index for the commit timestamp column is one of the most-used options. This comes with the drawback that it can become a…


Google Cloud Spanner Change Watcher is an open-source library for Google Cloud Spanner for watching and publishing changes from a Cloud Spanner database. The examples in this article require version 1.1.0 or higher of Spanner Change Watcher.

The library comes with a sample Benchmark application that can be used to try out different configurations for a Change Watcher to test the corresponding performance and load. The benchmark application uses a single example table with a secondary index that are both automatically created by the benchmark application for simplicity.


Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

One of the advantages of working with a relational database is the large set of standard tooling available. Cloud Spanner includes a JDBC driver that has been added as an extension to DBeaver. This means that you can query and update data in a Cloud Spanner database using DBeaver without the need for any…


Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

Queries in Cloud Spanner can be executed using a streaming RPC. The NodeJS client library uses this streaming API to return query results as standard NodeJS streams. These streams can be piped together with other streams to write the data to some other output, and NodeJS will automatically apply back pressure to the read…


Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

Google Cloud Spanner
Google Cloud Spanner

The open source spanner-change-watcher library can monitor and publish events for data changes in a Cloud Spanner database as an in-process service of a Java application. A general introduction to this library can be found here.

This article describes how Spanner Change Watcher can be used to watch a table that does not contain


Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

Google Cloud Spanner
Google Cloud Spanner
Google Cloud Spanner

Multiple applications and services can interact with the same Cloud Spanner database simultaneously, and a common pattern is for one service to trigger other services based on certain events, such as inserting or updating a record in a database. …


Google Cloud Spanner is a fully managed, scalable, relational database service for regional and global application data. It is the first scalable, enterprise-grade, globally-distributed, and strongly consistent database service built for the cloud specifically to combine the benefits of relational database structure with non-relational horizontal scale.

Google Cloud Spanner
Google Cloud Spanner
Google Cloud Spanner

Multiple applications and services can interact with the same Cloud Spanner database simultaneously, and a common pattern is for one service to trigger other services based on certain events, such as inserting or updating a record in a database. …

Knut Olav Løite

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store