Suggestions regarding the dbadmin

[Ali]

Hi,

Here are two suggestions regarding the dbadmin view:

1. Table rows should have the same height. This improves readability and is also the standard practice in visualizing databases.

2. The current dbadmin does not show fields of a certain type, such as text or email list. That likely has to do with space restrictions. I believe it helps to still show them, but just a truncated version, as before.

Notably, the earlier version of the dashboard included both these features. Hopefully, re-creating them does not take much time.

Thank you!

-ali

[Massimo DiPierro]

I agree with 1. Will fix it.

I also agree with 2 but the idea was not to retrieve by default fields that are potentially large. Actually we may currently be retrieving them even if we do not display them. I can add lists and text.

--
You received this message because you are subscribed to the Google Groups "py4web" group.
To unsubscribe from this group and stop receiving emails from it, send an email to py4web+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/py4web/38dde2d7-850f-4e52-ab64-9b5b686347f5n%40googlegroups.com.

[Ali]

Thanks a lot, Massimo!

I do see the point you mentioned about a possible slowdown resulting from retrieving fields that are (potentially) large. Maybe we should add lists because they often have a reasonable size, but continue to leave out text. For the fields that are not shown, I still find it very helpful to show the field header but include a box for all rows, just like how the previous dbadmin was implemented. That way,  the table shows a list of all available fields without consuming too many resources. Also, it will match the standard practice for displaying databases where field headers are typically all shown.

Thank you, again!

[Ali]

Just to be clear, the use of boxes instead of the actual content applies to the initial table view in the dbadmin. The page opened by clicking the "Details" button should show the complete content even for text fields, if possible.

- ali

[Ali]

Another helpful field type to include, hopefully with its content directly present on the original table view, is the reference type. (The type used to refer to the ID field of another table.)

Thank you!

[Ali]

Now that the dbadmin is being updated, I’d like to suggest two other improvements:

• The common_filter should not be applied, since dbadmin is a natural place for administrators to review and manage databases. At the very least, the standard is_active-based common filter should be disabled, in my opinion.

• The previous version of dbadmin provided hyperlinks for cells under columns of type reference. Clicking on a value would take the user to the corresponding row in the related table. I believe this is a valuable feature worth keeping.

Thank you!

-ali