SQLAlchemy Core vs PyDAL?

[Jurgis Pralgauskis]

Hi, 

What are main differences between two of those?

their ideology seems similar -- no ORM , but pyDAL seems less verbose

https://docs.sqlalchemy.org/en/13/core/tutorial.html#define-and-create-tables

it also has similar concept for selected results (Store):
https://docs.sqlalchemy.org/en/13/core/connections.html#sqlalchemy.engine.ResultProxy

curious, could pyDAL be based on Alchemy Core (Expression language) --  it already supports may sql-engines?

[Massimo Di Pierro]

Unless things change web2py supports more engines than sqlalchemy ven if not all equally well.

The migration logic is very different. The syntax is very different. pydal is integrated with web2py forms and has logic for exposing REST APIs. It is actually being improved a lot these days. I will write some docs in the next couple of weeks.

Massimo