a8m
Joined 10 years ago
Karma
28
Submissions
24
Member since
Sep 27
Works on entgo.io and atlasgo.io
View on Hacker NewsRecent submissions
Comment · 9 months ago
We just shipped Atlas v1.1 - The focus of this release is Database Security as Code and Declarative Data Management.
You can now declare database users, roles, permissions, and managed seed data as code - versioned, reviewed, and applied via CI/CD like schema changes.
Feel free to share any thoughts or feedback.
Comment · 9 months ago
Ariel from Atlas here. This setup is pretty common (declarative locally, versioned in real environments). Since migrations are auto-generated (by Atlas) on PRs, most developers never touch the versioned workflow directly.
See: https://atlasgo.io/concepts/declarative-vs-versioned#combini..., and https://github.com/ariga/atlas-action?tab=readme-ov-file#ari...
Comment · 1 year ago
Good point regarding ORMs - that was one of the main problems I wanted to tackle when we built Atlas (https://atlasgo.io). We added support for reading ORM definitions directly, then let you extend the "base schema" defined in them. For example, you can define your models in SQLAlchemy, EF Core, Ent, or others as a partial schema, and then extend it with functions, views, and additional objects.
From there, Atlas handles diffing, planning, and execution. This is similar to importing modules in TF, but for database schemas in Atlas. See this example: https://atlasgo.io/guides/orms/sqlalchemy
Disclaimer: I'm involved with Atlas.
Comment · 2 years ago
I'm glad to see I'm not the ~only one bothered by this issue. This has been, and still is, one of the challenges in managing MySQL schemas.
That's one of the reasons we implemented "migrate down" differently than other tools.
I'm not here to promote my blog post, but if you are interested in seeing how we tackled this in Atlas, you can read more here: https://atlasgo.io/blog/2024/04/01/migrate-down
Comment · 3 years ago
Check out: https://github.com/ariga/atlas. It’s like Terraform for databases.
(I'm one of the authors of this project).
Comment · 3 years ago
Hey! For a long time, one of the most common feature requests we've been getting from our users is the ability to manage their desired "schema state" using SQL. For this reason, we're excited to announce the release of Atlas v0.9.0, which fully supports SQL.
We also released the Atlas Playground, where users can visualize their database schemas and plan migrations in an interactive way. Check out the example below and let me know what you think <3
Playground example - https://gh.ariga.cloud/explore/01d2aeb1
Comment · 3 years ago
Hey, I am the creator of entgo.io. I'm sorry to hear that your experience with the project was not great. I try to be available on our Discord, Slack, or the issue tracker, but sometimes I do miss some messages. If you ever consider to rejoin the community, please don't hesitate to drop me a message on our Discord.
I would also like to emphasize that Ent is an open-source project under the Linux Foundation, and it is not monetized in any way. Most of my work on it in the last years was on my free time, including when I was working at Facebook and wanted to OSS it. We (heavily) use Ent in our own products today, and that is why we continue to sponsor and maintain the project. I love it and I find it useful.
Thanks for the honest feedback. I appreciate it.
Comment · 4 years ago
Just to emphasize, that OSS version of Ent models SQL tables in the traditional way (edges as foreign-keys and join-tables). i.e., the database structure is not obscure or something and can be easily read by developers and ported to other ORMs in case it's needed.
Comment · 4 years ago
Yes. The migration is built on top of Atlas: https://github.com/ariga/atlas
Comment · 4 years ago
Happy to share with you the new version of Atlas, the terraform for databases and a migration engine.
There are many great features in this release, but one of the biggest features we added is multi-tenant support. Using this option, users can define, in a few lines of code, that a migration should be executed on N databases/environments.
Please, checkout the code examples in the link and share your thoughts on it. Your feedback is greatly appreciated.
Comment · 4 years ago
Hey! Would love to share with you the latest release of Atlas - the migration engine we are working on.
Currently, this tool provides a variety of capabilities for versioned migrations, including automatic migration authoring, linting migrations, and their execution on the database. We are already working on features that will make troubleshooting and fixing bad migrations much easier.
Appreciate any feedback or suggestions you may have for improvements. Thanks <3