> ## 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 1.2.1 - Jul 07, 2022

> - In-place Point-in-time Recovery for the database (preview version). - Added GET /v1/sql/advise OpenAPI.

## 🚀 New Features

* In-place Point-in-time Recovery for the database (preview version).
  <img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/1.2.1/restore-database.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=5591ce20d2d73761de318800bc1289ff" alt="restore-database" width="988" height="1144" data-path="content/changelog/1.2.1/restore-database.webp" />

* Added GET /v1/sql/advise OpenAPI.

It allows users to perform SQL reviews via API after configuring the schema review policy. Users can access its API documentation via `/swagger/index.html` once they start their Bytebase service.

<img src="https://mintcdn.com/dbx/NPAsXofNFOH9Jrw-/content/changelog/1.2.1/sql-open-api.webp?fit=max&auto=format&n=NPAsXofNFOH9Jrw-&q=85&s=d77f47ed0aa7d44ea13c05e3ba46a710" alt="sql-open-api" width="3022" height="4986" data-path="content/changelog/1.2.1/sql-open-api.webp" />

## 🎄 Enhancements

* Added cluster support for ClickHouse database creation.
* Support GitLab merge request commit in GitOps workflow.
* Clicking on issue, project, database … table rows with cmd/ctrl pressed will open the link in a new tab.

## 🐞 Notable bug fixes

* Fixed unable to archive environment even when the environment has no active instance.
* Fixed unrecognized PostgreSQL index names with quotes.
* Fixed in VCS workflow, duplicate issues created upon receiving merge branch commit.

## 🎠 Community

* Thanks to [@Cluas](https://github.com/Cluas) for:
  * [fix(pg): need update current owner after switch database #1689](https://github.com/bytebase/bytebase/pull/1689)
  * [fix: ssl certs missing #1654](https://github.com/bytebase/bytebase/pull/1654)
* Thanks to [@Innei](https://github.com/Innei) for:
  * [perf: concurrent request improve fetch table data speed #1674](https://github.com/bytebase/bytebase/pull/1674)
  * [pref: concurrent request improve fetch table data speed #1660](https://github.com/bytebase/bytebase/pull/1660)
  * [feat(editor): add spin when editor is loading.#1659](https://github.com/bytebase/bytebase/pull/1659)
  * [pref: lazyload monaco editor speed up navigator to sql editor route #1655](https://github.com/bytebase/bytebase/pull/1655)

## ⚙️ 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.*
