Sha256: 77a976968b919faf91026dd59a027836a7e0cb7ecbebdfbe2032c7895600036a

Contents?: true

Size: 1.2 KB

Versions: 22

Compression:

Stored size: 1.2 KB

Contents

# Sample - Stale reads

Read and query operations outside of a transaction block will by default be executed using a
single-use read-only transaction with strong timestamp bound. This means that the read is
guaranteed to return all data that has been committed at the time of the read. It is also possible
to specify that the Spanner ActiveRecord provider should execute a stale read. This is done by
specifying an optimizer hint for the read or query operation. The hints that are available are:

* `max_staleness: <seconds>`
* `exact_staleness: <seconds>`
* `min_read_timestamp: <timestamp>`
* `read_timestamp: <timestamp>`

See https://cloud.google.com/spanner/docs/timestamp-bounds for more information on what the
different timestamp bounds in Cloud Spanner mean.

NOTE: These optimizer hints ONLY work OUTSIDE transactions. See the read-only-transactions
samples for more information on how to specify a timestamp bound for a read-only transaction.

The sample will automatically start a Spanner Emulator in a docker container and execute the sample
against that emulator. The emulator will automatically be stopped when the application finishes.

Run the application with the command

```bash
bundle exec rake run
```

Version data entries

22 entries across 22 versions & 1 rubygems

Version Path
activerecord-spanner-adapter-2.0.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.8.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.6.3 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.6.2 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.6.1 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.6.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.5.1 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.5.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.4.4 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.4.3 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.4.2 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.4.1 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.4.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.3.1 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.2.2 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.2.1 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.2.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.1.0 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.0.1 examples/snippets/stale-reads/README.md
activerecord-spanner-adapter-1.0.0 examples/snippets/stale-reads/README.md