You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gsoc@community.apache.org by "Cheng Zhang (Jira)" <ji...@apache.org> on 2024/03/05 01:33:00 UTC
[jira] [Updated] (GSOC-267) [GSOC][ShardingSphere] Support for Search Path Feature
[ https://issues.apache.org/jira/browse/GSOC-267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Cheng Zhang updated GSOC-267:
-----------------------------
Summary: [GSOC][ShardingSphere] Support for Search Path Feature (was: [ShardingSphere] Support for Search Path Feature)
> [GSOC][ShardingSphere] Support for Search Path Feature
> ------------------------------------------------------
>
> Key: GSOC-267
> URL: https://issues.apache.org/jira/browse/GSOC-267
> Project: Comdev GSOC
> Issue Type: New Feature
> Reporter: Cheng Zhang
> Priority: Major
>
> 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]
> {*}Discussion{*}: [https://github.com/apache/shardingsphere/discussions/30252]
>
> h3. Background
> Apache ShardingSphere is positioned as Database Plus and aims to build a standard layer and ecosystem on top of heterogeneous databases. Therefore, ShardingSphere can be used with storage nodes like PostgreSQL. When users use PostgreSQL, they may have set the priority of query schema in system variables in advance. For example, when executing the SQL statement: {*}SELECT * FROM order{*}, if no schema is specified, the logical execution on PostgreSQL is as follows: scan through schemas in search_path one by one until the order table is found. On ShardingSphere, the current logic is to always query the public schema. Therefore, it is planned to support the search_path functionality for PostgreSQL in ShardingSphere to enhance the user experience.
> h3. Task
> - Support configuring search_path in ShardingSphere.
> - Support matching the corresponding schema through search_path configuration.
> - Support propagating the matched schema to the storage node.
> - Support dynamically modifying search_path through SQL.
> h3. Relevant Skills
> 1. Proficiency in Java.
> 2. Familiarity with PostgreSQL databases.
> 3. Familiarity with ShardingSphere.
> h3. Deliverables
> Related code + unit tests + E2E tests.
> h3. Mentor
> duanzhengqiang@apache.org
> chengzhang@apache.org
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: gsoc-unsubscribe@community.apache.org
For additional commands, e-mail: gsoc-help@community.apache.org