EdgeDB 5.0 Launches with Branching Functionality

EdgeDB 5.0 graph-relational database introduces branching functions to align database and code branches for efficient schema changes.

EdgeDB, a cutting-edge relational database management system, is stepping into a new era with the release of its brand-new version 5.0, introducing a suite of enhancements and new features designed to improve database management’s flexibility, efficiency, and user-friendliness.

Haven’t you heard of EdgeDB? In short, it is an open-source database that uses the PostgreSQL query engine, enhancing it with a unique approach to data schema that mirrors how developers conceptualize their data structures—essentially viewing them as objects connected by links. Now, back to the topic.

What’s New in EdgeDB 5.0

The highlight of the 5.0 release is a shift from traditional database structures towards a more dynamic “branching” model. This new model treats databases as “branches,” mirroring the version control systems commonly used in software development.

This allows developers to manage changes in database schemas with the same fluidity as code changes, facilitating a more integrated and streamlined workflow. Key commands introduced include creating, copying, renaming, and dropping branches and rebasing them to align with updates in code branches.

Among the other standout new capabilities of EdgeDB 5.0 is the updated pgvector extension, which now includes support for Hierarchical Navigable Small Worlds (HNSW) indexes. These indexes enhance the performance of vector operations, which is crucial for applications involving complex queries and large datasets.

The update also simplifies the configuration of vector indexes, making it more accessible for users to optimize database performance according to their needs.

Furthermore, EdgeDB 5.0 introduces significant improvements in its authentication mechanism, including passwordless options, such as WebAuthn and email-based “magic links,” along with OAuth support for popular platforms like Slack and Discord.

Performance optimizations have also received attention in EdgeDB 5.0, with enhancements such as a persistent query compilation cache and more efficient handling of large schemas and migrations.

Lastly, for those eager to adopt EdgeDB 5, it is important to use the pre-release version specified as “5.0-rc.1” when initializing new projects, as the default setup might not fetch the latest release candidate. Upgrading existing projects is straightforward, with commands to update local and cloud-based instances.

However, keep in mind that EdgeDB 5.0 only supports PostgreSQL 16 or above, necessitating a PostgreSQL upgrade if using older versions. For detailed information about all changes in the latest version, visit the release announcement.

Bobby Borisov

Bobby Borisov

Bobby, an editor-in-chief at Linuxiac, is a Linux professional with over 20 years of experience. With a strong focus on Linux and open-source software, he has worked as a Senior Linux System Administrator, Software Developer, and DevOps Engineer for small and large multinational companies.

Think You're an Ubuntu Expert? Let's Find Out!

Put your knowledge to the test in our lightning-fast Ubuntu quiz!
Ten questions to challenge yourself to see if you're a Linux legend or just a penguin in the making.

1 / 10

Ubuntu is an ancient African word that means:

2 / 10

Who is the Ubuntu's founder?

3 / 10

What year was the first official Ubuntu release?

4 / 10

What does the Ubuntu logo symbolize?

5 / 10

What package format does Ubuntu use for installing software?

6 / 10

When are Ubuntu's LTS versions released?

7 / 10

What is Unity?

8 / 10

What are Ubuntu versions named after?

9 / 10

What's Ubuntu Core?

10 / 10

Which Ubuntu version is Snap introduced?

The average score is 68%