Support ActiveRecord, Postgres/MySQL

[Aubermean]

Would it be possible to use postgres as the store, rather than mysql + trilogy? Or is there some major reasoning why mysql was chosen? Thanks!

[devanandersen]

@Aubermean 👋🏼

There shouldn't be any blockers for adding Postgres support, ensuring that we don't use any non-standard SQL statements in any implementations.

If we use ActiveRecord as an abstraction, and no MySQL-specific database statements are used we should be alright.

[Aubermean]

Hi, thank you for confirming! I know this is a Shopify-first engine that you are most likely abstracting from a greater monolith, and I know you guys use Trilogy... but I think supporting plain old ActiveRecord and mysql/postgres would be helpful for the greater community :)

[devanandersen]

Hi, thank you for confirming! I know this is a Shopify-first engine that you are most likely abstracting from a greater monolith, and I know you guys use Trilogy... but I think supporting plain old ActiveRecord and mysql/postgres would be helpful for the greater community :)

There's no reason for us not to do so in Atlas Engine, I agree! We welcome contributions and are available for review. Worst case we'll have this issue in our back pocket when we can allocate some time to support 🙂