finished static test examples and converted to postgres

Signed-off-by: Chris Jones <chris@jonezy.org>