News for hackers. Stuff that matters.
Re:Show HN: Datasette – Create and publish an API for SQLite... by hamandcheese on Monday November 13, 2017 @07:18PM (#15691494)
See also: PostgREST, which turns a PostgreSQL database into a rest API.

https://postgrest.com/

Re:Show HN: Datasette – Create and publish an API for SQLite... by everdev on Monday November 13, 2017 @11:23PM (#15692644)
PostgREST looks fantastic. Anyone used it in production?
Re:Show HN: Datasette – Create and publish an API for SQLite... by michalskop on Tuesday November 14, 2017 @06:03AM (#15694084)
I use postgrest for several projects. I have an issue with crashing occasionally (once in months) for no obvious reason (to me). I solved it by continously checking the status and automatically restarting it if it's down. Otherwise great.
Re:Show HN: Datasette – Create and publish an API for SQLite... by hucker on Tuesday November 14, 2017 @02:36AM (#15693392)
Yes, with good results. Anything specific you're curious about?
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.