5 ms·

Looks a lot like PostgREST, but with more backends (not just postgres), fewer fancy features (joins? not mentioned here), and with the client-side code generato

Looks a lot like PostgREST, but with more backends (not just postgres), fewer fancy features (joins? not mentioned here), and with the client-side code generator built in (typescript). If the author is reading, assuming I'm using Postgres and typescript, in what situations would I choose this over PostgREST + any openapi code generator?

algo_trader 5y ago
Are there any UI-generators that can go with postgrest? Dbcore looks so great, but i cant really stomach adding another language (Go..) to the mix.
- claytonjy 5y ago
  I haven't used any of them, but PostgREST lists a bunch of client libs in a variety of languages in their docs. [0] If you're worried about another language in the mix, you should know that PostgREST is powered by Haskell. [0] https://postgrest.org/en/v8.0/ecosystem.html#client-side-libraries https://postgrest.org/en/v8.0/ecosystem.html#client-side-lib...
- eugeniox 5y ago
  You can try https://dadabik.com https://dadabik.com (disclaimer: I am the author/founder).
eatonphil 5y ago
The difference between this and openapi code generator (I think) is that I made a few specific decisions in the builtin templates that help get internal business apps off the ground faster. But since it's designed around a template system you could do whatever you want with it. And of course openapi is much more mature just generally speaking. It's different from PostgREST in that it doesn't dynamically read schemas from the DB during the application server runtime. You generate an application from the DB up front and then you can do whatever you want with that generated application afterward.
- eurasiantiger 5y ago
  How to migrate to a backwards-incompatible version of the schema without data loss?
  - eatonphil 5y ago
    This project has no state so to migrate your db you'd turn off the generated app, migrate the db, regenerate the app, and turn it back on.
  - llimllib 5y ago
    When I used a similar-ish library, the answer was mostly: don't make backwards-incompatible versions of the schema

algo_trader 5y ago

Are there any UI-generators that can go with postgrest? Dbcore looks so great, but i cant really stomach adding another language (Go..) to the mix.

claytonjy 5y ago
I haven't used any of them, but PostgREST lists a bunch of client libs in a variety of languages in their docs. [0] If you're worried about another language in the mix, you should know that PostgREST is powered by Haskell. [0] https://postgrest.org/en/v8.0/ecosystem.html#client-side-libraries https://postgrest.org/en/v8.0/ecosystem.html#client-side-lib...
eugeniox 5y ago
You can try https://dadabik.com https://dadabik.com (disclaimer: I am the author/founder).

eatonphil 5y ago

The difference between this and openapi code generator (I think) is that I made a few specific decisions in the builtin templates that help get internal business apps off the ground faster. But since it's designed around a template system you could do whatever you want with it. And of course openapi is much more mature just generally speaking. It's different from PostgREST in that it doesn't dynamically read schemas from the DB during the application server runtime. You generate an application from the DB up front and then you can do whatever you want with that generated application afterward.

eurasiantiger 5y ago
How to migrate to a backwards-incompatible version of the schema without data loss?
- eatonphil 5y ago
  This project has no state so to migrate your db you'd turn off the generated app, migrate the db, regenerate the app, and turn it back on.
- llimllib 5y ago
  When I used a similar-ish library, the answer was mostly: don't make backwards-incompatible versions of the schema