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.

Yes, with good results. Anything specific you're curious about?

Hi. I'd like to know how you design the database to separate data available via REST and data that is not.

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.

SQL View queries get their own REST endpoints or you can use Postgrest like a language agnostic ORM.