Download the PHP package dataground/bq-jsonstore without Composer
On this page you can find all versions of the php package dataground/bq-jsonstore. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package bq-jsonstore
BigQuery JSON Store
Generic BigQuery immutable, append only storage for arbitrary versioned JSON items by unique key. Turns BigQuery into a schemaless immutable JSON datastore capable of handling huge datasets.
Installation
composer install dataground/bq-jsonstore
Write data
Read data / Access JSON attributes
Data can be accessed in SQL using JSON_EXTRACT() and JSON_EXTRACT_SCALAR() functions. Check bigquery documentation for more info.
Known Issues
This approach does not support updating or deleting items (same uid's) multiple times in one revision. Doing this wil lead to unexpected results. To update or delete data, use a separate revision.
TODO
-
Autocreate [table]_last view on dataset creation
- To read latest combined data use the autocreated view
[mytable]_current
(for incremental loads). - To read last imported revision of data use the autocreated view
[mytable]_last
(for full loads).
- To read latest combined data use the autocreated view
- Prevent multiple uid updates per revision
- Check revision allready exists
- Add unittests
- More documentation
All versions of bq-jsonstore with dependencies
google/cloud Version ^0.37
monolog/monolog Version ^1.23
stephenhill/base58 Version ^1.1