dbeaver / dbeaver/dbeaver

Reducing the metadata queries for some database

Open
#21,774 4 comments 4 reactions 1 assignee Claimed by @LonwoLonwo View on GitHub
sp:2 xf:metadata xf:sql editor
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

Some databases, such as Trino, have an undeniable cost of querying metadata. It is a very bad experience to always see many SQL queries for metadata stuck in the queue
```sql
SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION
FROM system.jdbc.tables
WHERE TABLE_NAME LIKE 'confirmed_revenue' ESCAPE '\'
ORDER BY TABLE_TYPE, TABLE_CAT, TABLE_SCHEM, TABLE_NAME
```

We generally do not change the table structure frequently, so it's nice to cache the metadata for one database.
And refresh it by hand.
And I think the Auto-Complete for sql must be use the local cached metadata.
And it can be configed will be more nice.

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.