mORMot and Spatial Database

wxinix · 2021-05-17 20:25:37

May be this is an out-of-touch question:

can mORMot work with Spatial Database, like PostgreSQL/PostGIS?

mpv · 2021-05-17 21:06:35

PostGIS is a Postgres extension, so the same protocol is used between DB and clients, and on SynDB level it works

wxinix · 2021-05-17 22:35:31

mpv wrote:

PostGIS is a Postgres extension, so the same protocol is used between DB and clients, and on SynDB level it works

Thank you, but at ORM level, what data type should I use for Geometry type? Blob?

Junior/RO · 2021-05-18 01:18:01

mORMot can work with SQLite3 RTree extension. See the docs.

ab · 2021-05-18 10:32:05

Also RTree are available at ORM level.

wxinix · 2021-05-20 12:33:04

ab wrote:

Also RTree are available at ORM level.

Do you see any problem that using mORMot2 + spatialite (as SQLite extension)? Advice?

mORMot Open Source