ontodev / sprocket

BSD 3-Clause "New" or "Revised" License
0 stars 1 forks source link

Implement basic table reads to TSV format #1

Closed jamesaoverton closed 3 years ago

jamesaoverton commented 3 years ago

Following the basic design of PostgREST, the first step is to read data from a table GET <http://localhost:5000/{table}> should run a simple SELECT * FROM {table} LIMIT 100 against a SQL database and return data in TSV format (including the header row).

I would like to use SQLAlchemy to allow us to support multiple SQL databases, but we can focus on SQLite for now, and the only other one I really care about is Postgres.