Skip to content

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

Description

@jamesbayly

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    guildTasks that are available via the guild

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions