Signed-off-by: Shawn Webb <shawn.webb@hardenedbsd.org>

Conflicts:
	libpkg/private/pkg.h (unresolved)
	tests/frontend/repo.sh (unresolved)

some views have been created long ago, lets drop them as they are not used anymore

pkg search -g editors/vim@*

While here plug a memory leak

Use sqlite native construction instead to simplify the code

Alpine provides an environment to test building against musl libc

libasan and libusan are not available on alpine so we perform a
basic configure

this is for better portability in order to avoid using a function
from libbsd

This reverts commit 0922f109.

Too early for this yet

If a package belong to multiple catagories then each category can be requested
not only the one from the origin

eg: if package name foo-bar has for origin devel/foo and as categories:
  devel bar x11
pkg install devel/foo
pkg install bar/foo
pkg install x11/foo
pkg install foo-bar

Are equivalent

Improve test suite and fix bug discovered by extending the test suite