Currently i'm running alfresco locally using the HSQLDB
Through the webservices i run a small app that uploaded hundreds of categories that we would need for our site. (A list of all the states/counties in the us)
After the import was over i looked at the categories view and it was all there
However when i restarted my tomcat. They all disappeared initially when i went to the category view page all my categories weren't there.. then they got repopulated.
so is this information stored in the hsqldb? is it reloaded on restart of tomcat?
should i probably use mysql for my dev environment?