Can't have multiple simultaneous in-memory MonetDB farms active

[gijzelaerr]

We solve this now by switching context, but we run into issues in case of multiple in memory farms, our context switcher will return the same instance.

[gijzelaerr]

I now realise that I've been using the path as a context identifier, but maybe I should use the owning python connection as an identifier.

[ghost]

No, currently there are too many global variables to allow for multiple embedded (!) database connections to be open at the same time.
However, it is conceivable that you open a remote connection an using
rm = monetdbe.open(database='myremote', user=...., host='someip', port=5000)
and a
mm = monetdbe.open(':in-memory')

This way there can be at most one (1) in-memory database open

[gijzelaerr]

todo gijs: raise exception on double memory database