You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by juan pan <pa...@apache.org> on 2019/02/26 11:44:56 UTC

[New feature] Independent encryptedDataSource to decrypt or encrypt sensitive data.

Hi, everyone,

This new feature development plan needs your advice.

It is to create independent encrypted DataSource which can encrypt
sensitive information, e.g, password or ID to store them in database, and
decrypt ciphertext in database for queries. By using encrypted DataSource,
you can encrypt or decrypt sensitive data in aboriginal JAVA coding way.

Here are the main tasks:
- [ ] SQL parsing for sensitive columns
- [ ] SQL rewriting for sensitive columns
- [ ] SQL executing with encrypt DataSource
- [ ] SQL resultSet creating
- [ ] JDBC interface implementation for EncryptedDataSource,
EncryptedConnection, EncryptedPreparedStatement, EncryptedStatement,
EncryptedResultSet.
- [ ] Usage API for Yaml, Spring, Proxy

Currently first task is assigned to hongJun Du, and i am doing the rest.
Any suggestions, please let us know. Waiting for your reply.

---------------------------------
Juan Pan (Trista)
Apache ShardingSphere