May 2024 - Cloudberry Database Community Newsletter

[tuhaihe]

❤️ Cloudberry Database? Giving it a ⭐ on the cloudberrydb/cloudberrydb repo!

New Release

Cloudberry Database v1.5.3 was released with a few improvements, bug fixes, and doc updates. You can check the release notes for details.

Our Bootcamp program has supported Cloudberry Database v1.5.2 in #422, but we will not support v1.5.3 because extra dependencies are needed in this release. We will update the bootcamp until the next release v1.5.4 this June.

Highlights

In the past weekends, Cloudberry Database was on the "GitHub trending/C" list for two days. And our stars grew a lot, thanks to all the stargazers:

Ecosystem

PostGIS for Cloudberry Database is in public - @cloudberrydb/postgis. You can follow the guide to build it on Cloudberry Database. We will upgrade the PostGIS kernel in the following months.

Pull Requests

• [Answer Query Using Materialized Views] Consider mutable functions and bypass expressions have no Vars for view query target.  #455 by @avamingli
• Enhance: Add warehouse_id to pg_stat_activity_extended #453 by @lss602726449
• Insert more data to make tuplestore spill in regress/misc_jiras.sql. #452 by @fanfuxiaoran
• [AQUMV] Use contain_var_clause instead of pull_var_clause. #451 by @avamingli
• CPP keywords should not be used as function/parameter names #449 by @jiaqizho
• Cherry-pick Resgroup related code from GreenPlum [Mar 2, 2022 - Feb 7, 2023] #448 by @foreyes
• Add hook for exec_simple_query and support self-defined spilling memory threshold in cost module. #447 by @songdongxiaoa2
• [Answer Query Using Materialized Views] Support LIMIT/OFFSET/FETCH clause on origin query. #446 by @avamingli
• Cleanup the build tools and guide directories #445 by @tuhaihe
• Expand a new external var tag #443 by @jiaqizho
• PendingDelete: expand the pending deletes interface #442 by @jiaqizho
• [Answer Query Using Materialized Views] Support Postgres special grammar DISTINCT ON clause on origin query. #441 by @avamingli
• [WIP] Cherry-pick ResourceGroup update from GreenPlum #440 by @foreyes
• [AQUMV] Support DISTINCT clause on origin query. #439 by @avamingli
• Fix checking password file permissions in dbconn.py #438 by @fanfuxiaoran
• [ORCA] Fix flaky "Invalid key is inaccessible" fallback (#15147) #437 by @fanfuxiaoran
• Fix motion toast error. #436 by @gfphoenix78
• Refactor cbload to gpdirtableload with python. #435 by @wenchaozhang-123
• Fix explain(locus) issues. #433 by @avamingli
• Cherry pick from GPDB (02/07/2022-02/28/2022) #432 by @avamingli
• Remove cbload relevant codes. #431 by @wenchaozhang-123
• checkberry gpcheckperf series updates are used to solve the problem that cbdb 1.5.2 version gpcheckperf does not display disk information #430 by @August-beaulo
• Update the googletest module URL #429 by @tuhaihe
• Add function cbdb_relation_size #428 by @fanfuxiaoran
• Fix drop directory privilege check. #425 by @wenchaozhang-123
• Fix visimap consults for unique checks during UPDATEs #423 by @lss602726449

Issues

• [Bug] Cannot access the code URL for googletest to result in GitHub Dependabot can't update dependencies. #427 by @tuhaihe
• [Bug] cbdb 1.5.2 version gpcheckperf does not display disk information #421 by @August-beaulo

Contributors

🎈️🎊️ Thanks to the following contributors for helping make Cloudberry Database better this month:

@avamingli, @lss602726449, @fanfuxiaoran, @jiaqizho, @foreyes, @songdongxiaoa2, @tuhaihe, @gfphoenix78, @wenchaozhang-123, @August-beaulo, @vitalboyzf, @TomShawn

Join us

The Cloudberry Database community welcomes everyone to contribute, regardless of their level of experience. We encourage all types of contributions, no matter how small. Our contribution guide is available to help you get started with the process.

In addition, we offer various channels for community members to discuss, seek help, provide feedback, and chat. You can find support here. Let us know if you have any questions or feedback - we're always here to help!

Join us and be part of our community!

Past Newsletter

• April 2024 - Cloudberry Database Community Newsletter #419
• March 2024 - Cloudberry Database Community Newsletter #402
• February 2024 - Cloudberry Database Community Newsletter #389
• January 2024 - Cloudberry Database Community Newsletter #378

---