fold the last round of sql manager changes back into the core and use it for the central db and simplify the algorithm