You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/04/23 06:48:39 UTC

[GitHub] [shardingsphere] tristaZero opened a new issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

tristaZero opened a new issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282


   Hi guys, welcome! 😊 
   
   ### Background
   ShardingSphere 5.x will present itself with new valuable features and simple configuration API  to our community. 
   
   **We will provide many of build-in sharding algorithms to users**, which means uses can choose a proper one from sharding-algorithm selections before implementing the interface of the sharding algorithm themselves.
   
   **Therefore we call for your idea for sharding algorithm selections!** 🎉 
   
   ### Why
   ShardingSphere has an active community, so I believe you have your sharding algorithm to meet your scenarios, right? If so, why do not you try to contribute them to the Apache community? 
   
   Only a few of the effort, you can make some contribution to the community, **which will become a part of sharding algorithm selections and is likely to be adopted by people all over the world.** ✨
   
   What's more, if you have another sharding scenario one day, then this selection will be the help for you in turn!
   
   ### What is `Data time sharding algorithm`
   **The key point of this algorithm** is to shard tables or databases by `datatime`, `time`, `timestamp`, `date` columns. That is, the sharding values are any type of `time` .
   
   For instance, I plan to record all the rows in one partition table during one day. In this condition, one sharding table only contains records inserted during this day.
   
   You can light up your imagination to give a better design! 🎯 
   
   Welcome your comments and look forward to your PR! 🤚 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] SanmuWangZJU commented on issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

Posted by GitBox <gi...@apache.org>.
SanmuWangZJU commented on issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282#issuecomment-620389895


   I'd like to provide another datetime shard algorithm used to shard tables by days/weeks/months/QUARTER_OF_YEAR


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282#issuecomment-620446047


   > I'd like to provide another datetime shard algorithm used to shard tables by days/weeks/months/QUARTER_OF_YEAR, and support half range bound
   
   You know, we are looking forward to your wonderful idea. :)


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero edited a comment on issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

Posted by GitBox <gi...@apache.org>.
tristaZero edited a comment on issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282#issuecomment-618213182


   ### How
   1. Fork this project and clone your fork one to local.
   2. Install this project.
   3. Create your sharding algorithm in `./incubator-shardingsphere/sharding-core/sharding-core-common/src/main/java/org/apache/shardingsphere/core/strategy/algorithm/sharding/`
   4. Implement `StandardShardingAlgorithm` interface.
   5. Add unit test to check what you coded in `./incubator-shardingsphere/sharding-core/sharding-core-common/src/test/java/org/apache/shardingsphere/core/strategy/algorithm/sharding/`
   
   ### Note
   1. This issue is to call for `Date time` sharding algorithm. You should look at other issues for your concern.
   2. Please comment `Ref #[This ISSUE ID]` and give some explanation when you raize a PR.
   3. Please make sure your sharding algorithm does not include your business logic. A sharding algorithm likely to be used universally is the best.
   4. `InlineShardingAlgorithm` and `InlineShardingAlgorithmTest` give you good examples of implementation and its unit test.
   5. `getType()` of  `ShardingAlgorithm` is expected to return the algorithm ID with capital letters.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero closed issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] SanmuWangZJU edited a comment on issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

Posted by GitBox <gi...@apache.org>.
SanmuWangZJU edited a comment on issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282#issuecomment-620389895


   I'd like to provide another datetime shard algorithm used to shard tables by days/weeks/months/QUARTER_OF_YEAR, and support half range bound


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] tristaZero commented on issue #5282: [Call For Idea] `Datetime` Standard Sharding Algorithm

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #5282:
URL: https://github.com/apache/shardingsphere/issues/5282#issuecomment-618213182


   ### How
   1. Fork this project and clone your fork one to local.
   2. Install this project.
   3. Create your sharding algorithm in `./incubator-shardingsphere/sharding-core/sharding-core-common/src/main/java/org/apache/shardingsphere/core/strategy/algorithm/sharding/`
   4. Implement `StandardShardingAlgorithm` interface.
   5. Add unit test to check what you coded in `./incubator-shardingsphere/sharding-core/sharding-core-common/src/test/java/org/apache/shardingsphere/core/strategy/algorithm/sharding/inline`
   
   ### Note
   1. This issue is to call for `Date time` sharding algorithm. You should look at other issues for your concern.
   2. Please comment `Ref #[This ISSUE ID]` and give some explanation when you raize a PR.
   3. Please make sure your sharding algorithm does not include your business logic. A sharding algorithm likely to be used universally is the best.
   4. `InlineShardingAlgorithm` and `InlineShardingAlgorithmTest` give you good examples of implementation and its unit test.
   5. `getType()` of  `ShardingAlgorithm` is expected to return the algorithm ID with capital letters.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org