I am looking for extensions/add-ons for relational databases (RDBMS) that enable storing and handling chemical structures including the possibility for substructure searches and similarity search.
[..] an extension for the Oracle 11G database that adds registration and indexing of chemical structures to support fast substructure and similarity searching.
This is what the application needs.
The problem is that OrChem does not seem to be maintained anymore, the last release happened almost 10 years ago. From what little I could find in my research, I got the impression that OrChem also only seems to play nice with Oracle 11G, which will soon reach the end of its extended support lifecycle.
So, since I have the need to upgrade the underlying database, I am looking for information on alternatives (or, if someone can offer, experiences with running OrChem with versions >= Oracle 12).
For possible alternatives, projects that I could find are
MyChem, an extension similar to OrChem for the MySQL database (versions >= 4.0) and MariaDB. Of the projects I could find, this one is the least outdated, but even that means that the last release happened 6 years ago.
chemsearch, for which again, the last release happened about 10 years ago. This one seems to be relatively mature (version number is 3.2) and it supports at least the Oracle and PostgreSQL RDBMS, the source code zip also has folders named
mysql. However, since I could not find a real documentation, I am unsure which versions of the different RDMBS are actually supported.
Can anyone offer deeper insights concerning the compatibility of the listed cheminformatics extensions with concrete RDBMS versions and/or more current alternatives that are not listed here?