app stuff only, still working post-gre sql configuration
tests for the 4.1 motivation