PrebChemDB v0.2 - small update

Hi there! It was a pleasure presenting the database at AbsSciCon. I learned a lot and was thrilled to see the interest and support from the audience, which I deeply appreciate.

In the following months, I plan to devote weekly time to improving the database. To begin with, I decided to attack on of the biggest issues. Most people would agree that the website is painfully slow. Therefore, I spent some time this week trying to find the limiting factor on load time.

It turned out that the queries that I was doing in the Neo4J backend were very inefficient: first, I was obtaining too much information that I was not using, and second, I was making too many simple queries from the Python backend instead of making a single query to the Neo4J instance. I solved the issue by changing the Cypher query to obtain only the information I needed on a single query, reducing query times from 10s to 1s. You will appreciate the difference. As I've told some people during AbSciCon, I'm learning on the go; hopefully, I will be able to either hire or collaborate with some database experts.

Apart from that, I've added a survey where I will start collecting emails and feedback. Your insights are crucial for the future of this project, and I would highly appreciate it if you could take 2 minutes to complete it!

Finally, I want to address one of the points that might be puzzling you: if this database is open-source and community-based, where are the data and the code? Well, it's coming soon. I am working on tutorials, an annotation app, and documenting the code, which I will hopefully release in the following weeks

Best Bruno