#1 2021-05-17 20:25:37

wxinix
Member
Registered: 2020-09-07
Posts: 121

mORMot and Spatial Database

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

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

Offline

#2 2021-05-17 21:06:35

mpv
Member
From: Ukraine
Registered: 2012-03-24
Posts: 1,299
Website

Re: mORMot and Spatial Database

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

Offline

#3 2021-05-17 22:35:31

wxinix
Member
Registered: 2020-09-07
Posts: 121

Re: mORMot and Spatial Database

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?

Offline

#4 2021-05-18 01:18:01

Junior/RO
Member
Registered: 2011-05-13
Posts: 201

Re: mORMot and Spatial Database

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

Offline

#5 2021-05-18 10:32:05

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 13,191
Website

Re: mORMot and Spatial Database

Also RTree are available at ORM level.

Offline

#6 2021-05-20 12:33:04

wxinix
Member
Registered: 2020-09-07
Posts: 121

Re: mORMot and Spatial Database

ab wrote:

Also RTree are available at ORM level.

@ab
Thank you.  I am looking at spatialite  https://www.gaia-gis.it/fossil/libspatialite/index

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

Offline

Board footer

Powered by FluxBB