updated get_locs test, changed to a unique query, only keep_alive for mysql (since sqlite doesn't support it)
switch from sqlite to mysql