News for hackers. Stuff that matters.
Re:Show HN: Datasette – Create and publish an API for SQLite... by patricius on Tuesday November 14, 2017 @05:20AM (#15693922)
Hi. I'd like to know how you design the database to separate data available via REST and data that is not.
Re:Show HN: Datasette – Create and publish an API for SQLite... by hucker on Tuesday November 14, 2017 @07:57AM (#15694581)
We use a separate schema for the API (that way we can easily version our APIs as well). The API schemas only contain views/function that expose the tables/fields/etc that we want to expose.
Re:Show HN: Datasette – Create and publish an API for SQLite... by evv555 on Tuesday November 14, 2017 @05:40AM (#15693987)
SQL View queries get their own REST endpoints or you can use Postgrest like a language agnostic ORM.