Support for Spatial Database?

BIZ TMS Aurelius
1

Is there a way to use Aurelius to work with Spatial Database?

I found this old article Problem with the entities generated by TAureliusConnection for the geometry column of Postgres

But still wonder if anyone has been successful in using Auerlius with Spatial Database? Or any advice.

2

Hi,

Currently I'm developing a Web application where I will use TMS Web Core accessing a PostgreSQL database (with the PostGIS extensions installed). The backend will be hosted on Linux (Ubuntu Server) in docker containers. There I'm using the free version of Dreamfactory from Bitnami to create the Rest interfaces, also running in the docker containers.

Already achieved:

  • Oracle Virtual Box running Ubuntu Server with docker in installed and the required ports opened.
  • Dreamfactory, Apache and Postgres running in docker
  • Logical replication to Postgres in docker container, although Bitnami assured me that is not possible and they won't change their Postgres image to provide for it.
  • First successful calls to Rest interfaces of my database in the docker container.
    Now as you know, you can do many things in SQL which is not directly possible using Rest API calls. The way to overcome this is to create database functions which contain your specialised SQL, including spatial operations (CRUD operations).

Currently I'm busy creating a few very dynamic Postgres functions which will contain advanced SQL regarding the lookup tables to create a "zoom" effect to the data when a user starts to search for records. I will also create a few functions for spatial queries and updates (using the ST_ functions of Postgres in the SQL). I gained solid experience regarding spatial CRUD operations using Postgres in a Windows desktop application to process seismic data.

Your own homebrew functions are typically called with parameters and the output is a table

for example:

image.png

In Web Core I typically feed the output from the Rest calls into an Object Dictionary List and use it from thereon.

I had a hard look at TMS Business, including Aurelius, and decided you just create a lot of mud. I'm also busy learning Google's Flutter and Dart and I may move away from Delphi and TMS Web Core in the future.

My requirement is to create web applications that can run on a Raspberry Pi up to cloud servers.

Regards,

Nols Smit

2 Likes