~mil/mobroute-tickets#52: 
Mobroute: Remove usage of go function bindings from sqlite driver

Currently MR's routing API utilizes the functionality of the go-sqlite3 package that allows binding go functions from sqlite.

https://pkg.go.dev/github.com/mattn/go-sqlite3#hdr-Go_SQlite3_Extensions

Using this makes things less portable (as this is only a feature of this one specific sqlite go driver) & more difficult to debug (as certain queries can't just be 'dropped into' sqlite's CLI).

This ticket is to remove these usages:

  • ext_haversinedistkm: Easy enough to replace, only used by stopwalks
  • ext_timezonetoutcdeltasecs: Added with 0.5, should be replaceable by just querying out to get timezone UTC deltas (per day), we have tests shouldnt be too bad to debug

Making this change will also allow potentially switching to use other implementations of the sqlite driver (e.g. such as go / cgo-less version) which would be helpful in debugging issues specific to mattn/go-sqlite3.

Status
REPORTED
Submitter
~mil
Assigned to
No-one
Submitted
a month ago
Updated
a month ago
Labels
m5:integrations mobroute release:0.6