Weekly Report of ShardingSphere (2019.4.15 to 2019.4.19)

[Harper0122]

This report is to review recent changes and developments of ShardingSphere.

Basic Data

Basic data shows how the watch, star and fork have changed during the past week.

Watch	Star	Fork
858	7368	2582

This Week's Development

This part is to show new developments of ShardingSphere during the past week.

Feature Development

New Feature Development

1. Sharding-Proxy's transparent transmission in storage process ( Support Stored Procedure for Sharding-Proxy IF not sharding #2195 doing).

2. Sharding-Proxy's support for multiple usernames and passwords ( ShardingProxy supports multiple users and authorizedSchemas #2232 doing).

3. Example

   3.1 broadcast-table example development: usage in raw-jdbc scenario finished by one community member (example 支持yaml配置读写分离 #115 doing).

   3.2 Added official examples of Data Masking module usage (example 写文档说明对于分页问题的优化 #130 finished).

Feature Optimization & Refactoring

1. Replaced the engine in SQL parsing module from its second generation to the third ( Use 3rd generation parse engine instead of 2nd generation parse engine #2084 doing).
2. Optimized Antlr parsing document structure for MySQL DCL ( Review the DCL Parsing rules for different databases #2214 doing).
3. Refactored sharding-transaction-spring module, split it into jdbc and proxy and acquired proxy access shift transaction from JPA with spi (shardingsphere-spi-impl spring支持 #35 finished).
4. Shardingsphere used servicecomb-saga module code to optimize (shardingsphere-spi-impl#38 doing).
5. Refactored sql-revert module (shardingsphere-spi-impl 提供使用暗示(Hint)方式注册分片键值并进行SQL路由功能 #39 doing).

Bug Fix

1. Fixed the switch failure that parsing rules do not distinguish between float and integral and take the former as the latter to process ( mysql insert decimal error #2211 finished).
2. Fixed the problem that when the encryptor without assistant query column is used in error array query, it may violate the boundary ( When use ShardingQueryAssistedEncryptor to find assistedQueryColumns, an outOfIndex exception will occur. #2205 finished).
3. Parsing error in null-value expressions ( Incorrect integer value: 'NULL' for column #2222 finished).
4. RLIKE syntax that supports MySQL ( Support RLIKE expression #2208 finished).

ShardingSphere Ecology Construction

Official Website Construction

1. Added the official explanatory documents for data masking, auto-augment key and the combination use of data masking + sharding.

Cooperation

1. SkyWalking plug-in has passed the test (Provide plugin for ShardingSphere skywalking#1934).

Release

1. Finished Apache Release vote in ShardingSphere community (https://lists.apache.org/thread.html/7818fb3400ca4404d4d9c47407f4589281ba4a499e0a798b7d714c32@%3Cdev.shardingsphere.apache.org%3E).
2. Started Apache Release incubator vote (https://lists.apache.org/thread.html/25c11b46dd3a58d4048dd35be71d21f86db6f5278480eb7083149af1@%3Cgeneral.incubator.apache.org%3E).

Next Week's Plan

This part is to show ShardingSphere's plan for the next week.

Feature Development

New Feature Development

1. Sharding-Proxy's transparent transmission in storage process ( Support Stored Procedure for Sharding-Proxy IF not sharding #2195).
2. Sharding-Proxy's support for multiple usernames and passwords ( ShardingProxy supports multiple users and authorizedSchemas #2232).

Feature Optimization & Refactoring

1. Replace the engine in SQL parsing module from its second generation to the third ( Use 3rd generation parse engine instead of 2nd generation parse engine #2084).
2. Optimize Antlr parsing document structure for PostgreSQL and SQLServer DCL ( Review the DCL Parsing rules for different databases #2214).
3. ShardingSphere uses servicecomb-saga module code to optimize (shardingsphere-spi-impl JPA与Sharding-JDBC的兼容问题。JPA会自动增加SELECT的列别名，导致ORDER BY只能通过别名，而非列名称获取ResultSet的数据。 #38).
4. Refactor sql-revert module (shardingsphere-spi-impl 提供使用暗示(Hint)方式注册分片键值并进行SQL路由功能 #39).

Problem Investigation

1. Investigate the issue about auto-augment key generator related to snowflake algorithm ( SnowflakeShardingKeyGenerator hava a bug  #2219).

ShardingSphere Ecology Construction

Publicity

1. Publicity in PostgreSQL Chinese Community: ShardingSphere Will Support PostgreSQL Agent.

Release

1. Finish Apache Release incubator vote (https://lists.apache.org/thread.html/25c11b46dd3a58d4048dd35be71d21f86db6f5278480eb7083149af1@%3Cgeneral.incubator.apache.org%3E).

Available Tasks for Community Committers

Issue #2154, #1907 and #1775.