Atlas (Issue #11): Atlas at KubeCon, Announcing v0.15.0: Interactive Declarative Migrations, Support for Functions and Stored Procedures, SQL Server and more!
Hi everyone!
Welcome to the 11th edition of our newsletter, where we periodically share updates and fresh content about everything Atlas.
Here is what you can find in this edition:
Atlas v0.15:
Interactive Declarative Migrations
Support for Functions, Stored Procedures and Domains
Support for TypeORM
Automatic migrations for Microsoft SQL Server and Sequelize ORM
Revamping the GitHub Actions Experience for Atlas
Atlas at KubeCon, DevOpsDays Warsaw and DevOpsDays Madrid!
All the best,
Ariel and Rotem
P.S. Have you joined our Discord server? Join us and the rest of the community for Atlas-related discussions and help.
Announcing v0.15: Interactive Declarative Migrations, Functions, Procedures and Domains
A few weeks ago we released our latest version with very exciting and long-awaited features!
Read our announcement blog post.
Interactive Declarative Migrations
Atlas supports a Terraform-like workflow for managing your database schema using the schema apply
command.
In this release, we are introducing a new "Lint and Edit" mode to this command, which will analyze your schema changes for issues and will allow you to edit them interactively before applying them to your database. This mode is available to logged-in users only, as it uses Atlas Cloud to provide a neat UI and rich analysis capabilities.
Functions and Stored Procedures
Over the past few months, we have received numerous requests to support management of functions and stored procedures in popular databases such as PostgreSQL and MySQL.
Atlas now supports creating and managing functions and stored procedures in your database schema in both HCL and SQL.
Postgres Domains
Support Postgres Domains, another widely requested feature, is officially available! Starting with v0.15, Atlas can now manage domains in your database schema, as well as use them as types for table columns.
Support for TypeORM
TypeORM is a popular ORM for Node.js. In this release, we are happy to announce the TypeORM integration, which allows you to automatically generate your database schema from your TypeORM entities, create visualizations and more.
The TypeORM Atlas Provider is a Node.js module that can extract the desired schema of your database directly from your TypeORM entities.
Automatic Migrations for Microsoft SQL Server and Sequelize
Atlas now supports Microsoft SQL Server and Sequelize!
Microsoft SQL Server, one of the longest-standing database engines in our business, was first released by Microsoft in 1989. MS-SQL is the go-to database for Windows environments in many industries.
Sequelize is one of the most popular ORMs for Node.js. It supports a variety of databases, including MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
Now you can use Atlas to manage and visualize your Microsoft SQL Server or Sequelize database schema.
Read the MS-SQL and Sequelize blogposts
Revamping the Atlas GitHub Actions Experience
In August of last year, we released our first version of the GitHub Actions experience for Atlas. It was a modest start, which included the ability to verify the safety and correctness of schema migrations during the CI process.
Over the past year, we have slowly added more features to the GitHub Actions experience, including the ability to sync migration directories to Atlas Cloud, deploy migrations, and even install Atlas. As often happens with quickly evolving systems, we felt that the API became complex, carrying over use cases and experiences that have become obsolete or superseded by better ones since the initial release.
The new actions follow the design principle of building actions as small, composable units that can be combined to achieve different outcomes. All of the actions are under one repository and rely on Atlas being installed on the GitHub Actions runner, which is done using the ariga/setup-atlas
action. The rest of the actions essentially map to CLI commands, and can be used to build more complex workflows.
Atlas Around the Globe: KubeCon and DevOps Days Warsaw + Madrid
This past month, Rotem and Jannik set out to give talks at multiple conferences and events. Thanks to all those that came by our booths to chat, we had a great time and hope to see you again!
KubeCon + CloudNativeCon North America
Rotem gave a talk with Kostis from Codefresh at KubeCon North America about updating databases the Gitops way. Together, they discussed the most popular ways and introduce a Kubernetes operator designed specifically for Database deployments. As well as, how to upgrade your databases with the same ease of deploying Kubernetes applications and embracing the GitOps principles for both stateful and stateless workloads and moving away from legacy practices to cloud-native workflows.
DevOpsDays Madrid
In this talk, Rotem discusses how making changes to your database in production can be risky – causing breaking changes, data loss, and degraded performance if not handled carefully. He dives into these challenges and discusses ways to make schema changes safer and more efficient. Rotem also explores the declarative model, used by tools like Terraform and Kubernetes, and showcases how to apply it to database schema management.
DevOpsDays Warsaw
Jannik gave the talk, ‘Schema-as-code: Developer platforms and database schema changes’. Jannik discussed the risks associated with making database schema changes, how tools like Atlas help make the changes safer and faster, and how to build these capabilities into your developer platform.
Link coming soon!
Schema Management with the Atlas Operator
This past month, Viktor Farcic released a new video talking about the Atlas Kubernetes Operator. In it, he discusses how to efficiently manage your database schemas in a Kubernetes environment, improve scalability and reduce maintenance efforts.
Wrapping up
Thanks for reading this edition of the Atlas newsletter! If you have suggestions or requests for Atlas or this newsletter, feel free to drop us a line on Discord, Twitter, or GitHub.