Lots of CSVs

Lots of CSVs (lotsofcsvs) is a small data warehouse built with CSV, HTTP, and SQLite as its interface. It is intentionally as barebones as possible. It aims to be a simple API for recording and fetching data that works with everything.

# Documentation: The API

# Get a dataset as CSV

# dataset/names/can/be/paths/like/this.csv so you can use them for organization

curl -H "authorization: Bearer <token>" /u/user_name/path/to/cool_data.csv

# Append to the dataset

# You can post as many rows as you want.

# Use the header=present (or header=absent) variable in the mimetype.

# When in doubt follow https://www.rfc-editor.org/rfc/rfc4180

# If you are appending to a dataset that doesn't exist it will be created.

# You must send the CSV headers the first time you post to it.

# Otherwise lotsofcsvs has to guess at the names and we're not doing that.

# If you need a CSV to test with, we have one.

curl -o example.csv https://www.lotsofcsvs.com/example.csv

cat example.csv | curl -X POST -H "Content-Type: text/csv; header=present"  -H "authorization: Bearer <token>" \

     https://www.lotsofcsvs.com/u/<your_username>/example.csv --data-binary @-

# The .csv suffix is optional and you can use paths to name you datasets.

cat example.csv | curl -X POST -H "Content-Type: text/csv; header=absent"  -H "authorization: Bearer <token>" \

     https://www.lotsofcsvs.com/u/<your_username>/totally/going/to/delete/example --data-binary @-

# Exporting your whole dataset (coming soon)

# as a SQLite DB

curl -H "authorization: Bearer <token>" /u/user_name.sqlite

# As a zip file of CSVs

curl -H "authorization: Bearer <token>" /u/user_name.zip

# As a tarball of CSVs

curl -H "authorization: Bearer <token>" /u/user_name.tar.gz