#1 2014-03-12 01:53:33

azeredobr
Member
Registered: 2013-07-28
Posts: 5

Some questions about mORMot

I have a client/server application in my company, and this works with Borland Socket Server (both in Delphi 7), and I want upgrade the server to work with mORMot.

The server has a only purpose, connect with data base, because all business rules are in DB or in client (yes, its sucks, but it's my scenario).

Can I do this with mORMot?

Offline

#2 2014-03-12 08:27:06

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,604
Website

Re: Some questions about mORMot

Yes you can!
smile

As stated by the documentation, and the ReadMe.txt file, you can use only some "bricks" of the framework, without the need of using the ORM.

See "13 - StandAlone JSON SQL server" sub-folder for a rough sample of remote SQL statement execution.
Or "16 - Execute SQL via services" for a more versatile sample, using interface-based service.
As you will see in both samples, the code needed to do it is pretty tiny.
Almost everything you need is already available in the framework.

Both will allow remote execution via REST / HTTP / JSON, so it can be pretty convenient, even if you use not a Delphi client, but any REST client (including AJAX or mobile).

Offline

#3 2014-03-13 00:46:11

azeredobr
Member
Registered: 2013-07-28
Posts: 5

Re: Some questions about mORMot

Thanks!

I don't have the samle "16 - Execute SQL via services", where i can get it?
I did the download through this link: http://synopse.info/files/mORMot.7z

My idea is start with a simple server to connect with database, and later make this big with more resources.

I will increase my participation in this forum now. big_smile

Offline

#4 2014-03-13 01:32:23

moctes
Member
From: Mexico
Registered: 2013-05-11
Posts: 129

Re: Some questions about mORMot

Hi Azeredobr,

I think you already have the sample, look into :

..\mORMot\SQLite3\Samples

Regards

Offline

#5 2014-03-13 01:49:17

azeredobr
Member
Registered: 2013-07-28
Posts: 5

Re: Some questions about mORMot

No, just 1 to 15 samples and main demo.

Offline

#6 2014-03-13 03:01:34

azeredobr
Member
Registered: 2013-07-28
Posts: 5

Re: Some questions about mORMot

better description of my scenario:
Currently We have:

A Server application where occurs comunication with the database.

A client application, where connect to the server through socket, is used a lot of ClientsDataSets (connected to Server) which accepts command text, and are used to make querys and insert/updates in database, and are linked to grids and other db tools (lookups, edits, etc). All this using only native components of Delphi 7. We already have DevExpress components, but we are not using yet.

My wish:
First a simple change of server, socket comes out and enters mORMot
Second, unit by unit, migrate to ORM.

Offline

#7 2014-03-13 03:23:03

moctes
Member
From: Mexico
Registered: 2013-05-11
Posts: 129

Re: Some questions about mORMot

Don't know if you have an old version, I just downloaded the nigthly build and the samples are there :

http://synopse.info/files/mORMotNightlyBuild.zip

Check it out

Offline

#8 2014-03-13 03:33:48

azeredobr
Member
Registered: 2013-07-28
Posts: 5

Re: Some questions about mORMot

Thanks a lot!
I was in 1.17 version.

Edit: I will study more the documentation, and ask questions here.

Last edited by azeredobr (2014-03-13 03:36:03)

Offline

Board footer

Powered by FluxBB