Database version control for everyone
“One of our secrets is that we’ve put the whole company under version control.“ by Daniel Lindner
What is Debbie?
Debbie is a database version control system.
Why should you choose Debbie?
Debbie is an extremely easy-to-install and easy-to-use application designed primarily for software developers. Debbie delivers a real solution for tracking database changes.
Aim
Debbie is designed with one clear goal in mind: to streamline the release process by automating the generation of SQL scripts for new changes based on the differences identified between specific snapshots.
With Debbie, the days of manual scripting and tedious deployments are gone. Our platform automatically generates SQL scripts tailored to your database changes, ensuring seamless integration with your workflow. What's more, Debbie ensures compatibility with Flyway right out of the box, making migrations a breeze. Say hello to effortless release management with Debbie!
Version Control
For developers, the key requirement is to implement changes directly on the primary database to enable Debbie to detect them accurately using our bespoke "Track" function. This function, exclusively developed by our team, ensures precise monitoring of all modifications.
Debbie offers robust support for a variety of object types crucial to database management, including tables, indexes, constraints, views, procedures, functions, triggers, and notably, the ability to track records seamlessly.
Git Integration
Debbie seamlessly facilitates essential Git workflows through its embedded Git integration. Moreover, Debbie boasts a robust capability to visualize commit-graphs, enabling users to discern discrepancies across source files efficiently. Extending its versatility, Debbie is compatible with a plethora of Git providers including GitLab, GitHub, Bitbucket, and MS Azure, ensuring seamless integration regardless of the platform.
Benefits
Debbie stands out among its competitors by offering comprehensive database version control capabilities to our users. We're committed to providing unique, professional features that empower our customers, including end-to-end branch management and the ability to version control entire datasets or specific segments. What's more, we offer these for free.
Throughout the development process, ensuring compatibility with future support for additional database providers has been a top priority.
With Debbie, database version control becomes a seamless process, eliminating any hassle or compatibility issues. Join us in revolutionizing the way database versioning is done!
Continuous development
Currently, Debbie is exclusively in its Beta version, offering robust support solely for MySQL databases. However, rest assured, we're tirelessly enhancing Debbie to deliver an unparalleled user experience.
Our team is diligently working on rolling out the final alpha version soon, packed with even more cutting-edge features.
Moreover, we are excited to announce that we have plans to broaden the spectrum of supported database providers. In addition to MySQL, we are working on supporting Oracle, Microsoft SQL Server, and PostgreSQL . Stay tuned for these exciting updates!
Efficiency
Debbie is a user-friendly multiplatform application built with the most modern technologies, such as Java, React, Electron.
Debbie in operation
Whatch and learn
Pricing
Debbie is free of charge.
We are only able to keep our application free because of our users financial support. If you can afford it, please choose to support our work.
Frequently Asked Questions
Find answeres here to commonly asked questions about Debbie.
grant create on debbie.* to ''@'%';
grant create view on debbie.* to ''@'%';
grant create routine on debbie.* to ''@'%';
grant drop on debbie.* to ''@'%';
grant alter on debbie.* to ''@'%';
grant index on debbie.* to ''@'%';
grant references on debbie.* to ''@'%';
select on mysql.* to ''@'%';
grant select on debbie.* to ''@'%';
grant insert on debbie.* to ''@'%';
grant update on debbie.* to ''@'%';
grant delete on debbie.* to ''@'%';
grant execute on debbie.* to ''@'%';
grant show view on debbie.* to ''@'%';
grant trigger on debbie.* to ''@'%';
DEBBIE is currently not available on these platforms, but we are working on making it compatible with operating systems beyond Windows.
At the moment, DEBBIE only supports GIT. Within this, however, it works reliably with GitHub, GitLab, Microsoft Azure, and Bitbucket.
Currently, only MySQL is supported. Support for PostgreSQL, Oracle, and Microsoft SQL Server is coming soon, with additional providers planned for future releases.
Branch management is not available in the free trial version, but it will be included in higher-tier packages.
DEBBIE stores only database states.
Conflict resolution is left to the user, but the tool provides basic support (e.g., viewing both states of affected files and their differences).
In Debbie's terminology, a UNIT standardizes the different nomenclatures used by various database providers (e.g., DATABASE in MySQL, SCHEMA in Oracle, etc.).
DEBBIE generates a difference script based on a source and a target COMMIT. This script can be executed on the target database as part of the installation kit.
When connected to the internet, DEBBIE shows a bell icon indicating that a new version is available for download and installation. The process completes with a single click.
The number of users is specified during the license request. Currently, there is no user limit in the free version.
At the moment, only the free version is available. Paid versions with extended functionality will be released later.
You can support the project via the DONATE NOW button located in the center of the application’s header, or through the Donate | Debbie Version Control page. Supporters will receive discounts for upcoming paid editions.
In Debbie's terminology, a Track represents the unit of version control. It links together the UNITs managed within a single source and the Git repository that contains the source of the objects found in those UNITs.
Absolutely. You can manage any number of connections, each with multiple TRACKs.
Help is available under the HELP/Issues menu in the main navigation, or via the Debbie | Database version control page.