4 ms·

Use a tool like Postgraphile that does all that heavy lifting for you

claytonjy 4y ago
Would this solve the problem described? Sounds like the annoying part is solely on the front-end, the unpacking/flattening of what the Postgraphile service returns. From their description, I wouldn't be surprised if they were already using Postgraphile or Hasura as "the graph layer".
- gavinray 4y ago
  If they were using Hasura, the data would be in the same shape as their view, so I don't think so. Disclaimer: Work @ Hasura, built products with it prior to that
  - chaps 4y ago
    Heh, I actually use Hasura and I find it extremely painful to use. It's unbearably fragile to state changes (eg, psql scripts + pg_dump/psql restores) and its errors are inconsistent enough to give you just enough constant false hope that your problem's fixed, but a second step is almost always needed.. and without a helpful error or button that just explains and fixes all the things from a single screen. I realize I'm probably using it wrong, but I really don't think I'm doing anything exceptionally "out there".
    - gavinray 4y ago
      Appreciate the candor, at least > "its errors are inconsistent enough to give you just enough constant false hope that your problem's fixed, but a second step is almost always needed.. and without a helpful error or button that just explains and fixes all the things from a single screen." There are buttons on the "Settings" screen (/console/settings/metadata-status) you can click that should put your instance back in a working state (and it'll redirect you here by default if your metadata is invalid): > [DASHBOARD TEXT]: "You have been redirected because your GraphQL Engine metadata is in an inconsistent state. To delete all the inconsistent objects from the metadata, click the "Delete all" button. If you want to manage these objects on your own, please do so and click on the "Reload Metadata" button to check if the inconsistencies have been resolved." As someone who still builds their personal projects with it -- yeah, the error messages can be kind of opaque if they're related to Hasura's internal metadata/state. For errors that come from external services, those are passed through at least when "HASURA_GRAPHQL_DEV_MODE" is enabled. > "It's unbearably fragile to state changes (eg, psql scripts + pg_dump/psql restores) ... I realize I'm probably using it wrong, but I really don't think I'm doing anything exceptionally "out there". Are you dropping tables/columns which have metadata on them? IE, a relationship or permission on a table? If you have metadata on a resource and then you remove it, without also removing references to it, the effect is the same as if you had tried to drop a table that has foreign keys that reference it in an RDBMS.
      - chaps 4y ago
        Thanks for the response! You're right that that's what I'm doing wrong, though the problem comes from after I recreate those relationships on the RDBMS side. Hasura really struggles to piece together that even though things were tore down, they were brought up in the same way. Having one button to "repair" it would be nice. This mostly happens because I more or less start from scratch on the RDBMS side every time I make a change. I'd do the same on the Hasura side, but tracking relationships (I think that's what it's called) takes about ten minutes to initialize on a relatively small database so I'm forced into making as few changes as possible.
        gavinray 4y ago
        > "but tracking relationships (I think that's what it's called) takes about ten minutes to initialize on a relatively small database" Oof, this is insane. Should not be the case. Are you using the Hasura CLI to automatically track any changes made with the web UI to local YAML files? You can use this, along with the ".cli-migrations" variant of the Docker image to automatically apply your metadata/migration as soon as the image starts. So you'd run "hasura console" in terminal, which would serve the special web UI that mirrors changes to local files, and that'll serve it on http://localhost:9695 http://localhost:9695 Then when you want to start fresh, just docker-compose down/up and it'll handle auto-applying everything for you: https://hasura.io/docs/latest/graphql/core/migrations/migrations-setup/#migrations-initialize https://hasura.io/docs/latest/graphql/core/migrations/migrat... https://hasura.io/docs/latest/graphql/core/migrations/advanced/auto-apply-migrations/ https://hasura.io/docs/latest/graphql/core/migrations/advanc...
  - Ataraxy 4y ago
    I adore Hasura and have used it pretty extensively for over a year. That being said, the biggest thing I desire from it is the ability to do group by aggregations. Any time I have to do this I have to go through the tedious process of writing a function which is really annoying. I wish to avoid having to break into raw SQL as much as possible when using a tool such as Hasura.
    - cersa8 4y ago
      Aggregate queries are indeed a weak point of GraphQL.
- RedShift1 4y ago
  I'm not entirely sure what you mean with "unpacking/flattening", you have to do that for every API returning JSON?

Would this solve the problem described? Sounds like the annoying part is solely on the front-end, the unpacking/flattening of what the Postgraphile service returns. From their description, I wouldn't be surprised if they were already using Postgraphile or Hasura as "the graph layer".

gavinray 4y ago
If they were using Hasura, the data would be in the same shape as their view, so I don't think so. Disclaimer: Work @ Hasura, built products with it prior to that
- chaps 4y ago
  Heh, I actually use Hasura and I find it extremely painful to use. It's unbearably fragile to state changes (eg, psql scripts + pg_dump/psql restores) and its errors are inconsistent enough to give you just enough constant false hope that your problem's fixed, but a second step is almost always needed.. and without a helpful error or button that just explains and fixes all the things from a single screen. I realize I'm probably using it wrong, but I really don't think I'm doing anything exceptionally "out there".
  - gavinray 4y ago
    Appreciate the candor, at least > "its errors are inconsistent enough to give you just enough constant false hope that your problem's fixed, but a second step is almost always needed.. and without a helpful error or button that just explains and fixes all the things from a single screen." There are buttons on the "Settings" screen (/console/settings/metadata-status) you can click that should put your instance back in a working state (and it'll redirect you here by default if your metadata is invalid): > [DASHBOARD TEXT]: "You have been redirected because your GraphQL Engine metadata is in an inconsistent state. To delete all the inconsistent objects from the metadata, click the "Delete all" button. If you want to manage these objects on your own, please do so and click on the "Reload Metadata" button to check if the inconsistencies have been resolved." As someone who still builds their personal projects with it -- yeah, the error messages can be kind of opaque if they're related to Hasura's internal metadata/state. For errors that come from external services, those are passed through at least when "HASURA_GRAPHQL_DEV_MODE" is enabled. > "It's unbearably fragile to state changes (eg, psql scripts + pg_dump/psql restores) ... I realize I'm probably using it wrong, but I really don't think I'm doing anything exceptionally "out there". Are you dropping tables/columns which have metadata on them? IE, a relationship or permission on a table? If you have metadata on a resource and then you remove it, without also removing references to it, the effect is the same as if you had tried to drop a table that has foreign keys that reference it in an RDBMS.
    - chaps 4y ago
      Thanks for the response! You're right that that's what I'm doing wrong, though the problem comes from after I recreate those relationships on the RDBMS side. Hasura really struggles to piece together that even though things were tore down, they were brought up in the same way. Having one button to "repair" it would be nice. This mostly happens because I more or less start from scratch on the RDBMS side every time I make a change. I'd do the same on the Hasura side, but tracking relationships (I think that's what it's called) takes about ten minutes to initialize on a relatively small database so I'm forced into making as few changes as possible.
      - gavinray 4y ago
        > "but tracking relationships (I think that's what it's called) takes about ten minutes to initialize on a relatively small database" Oof, this is insane. Should not be the case. Are you using the Hasura CLI to automatically track any changes made with the web UI to local YAML files? You can use this, along with the ".cli-migrations" variant of the Docker image to automatically apply your metadata/migration as soon as the image starts. So you'd run "hasura console" in terminal, which would serve the special web UI that mirrors changes to local files, and that'll serve it on http://localhost:9695 http://localhost:9695 Then when you want to start fresh, just docker-compose down/up and it'll handle auto-applying everything for you: https://hasura.io/docs/latest/graphql/core/migrations/migrations-setup/#migrations-initialize https://hasura.io/docs/latest/graphql/core/migrations/migrat... https://hasura.io/docs/latest/graphql/core/migrations/advanced/auto-apply-migrations/ https://hasura.io/docs/latest/graphql/core/migrations/advanc...
- Ataraxy 4y ago
  I adore Hasura and have used it pretty extensively for over a year. That being said, the biggest thing I desire from it is the ability to do group by aggregations. Any time I have to do this I have to go through the tedious process of writing a function which is really annoying. I wish to avoid having to break into raw SQL as much as possible when using a tool such as Hasura.
  - cersa8 4y ago
    Aggregate queries are indeed a weak point of GraphQL.
RedShift1 4y ago
I'm not entirely sure what you mean with "unpacking/flattening", you have to do that for every API returning JSON?