work on base conversion, postgres dependency, shorten view