mORMot Open Source

trinione

Member

Registered: 2016-11-23

Posts: 2

ElevateDB?

Hi:
I need to develop a Mac OSX application that connects to an ElevateDB database running on a Windows machine on a local network.

Does mORMot work with ElevateDB database engine?

igors233

Member

Registered: 2012-09-10

Posts: 241

Re: ElevateDB?

Take a look at this thread: http://synopse.info/forum/viewtopic.php?id=3455

erick

Member

Registered: 2015-09-09

Posts: 155

Re: ElevateDB?

Hi:
I need to develop a Mac OSX application that connects to an ElevateDB database running on a Windows machine on a local network.

Does mORMot work with ElevateDB database engine?

No, it does not.

erick

Member

Registered: 2015-09-09

Posts: 155

Re: ElevateDB?

Hi:
I need to develop a Mac OSX application that connects to an ElevateDB database running on a Windows machine on a local network.

Does mORMot work with ElevateDB database engine?

No, it does not.

Well, in retrospect I thought of a way you could do it.

You could use mORMot for it's SOA interface and link in ElevateDB to handle the database part.
The SOA system lets you plug in any code you want, so it could make references to EDB's code.

Hope that helps,

Erick

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,655

Website

Re: ElevateDB?

Erick is right, the ORM does not support ElevateDB yet.
But mORMot interface-based SOA is the easy and right way to create a REST server using ElevateDB.
I guess you have a lot of existing SQL code directly accessing ElevateDB, and that your ElevateDB database structure may not work well with the ORM expectations/limitations (like the availability of an integer primary key for all tables).

Everyone is welcome contributing to the project, and may propose ElevateDB support for the ORM:
- some minor changes in SynDB.pas to support dElevateDB in TSQLDBDefinition and the associated fields - then use SynDBODBC and the ODBC driver to connect to the database
- direct access via a SynDBElevateDB.pas unit, similar to the existing SynDBNexusDB.pas unit.