SQLAlchemy declarative extension vs. elixir

Question

I am planning to use SQLAlchemy in one of my projects and i am very interested in declarative syntax of tables.

I was told to use the Elixir Declarative Layer for that, at the same time SQLAlchemy has its built-in declarative extension.

What are the current differences between Elixir and the declarative extension? Advantages/disadvantages?

Answer 1

Elixir exists because SQLA Declarative didn't. Now that we have SQLAlchemy declarative, you probably don't need Elixir unless there's a specific way it does things that you prefer. Just be aware that Elixir is a dead project, and you will be stuck with an older version of SQLAlchemy.