[
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 PostgreSQL Search Path Feature
(was: [GSOC] [ShardingSphere] Support for Search Path Feature)
> [GSOC] [ShardingSphere] Support for PostgreSQL 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
> Labels: Mentor, ShardingSphere, gsoc2024
>
> 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]
>
> h2. 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.
> h2. Task
> 1.Support configuring search_path in ShardingSphere.
> 2.Support matching the corresponding schema through search_path configuration.
> 3.Support propagating the matched schema to the storage node.
> 4.Support dynamically modifying search_path through SQL.
> h2. Relevant Skills
> 1. Proficiency in Java.
> 2. Familiarity with PostgreSQL databases.
> 3. Familiarity with ShardingSphere.
> h2. Deliverables
> Related code + unit tests + E2E tests.
> h2. Mentor
> Zhengqiang Duan, PMC Member of Apache ShardingSphere,
> duanzhengqi...@apache.org
> Cheng Zhang, Committer of Apache ShardingSphere, chengzh...@apache.org
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: gsoc-unsubscr...@community.apache.org
For additional commands, e-mail: gsoc-h...@community.apache.org
