[GSOC-266] [GSOC] [ShardingSphere] Supports executing DistSQL via JDBC

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: Mentor ShardingSphere gsoc2024 medium part-time
• Assignee: Unassigned
• Reporter: Longtao Jiang
• Created: 04/Mar/24 11:26
• Updated: 01/Apr/24 11:17

Description

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

Github: https://github.com/apache/shardingsphere 

Discussion: https://github.com/apache/shardingsphere/discussions/30252

Background

DistSQL (Distributed SQL) is Apache ShardingSphere’s specific SQL, providing additional operation capabilities compared to standard SQL.

Currently DistSQL can only be executed in ShardingSphere-Proxy. We hope to enhance this capability so that users can also execute DistSQL through ShardingSphere-JDBC.

Task

1. Understand the current reason why ShardingSphere-JDBC cannot execute DistSQL, and design a refactoring plan.
2. After completing the refactoring, add necessary unit tests to ensure that basic functionality is available.
3. Update documentation.

Relevant Skills

1. Master Java language
2. Understand SQL and DistSQL

Mentor

Longtao Jiang, Committer of Apache ShardingSphere, [e-mail]
Jiahao Chen, Committer of Apache ShardingSphere, [e-mail]