Weekly Report of ShardingSphere (2019.4.1 to 2019.4.4)

[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
860	7216	2546

This Week's Development

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

Feature Development

New Feature Development

1. The access support for independent data source masking of SpringBoot&SpringNameSpace ( - Lose result set when use DISTINCT syntax. #2094 finished).
2. sharding-orchestration-reg-jetcd module ( - 去除多余的判断 #34 finished).
3. Example
   • hint ( - PreparedStatement executeBatch Java heap space #114 doing)
   • Broadcast table ( - 支持yaml配置读写分离 #115 doing)
   • Access sharding-proxy with JDBC ( - 命名空间无效 #117 doing)

Bug Fix

1. Fixed the problem when using DISTINCT + GROUP BY syntax at the same time, the query result set is wrong ( - Lose result set when use DISTINCT syntax. #2094 finished).
2. Fixed LIMIT multi-thread problem ( - (mybatis + shardingjdbc ) multithreading paging query Incorrect result  #2136 finished).

Feature Optimization & Refactoring

1. Improved the performance of data masking query ( - Sharding Encryptor #1844 finished).
2. Improved SHOW TABLES performance ( - SQL Show tables are show when config huge mount of actual tables #2153 finished).
3. Replaced the parsing engine from its second generation to the third in phase ( - Use 3rd generation parse engine instead of 2nd generation parse engine #2084 doing).
4. Developed examples of sharding data masking test ( - MySQL sharding encrypt test #2134 doing).

ShardingSphere Ecology Construction

Official Website Construction

1. Supplemented the instances of independent data source masking in official documents.

Release

1. Split bin release to sharding-jdbc-bin and sharding-proxy-bin ( - Release distribution  #2147 finished).
2. Finished the second round of test of 4.0.0-RC1-release.

Publicity

1. Wrote The Practical Implementation of Distributed Database Middleware Apache ShardingSphere at JD and and published it on the official WeChat account of DBAPlus and JD Finance Cloud.

Next Week's Plan

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

Feature Development

New Feature Development

1. Example
   • hint ( - PreparedStatement executeBatch Java heap space #114)
   • Broadcast table ( - 支持yaml配置读写分离 #115)
   • APM ( - sharding-jdbc-example-mybatis例子修改成algorithm-expression就报错了 #116)
   • Access sharding-proxy with JDBC ( - 命名空间无效 #117)
2. Add registry center spi in the registry center of orchestration module; distinguish between zookeeper/etcd and other possible registry centers such as eureka.

Problem Investigation

1. The exception thrown by getColumnIndex when columnLabel in Oracle JDBC ResultSetMetaData is fixed to be capitalized ( - MemoryQueryResult getColumnIndex throw exception when using Oracle database #2152).
2. The problem of error type shift when Oracle JDBC searches time field ( - ShardingResultSet getTimestamp throw ClassCastException when using oracle database #2159).

Feature Optimization & Refactoring

1. Replace the parsing engine from its second generation to the third in phase ( - Use 3rd generation parse engine instead of 2nd generation parse engine #2084).
2. Develop examples of sharding data masking test.

ShardingSphere Ecology Construction

Release

1. Finish the third round of test.
2. Call for the vote in ShardingSphere community.

Available Tasks for Community Committers

Issue #1775, #1907, #2110, #2148, #2154 and #2158.