Mychem 0.8.1: more than just a bug fix

Mychem 0.8.1 has been released on 2010-09-07.

This version fix an important bug. All functions using serialized obmol type were impacted. The problem has been resolved by using the solution published by the pgchem project.

Mychem is now fully usable with MySQL 5.0 and 5.1. It should also be working with MySQL 4.1, but it has not been tested.

The bug list is now empty. I'm waiting for new providers!

The version 0.7.0 of Mychem has been released

The version 0.7.0 of Mychem has been released on 2009-09-30.

This release represents a major bug-fix release and is a stable upgrade, strongly recommended for all users of Mychem.
While there may not be many new functions, several crashes and other bugs have been fixed since 0.6.0. The main changes are:

• Added the mol2_to_molecule() function
• Added the molecule_to_mol2() function
• Added the inchi_version() function
• Added the pdb_to_molecule() function
• Added the molecule_to_serializedOBMol() function
• Added the serialized OBMol type
• The code has been entirely rewritten
• The documentation has been updated
• Several bug fixes and small feature improvements

Mychem v0.6.0 is Released !

The version 0.6.0 of Mychem has been released on 2008-12-30. The main changes are:

• New functions:
  
  
  
  • bit_fp_or
  
  
  • bit_fp_count
  
  
  • bit_fp_and
  
  
  • molecule_to_inchi
  
  
  • inchi_to_molecule


• Bug fixes


• Updated documentation


• Molecule type is now MDL Molfile


• Works with Open Babel v2.1.1 and v2.2.0.

Two versions of Mychem are now available:

• Mychem² - Designed for Open Babel v2.1.1.


• Mychem³ - Designed for Open Babel v2.2.0.

Major fix in Mychem

A major bug has been fixed into Mychem. Fredrik Wallner has posted the main patch.
In some case, the return value of Mychem functions was blank and no error were raised.
Fredrik Wallner has founded that setting a character at the end of the string to '\0' fixes this issue.

The old code:
const char *inputMol = args->args[0];

The new code:
char *inputMol = (char *) malloc(sizeof(char)*(args->lengths[0]+1));
strncpy(inputMol, args->args[0], args->lengths[0]);
inputMol[args->lengths[0]] = 0;

This indicates that the character string given by MySQL as parameter does not contains the '\0' character at the end.

Many thanks to Fredrik Wallner !

The road is now open to go to the next release (0.6.0)

New release of Mychem

The version 0.5.5 of Mychem has been released on 2008-04-08. The main changes are:

• New functions:
  
  
  
  • strip_salts
  
  
  • molecule_to_canonical_smiles
  
  
  • is_2D
  
  
  • is_3D
  
  
  • is_chiral
  
  
  • number_of_rings
  
  
  • number_of_acceptors
  
  
  • number_of_donors
  
  
  • molpsa
  
  
  • molmr
  
  
  • mollogp
  
  
  
  


• Bug fixes


• Updated documentation

The Tanimoto function has been enhanced by two methods. The first was to store the
fingerprint as binary string. The second was to implement directly the tanimoto algorithm. Now, the Tanimoto coefficient computation of more than 70.000 entries takes less than 0.4 second on my laptop.

At least, a short article has been published about Pgchem and Mychem on Alchem.org.

Some news about Mychem

Mychem is an Open Source package providing a set of chemical functions for MySQL. These functions are designed to permit you to handle chemical data within a MySQL database.

The last version is v0.4.5 and has been released on 2008-02-18.

There are three major updates in this version:

• The build system has been modified (each module is in a directory)
• Five function have been added to the property module
• The documentation has now a troubleshooting appendix

The development of v0.5.0 has began on 2008-02-19. A new directory has been created for tests. The CTest tool, provided by CMake, is used to perform unit testing. The preliminary tests are working well.

Mychem 0.2 is out !

Mychem is an extension for MySQL that provides chemical functions. It's based on Open Babel 2 and is distributed under GPL-v2 license. In the current Mychem version, the following functions are supported:
- conversion of chemical files (CML, InChI, SMILES, MDL Mol)
- calculation of some chemical properties (formula, molecular weight)

Other functions, like fingerprint generation or tanimoto calculation are available on the SVN trunk:
svn co https://mychem.svn.sourceforge.net/svnroot/mychem/trunk mychem

The package contains also:
- a short documentation (mychem.docbook)
- MychemAdmin, a graphical interface for creating MySQL chemical database (fig. 1)

Figure 1. MychemAdmin, a chemical database creator