Get Database Insight 💡
Learn product updates and everything about database.
📕 What is Filesort / External merge sort?
When performing sorting operations for ORDER BY, GROUP BY and there is no sufficient memory to sort all data at once, database will partition the data, sort them batch by batch and write the intermediate sorting results to disk. Since it involves heavy I/O operations, it will drastically impact query performance.
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.
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.