[sqlalchemy] compatibility between SQLite and PostgreSQL

2020-08-14 Thread polkapiquee
Yes it is possible to create SQLAlchemy models that work on both PostgreSQL and SQLite. I've done it myself. It works ok for simple models and it is relatively easy to mimic Postgres functions as SQLite UDFs. However it will get harder if you need to use RETURNING queries or other postgres go

[sqlalchemy] compatibility between SQLite and PostgreSQL

2020-08-14 Thread Alceu Rodrigues de Freitas Junior
Greetings, My name is Alceu and this is my first post to this group and I'm a newbie regarding SQLAlchemy. I have some projects that are using SQLAlchemy and PostgreSQL and they are running fine until we have to run automated tests that uses PostgreSQL and they took ~5 minutes to complete, eve