updated TODO
upstream patches
Makefile refactored
fixed renamed parameter
sql shorthand functions simplified and inlined
refactored sqlite compatibility functions