mORMot Open Source

Fayçal

Member

Registered: 2015-12-08

Posts: 2

Firebird direct Access

Hi ,

This my first post in the forum and i'm new with ORM and specialy with mORMot.

i search for a solution that i think mORMot is able to do it.

Client application ----------> Main Server -------------> db server ---------------------> Firebird

The "MainServer"  have requests from "clients" to post or returns a query result, the "Main server" should ask the "db Server" to make such request ( because "Main server" is make for sql query and other processing), "db Server" connect to database and execute query or return result to "Main server" the should return result to the client.

"Main Server" ,  "db Server" and Database( firebird) may not be on the same PC.

Please, what is the simplest way to implement such solution with  HTTP , JSON,  ORM  and RESTFUL approche.

Best Reagrds

cybexr

Member

Registered: 2016-09-14

Posts: 81

Re: Firebird direct Access

Sample 04 + sample 30 should fits your REQ.

igors233

Member

Registered: 2012-09-10

Posts: 241

Re: Firebird direct Access

Do you just want to pass queries to firebird from client or you need something more like do some calculations etc?
For simple passing data to DB from clients you can take a look at sample 12. Performance is very good, much better than doing it with classic FB client connecting to remote server.

Fayçal

Member

Registered: 2015-12-08

Posts: 2

Re: Firebird direct Access

Client need to query data from FB , clients are notre connecter tout FB directly, so they sends query to main server. Main server is a server that serves many things , it is not connected to FB but sends request to db server that connect to FB and do thé works. Please any suggestion for the architecture and witch kind of server to use ( http , JSON etc ...)
Regards.

Last edited by Fayçal (2017-03-22 18:24:21)

igors233

Member

Registered: 2012-09-10

Posts: 241

Re: Firebird direct Access

If you not need to add new functionality just retrieve data from DB, you can use https://synopse.info/files/html/api-1.1 … emote.html, for an example take a look at sample 12.
If you need to do some calculations on the existing data, perhaps accepts some data (orders) then you could use services. You write and expose functions that accepts some params do some processing and return results. Take a look at https://synopse.info/files/html/Synopse … ml#TITL_63 for docs and example you can find in sample 14.