soar

package module

v0.0.0-...-11ec553 Latest Latest Go to latest Published: Feb 28, 2023 License: Apache-2.0 Imports: 0 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/yassineim/soar

README ¶

文档 | FAQ | 变更记录 | 路线图 | English

SOAR

SOAR (SQL Optimizer And Rewriter) is an automated tool for optimizing and rewriting SQL. It is developed and maintained by the database team of Xiaomi AI and Cloud Platform.

Features

Cross-platform support (Linux, Mac environments are supported, Windows environment is also supported in theory, but not fully tested)
Currently only support MySQL syntax family protocol for SQL optimization
Support for heuristic-based statement optimization
Supports multi-column index optimization for complex queries (UPDATE, INSERT, DELETE, SELECT)
Support for EXPLAIN information rich interpretation
Support SQL fingerprinting, compression and beautification
Support for merging multiple ALTER requests for the same table
Support for SQL rewriting with custom rules

Quick Start

Communication and Feedback

Welcome to submit issue reports and suggestions via Github Issues
QQ Group: 779359816 (not full) 758940447 (full)
Gitter Recommended

Translated with www.DeepL.com/Translator (free version)

Documentation ¶

Overview ¶

Package soar is a command-line tool for SQL optimizing and rewriting.

Source Files ¶

View all Source files

doc.go

Directories ¶

Path	Synopsis
advisor Package advisor contain heuristic rules, index rules and explain translator.	Package advisor contain heuristic rules, index rules and explain translator.
ast Package ast is an interface for Abstract Syntax Tree parser	Package ast is an interface for Abstract Syntax Tree parser
cmd
soar Package soar is the main program of SOAR	Package soar is the main program of SOAR
common Package common contain many useful functions for logging, formatting and so on.	Package common contain many useful functions for logging, formatting and so on.
database Package database will take cover of communicate with mysql database.	Package database will take cover of communicate with mysql database.
env Package env contain virtual database build, rehash, cleanup.	Package env contain virtual database build, rehash, cleanup.

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL