Hi,
I don't know what you mean by overlaid the SQLite package. The SQLite package has everything it needs you don't need to overlay over anything.
The most likely cause for links not working is you don't have the correct setting for SubSonicProvider in your Web.config file.
If working with the source code, set the referecne from mojoPortal.Business to mojoPortal.Data.SQLite and remove the reference to mojoPortal.Data.MSSQL, build the solution, then visit /Setup/Default.aspx and it will install it.
You add the new "Image Gallery (Simple Folder version)" to a page just like any other feature. It is included in all the packages including the SQLite package.
Hope it helps,
Joe