Get Database Insight 💡

Learn product updates and everything about database.

📕 What is HTAP (Hybrid transactional/analytical processing)?

A new term coined recently to combine the transactional and analytical power into a single system. Traditionally, transactional and analytical processing are handled by different systems, which causes the headache of maintaining 2 separate systems as well as duplicating the data and managing the pipeline to copy the data from the online transactional system to the analytical system. HTAP gains popularity because it eliminates the duplicate system and data, making near real-time analytic possible. On the other hand, the challenge still remains as how to efficiently handle both transactional and analytical workload in the same system, and how to prevent analytical workload interfering with online transactional processing.

Safer and faster database change and version control for DBAs and Developers

Bytebase is an open source, web-based database schema change and version control tool for teams. It offers a web-based collaboration workspace to help DBAs and Developers manage the lifecycle of application database schemas.

mysql postgresql clickhouse tidb snowflake gitlab

Features

SQL Review

A dedicated review workflow and UI for Developers and DBAs to collaborate on schema changes. Assisted by built-in advisor such as backward compatibility checks.

Database-as-Code

Integrate with VCS hosting the migration scripts. Migration pipeline is triggered on observing new script push event.

Streamlined Deployment

Support multi-tenant (M), multi-environment (N) schema change in a single M*N change matrix pipeline.

SQL Editor

Easy-to-use query interface to SELECT database records.

Migration History

Record the full migration history with side-by-side diff comparison between versions.

Anomaly Center

Periodically scan all managed instances and databases and provide user a holistic view to see all anomalies.

Drift Detection

Periodically scan all managed instances and databases and provide user a holistic view to see all anomalies.

Backup and Restore

Per-database automatic and manual backup. Environment specific backup schedule policy. Restore to new database with the entire restored migration history chain.

Role-based Access Control

Two role set. Owner, DBA, Developer for workspace. Owner, Developer for project.