Chuxin Chen created COMDEV-488:
----------------------------------
Summary: Apache ShardingSphere: Support mainstream database
metadata table query
Key: COMDEV-488
URL: https://issues.apache.org/jira/browse/COMDEV-488
Project: Community Development
Issue Type: Improvement
Components: GSoC/Mentoring ideas
Reporter: Chuxin Chen
h2. Apache ShardingSphere
Apache ShardingSphere is positioned as a Database Plus, and aims at building a
standard layer and ecosystem above heterogeneous databases. It focuses on how
to reuse existing databases and their respective upper layer, rather than
creating a new database. The goal is to minimize or eliminate the challenges
caused by underlying databases fragmentation.
{*}Page{*}:
[https://shardingsphere.apache.org|https://shardingsphere.apache.org/]
{*}Github{*}: [https://github.com/apache/shardingsphere]
h2. Background
ShardingSphere has designed its own metadata database to simulate metadata
queries that support various databases.
{*}More details{*}:
[https://github.com/apache/shardingsphere/issues/21268]
[https://github.com/apache/shardingsphere/issues/22052]
h2. Task
* Support PostgreSQL AND openGauss `\d tableName` and `l`
* Support query for MySQL metadata `TABLES`, `COLUMNS`
{*}Notice{*}, these issues can be a good example.
[https://github.com/apache/shardingsphere/pull/22053]
[https://github.com/apache/shardingsphere/pull/22057/]
[https://github.com/apache/shardingsphere/pull/22166/]
[https://github.com/apache/shardingsphere/pull/22182]
h2. Relevant Skills
* Master JAVA language
* Have a basic understanding of Zookeeper
* Be familiar with MySQL/Postgres SQLs
h3. Mentor
Chuxin Chen, Committer of Apache ShardingSphere, [email protected]
Zhengqiang Duan, PMC of Apache ShardingSphere, [email protected]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
