Roadmap

Completed

DATABASE

1. MySQL
2. Oracle
3. SQLServer
4. PostgreSQL

DQL

1. Simple
2. JOIN
3. BETWEEN
4. IN
5. ORDER BY
6. GROUP BY
7. Aggregation
8. LIMIT, rownum, TOP
9. Simple Sub Query

DML

1. INSERT INTO
2. INSERT SET
3. UPDATE
4. DELETE

DDL

1. CREATE
2. ALTER
3. DROP
4. TRUNCATE

Configuration

1. Java API
2. Spring Namespace
3. Yaml
4. Read-write splitting Independent
5. Configuration Concentrated
6. Configuration Dynamic

SQL Parser

1. Lexer Analysis
2. Parser Analysis

SQL Rewrite

1. Correctness Rewrite
2. Polish Rewriting

SQL Router

1. Hint Router
2. Simple Router
3. Cartesian Product Router

Result Merger

1. Stream Merger
2. Memory Merger
3. Decorator Merger

Sharding Databases and Tables

1. Sharding Databases
2. Sharding Tables
3. Default Datasources

Read-write splitting

1. Read-write splitting
2. Consistent guarantees for the same thread and the same database connection
3. Hint-based forced master routing

Distributed Primary Key

1. JDBC integration
2. Distributed primary key policy interface
3. The distributed primary key algorithm based on snowflake is implemented

B.A.S.E Transaction

1. Best Effort Delivery

Planning

Configuration

1. Read-write splitting to be independent
2. Binding Strategy improvement
3. Centralized
4. Dynamic

Governance

1. HealthCheck and discovery of datasources
2. Dynamic switching of datasources
3. Flow control

TODO

DQL

1. DISTINCT
2. HAVING
3. OR
4. UNION, UNION ALL
5. Calculate Expression, eg: SUM(pv) / COUNT(uv)
6. Complicated Sub Query
7. SQL Hint

DML

1. INSERT INTO VALUES (xxx), (xxx)
2. UPDATE Multiple Tables
3. DELETE Multiple Tables

DDL

1. CREATE VIEW
2. CREATE INDEX
3. CREATE OR REPLACE

Enhanced SQL Parser

1. Batch Parser
2. Redundant Brackets
3. Specify SQL Hint by SQL comments

Enhanced B.A.S.E Transaction

1. TCC

Devops Tools

1. Dictionary table replication broadcasting
2. Dynamic Dilatancy