Host an API service

[captn3m0]

Maybe using something like CloudFlare workers or Netlify Functions. Keep it clean and simple, and support CORS.

[wolfram77]

Hello @captn3m0 is there a standard way of deploying a CSV as for example a PostgreSQL DB with an HTTP API? Maybe something like below.

wget http://csv-query.io/?csv=http://github.com/org/repo/file.csv&query=SELECT * FROM "table" ORDER BY "name" TOP 10

[captn3m0]

Easier to just expose Postgres publicly with read-only guest access, that's what crt.sh does.

There's a WIP SQLite based API in #8. I can look at providing a read-only SQLite Raw Query API.

Do you have a usecase for raw-query API?

[wolfram77]

No i have no idea of any usecase. I am just exploring ideas.

I was putting a IFCT2017 food composition query website online, there it was useful as there are many possible columns (nutrient names).