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.
Clone the repo:
$ git clone git@github.com:scratchdata/scratchdata.git
$ cd scratchdataStart the service:
$ go run . With no configuration, this will automatically set up a local DuckDB database ready for reading and writing.
Create a config.yaml file with all of your settings and run:
$ go run . config.yaml$ 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.
curl -G "http://localhost:8080/api/data/query" \
--data-urlencode="api_key=local" \
--data-urlencode="query=select * from events" To see the full list of options, look at: https://docs.scratchdata.com