python, sqlalchemy, geoalchemy2 and postgis

[cweber9843]

I want to use python and geoalchemy to query a postgis database with materialized views.
Are there others here who are working with this?

I have used sqlalchemy and postgres before to query tables, but the materialized views give me a headache.
Main problem is how to reflect the existing views, in order to be able to query them.
Any hints are welcome, and maybe there even are enough interested to take this up in the study group?

[annefou]

This is an excellent idea for a studyGroup session. I would be happy to organize it.

[cweber9843]

Nice, thanks! I now managed to get the materialized view working, but of course I am running into new problems, so there is a lot to discuss! We can add "geopandas" to the topics to talk about.