SQLite PubChem database #1
Description
SQLite vs MySQL
I have been storing the inchi keys of PubChem in a SQlite database, this should contain the majority of compounds in PubChem and is used to extract inchi keys from PubChem compound ids (cid).
However, I think the SQLite database is better if it is integrated fully into the Django database. Before this is done however, performance should be assessed as this will drastically increase the number of Compounds within the database and as the uid is an inchikey I am not sure how indexing will be affected.
Updated details
When creating the SQLite database the parsing tool I used failed for some non normal mol files. As such some compounds are missing. This needs to be repeated but it takes a long time to run due to number of PubChem cmpounds