RFC: Improvements to console tracking UI

[vijayprasanna13]

Hey folks, we're making improvements to console UI surrounding the tracking section for databases. As a first step, we're making an improved version of the "Table Tracking" section that should be available with an opt-in feature flag on the console.

The features that are coming along with this are -

• Pagination for the list of tables
• A filter-by table type option
• A dedicated section to see the list of previously tracked tables
• Text search based on the table name

We'll keep this discussion updated on the progress and when it's coming out. Please do give it a try when it does and let us know your feedback or catch any bugs! Thanks!

[vijayprasanna13]

Hey folks! You can try out the feature early by using the demo image below

docker pull hasura/graphql-engine-demo:mono-pr-9578-legacy.ubuntu

How to enable this feature?
Navigate to the Settings > Feature Flags part of the console and toggle the Enable new Table Tracking UI for Postgres & SQL Server feature flag to start using this feature

how-2-enable.mp4

[jjstanton]

Thank you for this! Unfortunately, I've encountered an fetch error for the assetLoader.js.gz.

Would you be able to confirm this?

[vijayprasanna13]

this might be a CDN issue since the older assets could have removed. I'd suggest trying out v2.29.0 version of Hasura!

[anish-pr]

We also got the same issue, the ui is not loading with this image. Stuck in loading screen

[vijayprasanna13]

@anish-pr @jjstanton Could try the v2.29.0 version of Hasura?

[jjstanton]

Thanks, v2.29.0 does indeed solve the issue. Enjoying the new features!

[vijayprasanna13]

Hey folks! We have more updates! From v2.30.0 onwards the new and improved tracking functionality is now available for suggested relationships. It brings -

1. Search and Pagination
2. Way faster tracking and un-tracking of multiple relationships at once.
3. Ability Customize you suggested relationship name before tracking them.
   

[thinknirmal]

After adding a new foreign key to an existing table, the new tracking UI doesn't suggest the untracked relationships. The old UI still correctly suggests them.

This doesn't always happen. It's more of 50/50 chances of success.

[vijayprasanna13]

Thanks @thinknirmal for the feedback! we'll look into this!

[vijayprasanna13]

This doesn't always happen. It's more of 50/50 chances of success.

The explanation for this part is that we don't use raw SQL anymore to fetch the Foreign key info. This was done for performance reasons. As a solution, we could have a refresh button near the list to fetch the latest info schema info in case.

[IS-Josh]

We use Alloydb with partitioned tables. The Data page in Hasura console is still unusable. Querires time-out.