Scratch Data

Scratch Data is a wrapper that lets you stream data into and out of your analytics database. It takes arbitrary JSON as input and lets you perform analytical queries.

Quickstart

1. Run the server

Clone the repo:

$ git clone git@github.com:scratchdata/scratchdata.git
$ cd scratchdata

Start the service:

$ go run .

With no configuration, this will automatically set up a local DuckDB database ready for reading and writing.

Run without default config

Create a config.yaml file with all of your settings and run:

$ go run . config.yaml

2. Insert JSON data

$ curl -X POST "http://localhost:8080/api/data/insert/events?api_key=local" \
    --json '{"user": "alice", "event": "click"}'

The "events" table and columns are automatically created.

3. Query

curl -G "http://localhost:8080/api/data/query" \
     --data-urlencode="api_key=local" \
     --data-urlencode="query=select * from events"

Next Steps

To see the full list of options, look at: https://docs.scratchdata.com