ScratchDB is a wrapper around Clickhouse that lets you input arbitrary JSON and perform analytical queries against it. It automatically creates tables and columns when new data is added.

$ go run scratch ingest

$ go run scratch insert

$ curl -X POST http:https://localhost:3000/data \
    -H 'Content-Type: application/json' \
    -d '{"table":"my_table","data":{"fruit": "apple"}}'

To view data in JSON format:

http:https://localhost:3000/query?q=select * from my_table

To view data in an HTML table:

http:https://localhost:3000/query?format=html&q=select * from my_table