[Rdkit-discuss] mysql,frowns --> rdkit

[<Pau...@me...>]

Dear folks,

I have some old code which I would like to convert smoothly to rdkit.
I have set-up a MySQL database of molecules given MOL2 and SMILES. The
substructure search happens via frowns:
"
db_smiles = db.do('SELECT ligand_id, smiles FROM ligands;')

ligand_ids = []
for db_smile in db_smiles:
	try:
		db_can_smiles = Smiles.smilin(db_smile[1]).cansmiles()
		match = pattern.match(Smiles.smilin(db_can_smiles))
		if match != None:
			ligand_ids.append(db_smile[0])
		except:
			pass #print "Warning: failed for to recognize \"%s\"
SMILES string<br>\n" %db_smile[1]


return ligand_ids
"

Do I necessarily need to convert MySQL to PostgreSQL? A quick google search
shows me that this should be feasible, but I have never done it so far.

Or can I just replace the frowns SMILES search by the RDkit SMILES search?


Cheers & Thanks,
Paul

This message and any attachment are confidential and may be privileged or
otherwise protected from disclosure. If you are not the intended recipient,
you must not copy this message or attachment or disclose the contents to
any other person. If you have received this transmission in error, please
notify the sender immediately and delete the message and any attachment
from your system. Merck KGaA, Darmstadt, Germany and any of its
subsidiaries do not accept liability for any omissions or errors in this
message which may arise as a result of E-Mail-transmission or for damages
resulting from any unauthorized changes of the content of this message and
any attachment thereto. Merck KGaA, Darmstadt, Germany and any of its
subsidiaries do not guarantee that this message is free of viruses and does
not accept liability for any damages caused by any virus transmitted
therewith.

Click http://disclaimer.merck.de to access the German, French, Spanish and
Portuguese versions of this disclaimer.