Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

General Discussion

Konstantinos Sfikas
Konstantinos Sfikas
5,877 Points

making a diagram using database objects?

Hello everyone! I am kind of new to web-design/development, and I am currently working on making my first template for wordpress. I have an idea about a website that would be able to display species of animals and their ancestors in a hierarchical way and in a relational dependency. It is kind of vague at the moment, however I was lloking for some help on how I could approach this matter... As a reference, one could take a look at this wikipedia article on how life is categorized hierarchically by biologists http://en.wikipedia.org/wiki/Taxonomic_rank (Life > Domain > Kingdom > Phylum > Class > Order > Family > Genus > Species and so on...). The first specific part of the question is if it would make sense to use custom post types in wordpress to organize such a database of relations between animals, for example... The second part is if I could display those objects in a smart way (something like a diagram) instead of just presenting them one below the other as a usual blog-type presentation, and what approach could one take to do such a thing.

Thanks in advance, any comment/help appreciated.

5 Answers

Stone Preston
Stone Preston
42,016 Points

I like using Lucidcharts for creating database/ER diagrams

Konstantinos Sfikas
Konstantinos Sfikas
5,877 Points

Thank you for the suggestion! Although I did not yet take a good look at it, it seems like a tool to make diagrams in general. I was wondering if there was a similar tool that could work as a plugin n wordpress and perhaps make the diagrams automatically (and interactively) using my wordpress database... (I hope this makes sense)

Konstantinos Sfikas
Konstantinos Sfikas
5,877 Points

To make the example more clear, suppose that I have made a database of ape-species and their ancestors and someone was searching my database using the keyword "homo erectus". Then the diagram would zoom in on Homo erectus but also show the connection with homo sapiens and australopithecus. (as shown in that image...) http://cdn3.dogomedia.com/pictures/1649/content/imaginative.gif?1285694779 or even allow the user to navigate the diagram by zooming in and out and scrolling aroud, but also being able to click on one of the species and receive more information... So in the backend I would have a database of "objects", (every single species is one of them) and connections between them. For example the attribute "immediate ancestor" of the object "homo erectus" would be "australopithecus". And then this "imaginary plugin" would take this information and make the diagram for me... It is not that complicated to consider, but it might be out of the capabilities of what can be done with wordpress, that's my main concern and question.

Konstantinos Sfikas
Konstantinos Sfikas
5,877 Points

I also hope that this does not lead to a debate between "creationists" and "evolutionists". :)

Konstantinos Sfikas
Konstantinos Sfikas
5,877 Points

hm... perhaps it is a complicated question.... I will try to break it down into smaller parts. If, however, there was any suggestion I would appreciate it.