subql icon indicating copy to clipboard operation
subql copied to clipboard
verified publisher icon subquery

[$10,000 in SQT] Upgrade Query service to Postgraphile v5

Open jamesbayly opened this issue 2 years ago • 7 comments

Description

Postgraphile v5 has been released which is a complete rewrite and should solve various issues, provide new features and remove blockers from implementing other features. The goal is to upgrade the query service to use v5.

Because this is such a large change this can potentially live along side the current query service until feature parity is met and stability/performance is sufficient

Requirements

The end goal is feature parity but there are certain requirements that must be met for this to be considered complete

  • Uses the latest version of postgraphile v5
  • Support for historical indexing (PgBlockHeightPlugin)
    • This should include any other scopes to ensure all other features work with historical. Including ordering, filtering, aggregates, nested queries, etc
  • Support for metadata (GetMetadataPlugin)
  • Support for distinct results (PgDistinctPlugin)
  • Total Counts of entities
  • Full text search (PgSearchPlugin)
  • Any other plugins or features that have community implementations that have an equivalent from v4
  • Equivalent or better SQL query performance, especially for the introspection query
  • Integration tests that allow generating a DB schema, running the query service, performing a graphql query and being able to test against the generated SQL query.

Some of the benefits of the upgrade

Enables

  • Union types
  • Fixes issues with cursor pagination. https://github.com/graphile/graphile-engine/issues/502

jamesbayly avatar Aug 31 '23 03:08 jamesbayly

Is this still open? Can this be claimed by anyone?

Niraj-Kamdar avatar Sep 13 '24 05:09 Niraj-Kamdar

@stwiname Is this still open as i can see we have not migrated yest and solving this would help out in other issues as well

3scava1i3r avatar Sep 03 '25 23:09 3scava1i3r

@3scava1i3r yes this is still open

stwiname avatar Sep 04 '25 04:09 stwiname

@stwiname do we continue the discussion here or some other community forum/discord for better communication on this?

3scava1i3r avatar Sep 04 '25 09:09 3scava1i3r

I just wanted to confirm whether this is a paid task. I’ve already started working on a draft PR in GitHub and will share it soon. Happy to connect on Discord for further communication, or continue here if that’s preferred.

3scava1i3r avatar Sep 06 '25 14:09 3scava1i3r

@3scava1i3r, what suits you best? Telegram is also an option, https://t.me/subquerydevs

stwiname avatar Sep 08 '25 03:09 stwiname

@3scava1i3r, what suits you best? Telegram is also an option, https://t.me/subquerydevs

I've been on your discord for quite some years now I'll continue there but joined telegram too just in case

3scava1i3r avatar Sep 08 '25 04:09 3scava1i3r