Use GeoAlchemy2?

[adrien-berchet]

Hi,
At some point you used GeoAlchemy2 to handle spatial data but then you reported trouble with the cache featured by SQLAlchemy. Thus in #3101 you chose to redefine your own Geometry type. I don't know if it's relevant for you because your Geometry type is quite simpler than the one from GeoAlchemy2, but I just wanted to let you know that we were able to re-enable the cache mechanism for all spatial types in the last release (0.17.0). So you may be interested.

[lonvia]

The custom Geometry type has evolved over the last two years into something very much tailored for the specific use of Nominatim. So I believe we'll just keep it because it would be too much work to go back.

That said it's still awesome that you managed to find and fix the issues around caching. I have other projects using GeoAlchemy2 that will profit from it and I'm looking forward to test the new version there. I did a quick test against the last version of Nominatim that did have GeoAlchemy2 and it runs fine with 0.17.0.