Adapter overhaul

add update capability postgres adapter
overhaul memory adapter
add tests
add persistance management (save only if dirty or not persisted)