Some questions about mORMot

azeredobr · 2014-03-12 01:53:33

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?

ab · 2014-03-12 08:27:06

Yes you can!

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).

azeredobr · 2014-03-13 00:46:11

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.

moctes · 2014-03-13 01:32:23

Hi Azeredobr,

I think you already have the sample, look into :

..\mORMot\SQLite3\Samples

Regards

azeredobr · 2014-03-13 01:49:17

No, just 1 to 15 samples and main demo.

azeredobr · 2014-03-13 03:01:34

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.

moctes · 2014-03-13 03:23:03

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

azeredobr · 2014-03-13 03:33:48

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)

mORMot Open Source

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

Some questions about mORMot

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

Re: Some questions about mORMot

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

Re: Some questions about mORMot

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

Re: Some questions about mORMot

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

Re: Some questions about mORMot

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

Re: Some questions about mORMot

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

Re: Some questions about mORMot

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

Re: Some questions about mORMot

Board footer