apache / apache/shardingsphere
Support mainstream database metadata table query
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 35m
- Merged PRs (30d)
- 326
Description
This is one of the potential features which proposed for GSoC 2023 program, and the detail content ref to [here (GSOC-165)](https://issues.apache.org/jira/browse/GSOC-165).
### Background
ShardingSphere has designed its own metadata database to simulate metadata queries that support various databases.
### More details:
ref to https://github.com/apache/shardingsphere/issues/21268 and https://github.com/apache/shardingsphere/issues/22052
### Warmup Tasks
- [ ] Support query for MySQL metadata `parameters`
- [ ] Support query for MySQL metadata `routines`
- [ ] Support query for MySQL metadata `accounts`
ref to https://github.com/apache/shardingsphere/issues/24378
### Sub Tasks
- [ ] Support PostgreSQL And openGauss `\d tableName`
- [ ] Support PostgreSQL And openGauss `\d+`
- [ ] Support PostgreSQL And openGauss `\d+ tableName`
- [ ] Support PostgreSQL And openGauss `l`
- [ ] Support query for MySQL metadata `TABLES`
- [ ] Support query for MySQL metadata `COLUMNS`
- [ ] Support query for MySQL metadata `schemata`
- [ ] Support query for MySQL metadata `ENGINES`
- [ ] Support query for MySQL metadata `FILES`
- [ ] Support query for MySQL metadata `VIEWS`
Contributor guide
Assessment
This issue has not been assessed yet.