> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bytebase 3.0.0 - Oct 24, 2024

> AI Assistant for SQL Editor

Check out our official 3.0 announcement - [Bytebase 3.0 - DevSecOps for Database](https://www.bytebase.com/blog/bytebase-3-0/)

## 🚀 New Features

* [AI Assistant for SQL Editor](/sql-editor/ai-assistant/): Convert natural language into SQL, explain SQL queries and identifies potential problems.
* Support 1-click rollback for SQL Server DML change.
* Support gh-ost online schema change for MariaDB.
* Add new SQL Review Rules:
  * Require `MAX_EXECUTION_TIME` for MySQL.
  * Require `MAX_STATEMENT_TIME` for MariaDB.
  * Require `ALGORITHM` and `LOCK` options for online DDL in MySQL/MariaDB.
  * Table comment checks for PostgreSQL/Oracle.
  * Column comment checks for PostgreSQL/Oracle.
* Separate SQL review rules to disallow mixing statements in DDL or DML tasks.

## 🔔 Notable Changes

### Behavior

We no longer allow the users to approve their own issues.

### API

* CEL parsed expressions have been updated to remove unused sourceInfo, impacting the following APIs: `/v1/cel/batchDeparse`, `/v1/cel/batchParse`, `/v1/workspaces/*:getIamPolicy`, `/v1/workspaces/*:setIamPolicy`, `/v1/projects/{project}:getIamPolicy`, `/v1/projects/{project}:setIamPolicy`.
* Force to set `group_email` while calling `POST /v1/groups` API to create a new group. For example, `POST /v1/groups?group_email=dba@bytebase.com`

## 🎄 Enhancements

* Support table-level risk rule for DML in Risk center.
* SQL Editor displays function signatures with parameters instead of just function names.
* SELECT prompt prioritizes columns over tables in SQL Editor.
* Ignore `bbdataarchive` schema for PostgreSQL during schema synchronization.
* Add `allow_missing` parameter in APIs `PATCH /v1/groups/{group}` and `PATCH /v1/roles/{role}`. For example, you can use `PATCH /v1/groups/not_exist_group?allow_missing=true` to create a new group if the resource not found.
* Use user-specified PostgreSQL role in SQL review.

## 🎠 Community

* Thanks to [@blight19](https://github.com/blight19) for the PR: [#14114](https://github.com/bytebase/bytebase/pull/14114) fix: redis get database with proxy.

## ⚙️ Install and Upgrade

* [Fresh install](/get-started/self-host/deploy-with-docker)

* [Upgrade](/get-started/self-host/upgrade)

*Before upgrading: 1) Back up the [metadata](https://www.bytebase.com/docs/administration/back-up-restore-metadata/) — in-place downgrade is not supported. 2) Do not run multiple containers on the same data directory. 3) Terraform users: upgrade Bytebase server first, then apply the new Terraform config.*