python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to use pessimistic_write lock with Spanner using Spring boot JPA/hibernate
I am using spanner database with Spring boot and JPA.
I have a requirement like, whenever employee information is read from employee table, no-one can read/update/delete the the same row information u...
Nayan Bijagare
Votes: 0
Answers: 1
How to refer a temporary table inside EXTERNAL_QUERY() function of the GCP BigQuery?
ERROR IMAGE HERE
I'm working with EXTERNAL_QUERY function of the GCP BigQuery. The idea is to retrieve data from two separate GCP Spanner databases and process this data in one big SQL query. EXTERNAL...
Igor Popov
Votes: 0
Answers: 2
Is there some way to have an INSERT into one table always also INSERT into another table in SQL?
I have two tables that are related to one another. For simplicity let's define them as products and productVariants:
CREATE TABLE products (
id STRING(64) NOT NULL,
name STRING(64) NOT NULL,
pri...
Christiaan Louw
Votes: 0
Answers: 1
Is there a (key:value) pair datatype that can be used as a column in SQL - Specifically Google Cloud Spanner?
Given the scenario that I would like to store sales of a store in a table in a database in Google Cloud Spanner. That table would (in addition to the sale ID as the primary key) have to store a list o...
Christiaan Louw
Votes: 0
Answers: 1