dbeaver / dbeaver/dbeaver

Include basic column statistics in column information view

Open
#7,824 4 comments 2 reactions 0 assignees View on GitHub
xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

(Please excuse me if this feature request has already been discussed)

When exploring new databases and performing basic content checks I regularly evaluate database columns for "completeness" (how many fields per column are non-null/non-empty) and the most frequent values (usually the most frequent 3 values).

The background for this inspection is that many databases schemas have unused or overlooked fields that are intended to be populated with meaningful values but are neglected by users so that they will largely contain default or NULL values. Performing such a simple analysis requires some dynamic programming (e.g. adjusting frequnency counts for column names and data types) which feels like repeating a lot of work that has already been done under the hood of dbeaver.

The table/column information view quite already provides basic schema data, and lists data types, constraints, comments and others. It would be great to have a mechanism to extend this view with column statistics, i.e. trigger a computation of the share of non-null field values or the computation of the most frequent values.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.