We are thrilled to announce the public preview of our new feature: Static Data for PostgreSQL Database using Flyway. This feature is designed to enhance your database management experience by allowing you to manage static data alongside your schema seamlessly for versioning and deploying your database changes.

What is Static Data?

Static data refers to data that does not change frequently and remains relatively constant over time. Examples of static data include configuration settings, reference data, lookup tables, and predefined lists of values. Unlike dynamic data, which is regularly updated and modified, static data is typically used to support the application’s functionality and provide consistent information across different environments.

What is Static Data for PostgreSQL Database Using Flyway?

Flyway is a popular database migration tool that makes it easy to manage and track changes to your database schema. With the introduction of static data management, you can now include static data in your version control and deployment processes. This ensures that your static data remains consistent across different environments and deployments.

Why Flyway is a Great Platform to Manage Static Data Changes

Flyway offers several advantages when it comes to managing static data changes:

• Consistency: Flyway ensures that static data remains consistent across all environments by including it in the version control and deployment processes. This helps prevent discrepancies and ensures that all instances of the database have the same static data.
• Version Control: By tracking changes to static data alongside schema changes, Flyway allows you to maintain a clear history of modifications so you can see who changed what data, when and why. This makes it easier to understand the evolution of your static data and revert to previous versions if necessary.
• Seamless Integration: Flyway integrates static data management into your existing workflows, allowing you to manage both schema and static data changes using the same tool. This simplifies the deployment process and reduces the risk of errors.
• Automated Deployment: Flyway’s automated deployment pipelines ensure that static data changes are applied consistently across all environments. This reduces the manual effort required and minimizes the risk of human error.

How to Get Started

To start using static data for using Flyway, update to Flyway Desktop version 7.8 or Flyway Engine version 11.3.3. and follow the documentation to configure static data management for your PostgreSQL database. Detailed instructions and examples are available to help you get up and running quickly, which can be found here.

Share Your Feedback

We value your feedback and would love to hear about your experience with this new feature. Your insights will help us improve and refine the functionality. Please share your feedback with us here.

We have also introduced a new feature in Flyway Desktop, that facilitates users to share their feedback directly through the product (screenshot below).

What’s next?

We are also currently privately previewing Partitions table support for PostgreSQL users. If you would like to participate in the private preview or early access program, then please send us a quick email.

More about our preview features and upcoming major releases can be found here.

Thank you for being a part of our community and helping us make our tools better for everyone.