JChem, REST, and tagging

Hello,

I'd like to implement arbitrary tagging in my database using REST web services. So basically, I can assign multiple arbitrary tags to a structure, and then filter on tags when searching. For example if I tag a structure "drug" I can filter on drugs when searching.

Do you have any thoughts on accomplishing this? I could add the tags as an additional data field and then use a simpleConditions filter to do a LIKE query (this is MySQL)? This seems like it could be quite slow. Anyways, I'd appreciate any thoughts or advice on this.

Additionally, this seems like it might be a great feature to have in JChem out of the box, no?

Thanks,
Craig 

Hi Craig,

 You can only achieve this tagging with storing comma separated tag values in a column, and then using filter request something like:

"filter": {
	"conditions": {
		"tags":{"$contains":"sampleTag"}
	}
} 

And as you've mentioned, this solution has performance drawback, but unfortunately the JChem Web Services cannot handle relational data stored in other tables.

Regards,
Peter 

I'd like to implement arbitrary tagging in my database using REST web services. So basically, I can assign multiple arbitrary tags to a structure, and then filter on tags when searching. For example if I tag a structure "drug" I can filter on drugs when searching.

 

_________________________

aliiii