JChem cartridge database

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).