I've been getting some good results from sqlite-vec on my current project. I need to look at geospatial extensions next.