OpenMLDB V0.4.0 has been released to enhance SQL development and management experience

Making: github.com/4paradigm/O… Docs: OpenMLDB Docs: OpenMLDB Docs

OpenMLDB v0.4.0 Release Notes

Sql-centered development and management experience is fully enhanced for both standalone and cluster versions. You can now do all of your development, deployment, and administration tasks based on SQL and CLI, making OpenMLDB much easier to use. (# 991, # 1034, # 1071, # 1064, # 1061, # 1049, # 1045, # 1038, # 1034, # 1029, # 997, # 996, # 968, # 946, # 840, # 830, # 814, # 776, # 774, # 764, # 747, # 740, # 466, # 481, # 1033, # 1027, # 966, # 951, # 950, # 932, # 853, # 835, # 804, # 800, # 596, # 595, # 568, # 873, # 1025, # 1021, # 1019, # 994, # 991, # 987, # 912, #896,#894,#893,#873,#778,#777,#745,#737,#701,#570,#559,#558,#553@tobegit3hub; #1030,#965,#933,#920,#829,#783,#754,#1005,#998@vagetablechicken)
Chinese documentation has been fully improved, and you can access the full usage and development documentation here: docs.openmldb.ai/ GitHub repo: github.com/4paradigm/o… And we look forward to your contribution.
Experimental features: Introduced an online monitoring scheme based on Prometheus + Grafana (#1048@aceforeverd)

Support for new SQL syntax: LIKE, HAVING (#841@aceforeverd; #927,#698@jingchen2222)
Support for new built-in functions: Reverse (#1004@nautaa), dayofyear (#856@Nicholas-SR)
Improved compilation and installation process, now supports compilation from source (#999,#871,#594,#752,#793,#805,#875,#871,#999@aceforeverd; #992@vagetablechicken)
GitHub CI/CD Workflow (#842,#884,#875,#919,#1056,#874@aceforeverd)
Support for system databases and system tables (#773@dl239)
Improve and refine functional functionscreate index (# 828@dl239)
Improved Demo image (#1023,#690,#734,#751@zhanghaohit)
Improve the Python SDK (#913,#906@tobegit3hub; #949,#909@HuilinWu2; #838@dl239)
Simplified execution mode (#877,#985,#892@jingchen2222)
Add cluster-based data import and export tool (#1078@tobegit3hub)
Added new cluster deployment commands (#921@dl239)
Support for creating tables is to use default values (#563@zoyopei)
supportstringType delimiters and quotes (# 668@ZackeryWang)
Add newlru_cacheTo support theupsert (# 795@vagetablechicken)
Support using anytsColumn to increment the index (# 828@dl239)
Improvements insql_insert_nowAbout the functiontsColumn processing (# 944 ,# 974@keyu813)
Improved documentation (#952#885@mahengyang; #834@Nicholas-SR; #792,#1058,#1002,#872,#836,#792@lumianph; #844,#782@jingchen2222; #1022,#805@aceforeverd)
Code cleanup (#1073@dl239)

# 847, # 831, # 647, # 934, # 953, # 1015, # 982, # 927, # 994, # 1008, # 1028, # 1019, # 779, # 855, # 350, # 631, # 1074, # 1073, # 1081

The SQL-centric feature is enhanced for both standalone and cluster versions. Now you can enjoy the SQL-centric development and deployment experience seamlessly. (# 991, # 1034, # 1071, # 1064, # 1061, # 1049, # 1045, # 1038, # 1034, # 1029, # 997, # 996, # 968, # 946, # 840, # 830, # 814, # 776, # 774, # 764, # 747, # 740, # 466, # 481, # 1033, # 1027, # 966, # 951, # 950, # 932, # 853, # 835, # 804, # 800, # 596, # 595, # 568, # 873, # 1025, # 1021, # 1019, # 994, # 991, # 987, # 912, #896,#894,#893,#873,#778,#777,#745,#737,#701,#570,#559,#558,#553@tobegit3hub; #1030,#965,#933,#920,#829,#783,#754,#1005,#998@vagetablechicken)
The Chinese documentations are thoroughly polished and accessible at docs.openmldb.ai/ (the mirror in China: Docs -cn.openmldb.ai). This documentation repository is available at github.com/4paradigm/o… , and you are welcome to make contributions.
Experimental feature: We have introduced a monitoring module based on Prometheus + Grafana for online feature processing. (#1048@aceforeverd)

Support SQL syntax: LIKE, HAVING (#841@aceforeverd; #927,#698@jingchen2222)
Support new built-in functions: reverse (#1004@nautaa), dayofyear (#856@Nicholas-SR)
Improve the compilation and install process, and support building from sources (#999,#871,#594,#752,#793,#805,#875,#871,#999@aceforeverd; #992@vagetablechicken)
Improve the GitHub CI/CD workflow (#842,#884,#875,#919,#1056,#874@aceforeverd)
Support system databases and tables (#773@dl239)
Improve the function create index (# 828@dl239)
Improve the demo image (#1023,#690,#734,#751@zhanghaohit)
Improve the Python SDK (#913,#906@tobegit3hub; #949,#909@HuilinWu2; #838@dl239)
Simplify the concepts of execution modes (#877,#985,#892@jingchen2222)
Add data import and export for the cluster version (#1078@tobegit3hub)
Add new deployment command for the cluster version (#921@dl239)
Support default values when creating a table (#563@zoyopei)
Support string delimiters and quotes (#668@ZackeryWang)
Add a new lru_cache to support upsert (# 795@vagetablechicken)
Support adding index with any ts_col (# 828@dl239)
Improve the ts packing in sql_insert_now (# 944 ,# 974@keyu813)
Improve documentations (#952#885@mahengyang; #834@Nicholas-SR; #792,#1058,#1002,#872,#836,#792@lumianph; #844,#782@jingchen2222; #1022,#805@aceforeverd)
Other minor updates (#1073@dl239)

# 847, # 831, # 647, # 934, # 953, # 1015, # 982, # 927, # 994, # 1008, # 1028, # 1019, # 779, # 855, # 350, # 631, # 1074, # 1073, # 1081

@nautaa, @Nicholas-SR, @aceforeverd, @dl239, @jingchen2222, @tobegit3hub, @keyu813