go-spatial / tegola

Tegola is a Mapbox Vector Tile server written in Go
http://tegola.io/
MIT License
1.3k stars 198 forks source link

Add Spatialite as a provider? #115

Open donnyv opened 7 years ago

donnyv commented 7 years ago

Have you thought about possibly using Spatialite as a provider? Its pretty close to PostGIS.

ARolek commented 7 years ago

@donnyv we have been considering supporting Spatialite as a data provider. The main hurdle right now is the lack of a good pure Go Spatialite drive. We're trying to keep tegola pure Go so deployment and distribution are contained to a single binary + config. There is an SQLite driver which uses cgo that I believe supports loading extensions. There is also the go-spatialite package but I have not had a chance to explore it.

Have you played with either of them?

donnyv commented 7 years ago

I come from the C# world, so I didn't even think about available GO drivers. I can see how that is an issue.

I wonder if you could just use the sqlite.exe and just send commands to it? I know in C# that's pretty easy but not sure how that works in GO.

On Apr 19, 2017 1:42 PM, "Alexander Rolek" notifications@github.com wrote:

@donnyv https://github.com/donnyv we have been considering supporting Spatialite as a data provider. The main hurdle right now is the lack of a good pure Go Spatialite drive. We're trying to keep tegola pure Go so deployment and distribution are contained to a single binary + config. There is an SQLite driver https://github.com/mattn/go-sqlite3 which uses cgo that I believe supports loading extensions. There is also the go-spatialite https://github.com/shaxbee/go-spatialite package but I have not had a chance to explore it.

Have you played with either of them?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/terranodo/tegola/issues/115#issuecomment-295361956, or mute the thread https://github.com/notifications/unsubscribe-auth/ACHwPQqiPalJMXKBJQMiW9Vve56l-W5cks5rxkeggaJpZM4NA5mA .

ARolek commented 7 years ago

@donnyv well as things go, there happens to be a Go SQLite package in the works. Let's keep an eye on that project and see how it develops.