Alembic is a tool for performing database schema migrations. We would like to support it.
Currently, questdb-connect offers some support for SqlAlchemy. However, changes to it and the core database are required to support Alembic.
Ongoing remedial work around the postgres connector is in progress, after which, this will be reviewed.
Update 25/10/24: One of the blockers for this issue is support for RETURNING, which is used by the built-in PostgreSQL support. This is non-trivial to add to QuestDB, due to differences in how transactions and asynchronous commits are handled.
Alembic is a tool for performing database schema migrations. We would like to support it.
Currently,
questdb-connectoffers some support for SqlAlchemy. However, changes to it and the core database are required to support Alembic.Ongoing remedial work around the postgres connector is in progress, after which, this will be reviewed.
Update 25/10/24: One of the blockers for this issue is support for
RETURNING, which is used by the built-in PostgreSQL support. This is non-trivial to add to QuestDB, due to differences in how transactions and asynchronous commits are handled.