Hi everyone!
Welcome to the fourth edition of our newsletter, where we periodically share updates and fresh content about everything in Atlas.
Here’s what you can find in this edition:
Read all about v0.90, the latest release of Atlas that includes the long-awaited first-class citizen support for SQL.
New guides on deploying schema changes to AWS ECS (Fargate) and Fly.io. In addition, we added a guide on how to use Atlas to manage schema migrations for sqlc, a popular tool for using SQL in applications written in Go.
Finally, we’re happy to announce that we started publishing videos on our YouTube channel, so head over there and give us a +1 if you enjoyed them :-)
Happy weekend,
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 Atlas v0.9.0: SQL as a First-Class Citizen
For a long time, one of the most common feature requests we've been getting from our users is the ability to ma
nage their desired "schema state" using SQL. This is understandable, using Atlas DDL (HCL) can feel unfamiliar to some users, especially those who have never worked with Terraform before. For this reason, we're excited to announce the release of Atlas v0.9.0, which now fully supports SQL.
Declarative migrations for sqlc
sqlc
is a tool that generates type-safe idiomatic Go code from SQL queries. It's like a transpiler, where you provide the required queries along with the database schema, and sqlc
generates code that implements type-safe interfaces for these queries.
In this guide, we will show you how Atlas can be used with sqlc
in a declarative way, filling the gaps and providing a complete solution for building applications with sqlc
.
Using Atlas with Fly.io
Fly.io is a platform for running full-stack apps and databases close to the users. In this guide, we will demonstrate how Atlas can be used to perform database schema migrations for Fly.io deployments process using a Dockerfile.
Deploying to AWS ECS (Fargate)
AWS Elastic Container Service (ECS) is a popular way to deploy containerized applications to AWS. ECS is a managed service that allows you to run containers on a cluster of EC2 instances, or on AWS Fargate, a serverless compute engine for containers. In this guide, we will demonstrate how to deploy schema migrations to ECS/Fargate using Atlas.
Fresh from our YouTube channel
Versioned schema migrations with Atlas
Declarative schema migrations with Atlas
How to automatically plan schema migrations with Atlas
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.