revert db loads
re-activate db lookups, fix public collections app
fix broken specs
ignore case in app sorting
fix submission js
ui tweaks