You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

开源软件供应链点亮计划2020，任务列表

中文版本（待更新）

项目题目

项目描述

难度

导师名称/联系方式

项目产出要求

项目技术要求

相关仓库地址

报名学生

官网优化根据项目团队要求，重新设计并实现新的官网。中

张亮

zhangliang@apache.org


  1. 符合Apache的页面要求
  2. 官网首页支持内容滑动
  3. 支持官方文档PDF导出
  4. 重新设计社区和下载页面
  5. 能够使用Hugo编译成为静态网站
  6. 仅允许使用开源的风格资源，或自主设计
  7. 支持Markdown风格的博客和文章
  8. 支持第三方视频、音频资源
  1. 美工设计
  2. 页面布局
  3. Hugo
  4. Markdown
https://github.com/apache/shardingsphere/tree/master/docs
完善SQL语法解析模块参考PostgreSQL数据库的SQL语法，完善Sharding Parser模块有关PostgreSQL的语法定义高

潘娟

panjuan@apache.org


  1. 符合ShardingSphere SQL语法定义风格
  2. 依据PostgreSQL官网的DCL SQL语法定义，校对Sharding Parser的语法定义
  3. 依据PostgreSQL官网的DAL SQL语法定义，校对Sharding Parser的语法定义
  4. 依据PostgreSQL官网的DDL SQL语法定义，校对Sharding Parser的语法定义
  5. 依据PostgreSQL官网的DML SQL语法定义，校对Sharding Parser的语法定义
  1. 能够使用Java编程语言
  2. 熟悉正则表达式
  3. 了解Antlr基本运行原理
  4. 了解如何编写Antlr的g4语法文件
https://github.com/apache/shardingsphere
实现MySQL KILL语句的功能通过实现MySQL KILL语句的功能，中断当前客户端请求，释放ShardingSphere-Proxy后端资源中

张永伦

zhangyonglun@apache.org

  1. 实现MySQL KILL Statement的语法解析
  2. 增加KillStatement处理流程
  3. 通过MySQL握手流程，管理processList ID
  4. 根据语法解析得到的ID及SQL请求的路由结果，释放后端资源
  5. 向客户端返回对应的Response消息
  1. 熟悉Java
  2. 熟悉Netty
  3. 熟悉MySQL及数据库连接池
  4. 熟悉TCP/IP协议及Wireshark等抓包工具
  5. 了解Antlr基本运行原理
https://github.com/apache/shardingsphere








































































English Version

Task

Description

Difficulty

Mentor

Output

Tech. Requirements

Repo

Candidate

Official Website OptimizationRedesign and reimplement the website by following the project requirements.Medium

Liang Zhang

zhangliang@apache.org

  1. Follow all Apache Foundation requirements
  2. Homepage support slidable contents
  3. Support document export to PDF
  4. Redesign community/download pages. 
  5. Hugo based website build process
  6. Only use open source or new design materials(css, images, etc.)
  7. Support blogs and articles in markdown
  8. Support Video and Audio hosted on the 3rd party platform
  1. UI Design
  2. Website Layout
  3. Hugo
  4. Markdown
https://github.com/apache/shardingsphere/tree/master/docs
Proofread the SQL definitions of Sharding ParserIt is designed to proofread SQL definitions of Sharding Parser concerning PostgreSQL databaseHigh

Juan Pan

panjuan@apache.org


  1. Follow the SQL definition style of ShardingSphere
  2. Proofread the DCL SQL definitions of Sharding Parser referring to PostgreSQL document
  3. Proofread the DAL SQL definitions of Sharding Parser referring to PostgreSQL document
  4. Proofread the DDL SQL definitions of Sharding Parser referring to PostgreSQL document
  5. Proofread the DML SQL definitions of Sharding Parser referring to PostgreSQL document
  1. Be able to program with Java
  2. Be familiar with regular expression
  3. Basically learn how Antlr works
  4. Know how to write g4 file of Antlr
https://github.com/apache/shardingsphere
Implementation of processing MySQL KILL StatementInterrupt the request of current MySQL client and release the resources of ShardingSphere-Proxy's backend by implementing the processing of MySQL KILL StatementMedium

Yonglun Zhang

zhangyonglun@apache.org

  1. Implement the SQL parsing of MySQL Kill Statement
  2. Add KillStatement processing flow
  3. Manage processList ID through MySQL handshake process
  4. Release backend resources according to the ID obtained from SQL parsing and the routing result of SQL
  5. Return the corresponding Response message to the MySQL client
  1. Familiar with Java
  2. Familiar with Netty
  3. Familiar with MySQL and database connection pool
  4. Familiar with TCP/IP protocol, Wireshark or other packet capturing tools
  5. Know how Antlr works
https://github.com/apache/shardingsphere








































































Apache ShardingSphere项目基本情况介绍

Hello, everyone!

The distributed database or middleware is so popular these days. If you are interested in this topic, welcome on board!

Apache ShardingSphere is an open-source ecosystem consisted of a set of distributed database middleware solutions. Based on that, I promise you will acquire a deep understanding of the distributed database and middleware.

Moreover, as an Apache TLP (Top level project), this community is open, diverse, and internationalized, which means you can enter into an entire open-source world and start your Apache community journey!

Last but not least, our mentors are experienced at the distributed system,  new SQL, and Java programming, since they worked or are working large-scale enterprises. Presently, they are preparing plenty of work for your coming! :-)

社区介绍示例

  1. 社区名称：Apache ShardingSphere社区
  2. 社区官方网址：https://shardingsphere.apache.org/
  3. 社区Logo文件：http://www.apache.org/logos/?#shardingsphere
  4. 社区描述：Apache软件基金会顶级项目。分布式数据库中间件，提供标准化的数据分片、分布式事务和数据库治理功能，可适用于如Java同构、异构语言、云原生等各种多样化的应用场景。
  5. 社区邮件列表：dev@shardingsphere.apache.org。 订阅方式，发送邮件到dev-subscribe@shardingsphere.apache.org，根据回复操作。网页版本查看方式，https://lists.apache.org/list.html?dev@shardingsphere.apache.org.
  6. 社区官方公共邮箱：dev@shardingsphere.apache.org。建议订阅后发送。要求，使用英文。或联系个任务导师邮箱。
  7. 技术标签：Apache, java, database, sql, transaction
  8. 专注领域：数据库中间件，分布式治理，SQL解析，分布式事务
  • No labels