User 46924c5277
30-07-2012 20:11:08
I see from the documentation that the JChem cartridge requires Oracle. Has there ever been a version of the JChem cartridge for other databases? I'm specifically interested in PostgreSQL.
Thanks in advance,
Bob
User 46924c5277
30-07-2012 20:11:08
I see from the documentation that the JChem cartridge requires Oracle. Has there ever been a version of the JChem cartridge for other databases? I'm specifically interested in PostgreSQL.
Thanks in advance,
Bob
ChemAxon 9c0afc9aaf
30-07-2012 20:53:06
Hi Bob,
We've only ever had cartridge for Oracle.
I'm not sure about the long term plans (my colleagues may comment on this), but it's a lot of effort to develop and maintain yet an other cartridge.
However JChemBase (JCB) supports about 10 different RDBMS, including PostgreSQL.
The Cartridge is really "just" a wrapper around the JCB engine.
It is usually needed for the following reasons:
1. non-Java programming environments
2. indexing molecule columns in existing database structure
(usually needed when replacing an other cartridge)
3. centralizing computations and Structure Cache
Which one would describe your needs ?
We have alternative solutions for #1 and #3 , e.g. .NET API and Web Services (SOAP).
So if #2 is not a must, you might consider using JChem Base.
In certain cases you might even get better performance from JCB (less overhead).