Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Database application questions


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 10 - Last Post: Sep 3, 2015 9:17 AM Last Post By: David Keith
Erick Engelke

Posts: 101
Registered: 12/5/02
Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 1, 2015 7:24 PM
Hi,

I've written a gazillion delphi apps for multiple platforms f from Scientific, to device drivers, etc, but I'm starting my first app where I want to make a multi-tier database app in Delphi, so I'm looking for some advice.

For security reasons, I'd like to implement the database application logic in a server so that clients can't access the data directly. My database server will be either PostgreSQL or MySql - I don't know which will be given to me.

My questions are:

Which delphi version should I upgrade to (I've got professional version right now)

What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.

Are there any books you'd recommend which cover this.

I've done similar in HTML5 Builder (hope to have my book on it completed soon), and I know you can leverage the technologies to minimize coding, that's my goal.

Thanks for any suggesitons you can give.

Erick

--
Erick Engelke
Director, Engineering Computing
University of Waterloo

Arnaud Bouchez

Posts: 137
Registered: 8/2/15
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 8:21 AM   in response to: Erick Engelke in response to: Erick Engelke
So you want to switch to a n-Tier SOA application.
Good idea.

Ensure you check out our Open Source http://mormot.net framework.
It has all bricks needed to create powerful SOA applications, consumed via REST by desktop/mobile/AJAX clients.
The benefit of using an ORM/ODM as the one included in mORMot is that:
- data is directly interfaced as REST (no need to write the services by hand, the data is exposed directly)
- you can switch from one DB to another (SQlite3, MySQL, PostgreSQL and even MongoDB), just by one line
- all is integrated (e.g. logging, security, performance, MVC) so you could
- you could use your existing version of Delphi, with no need to buy the Enterprise/FireDAC editions
- you could propose your own patches, which would be included in the main trunk, to fit your purposes

But it may take a while to switch from a RAD perspective to a SOA approach.
A lot of C# and Java coders do know about J2EE or WCF, but, as a Delphier, you may be lost at first.
Do not be afraid, just try the samples, and check out the (exhaustive) documentation.
erick engelke

Posts: 4
Registered: 3/8/02
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 3:51 PM   in response to: Arnaud Bouchez in response to: Arnaud Bouchez
Wow, three really good options in just a few hours of my post. Thanks everyone for your comments. I think this one sounds most interesting being open source. I've read many slides on it and think it will fit the bill. I'm using the latest Delphi Pro, so I should be fine.

Erick

Arnaud Bouchez wrote:
So you want to switch to a n-Tier SOA application.
Good idea.

Ensure you check out our Open Source http://mormot.net framework.
It has all bricks needed to create powerful SOA applications, consumed via REST by desktop/mobile/AJAX clients.
The benefit of using an ORM/ODM as the one included in mORMot is that:
- data is directly interfaced as REST (no need to write the services by hand, the data is exposed directly)
- you can switch from one DB to another (SQlite3, MySQL, PostgreSQL and even MongoDB), just by one line
- all is integrated (e.g. logging, security, performance, MVC) so you could
- you could use your existing version of Delphi, with no need to buy the Enterprise/FireDAC editions
- you could propose your own patches, which would be included in the main trunk, to fit your purposes

But it may take a while to switch from a RAD perspective to a SOA approach.
A lot of C# and Java coders do know about J2EE or WCF, but, as a Delphier, you may be lost at first.
Do not be afraid, just try the samples, and check out the (exhaustive) documentation.
David Keith

Posts: 196
Registered: 12/10/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 10:39 AM   in response to: Erick Engelke in response to: Erick Engelke
On 9/1/2015 22:24, N/A Programmer wrote:
My questions are:

Which delphi version should I upgrade to (I've got professional version right now)
If you use 3rd party Multi-Tier components Delphi pro will work just
fine. Best that you upgrade to a current version, like XE7 or later.
What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.
RemObjectsSDK is the undisputed leader in this field, although there are
several good ones. ROSDK is the most comprehensive, covering windows,
linux, mac, phones, javascript etc.

http://www.remobjects.com/ro/

Are there any books you'd recommend which cover this.
Don't know of any, although RemObjects has good documentation, tons of
examples online, great forum support and a broad user base, as well as
some videos. RO is very responsive to user support issues.


Erick
HTH
Kim Madsen

Posts: 362
Registered: 12/13/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 3:07 PM   in response to: David Keith in response to: David Keith
Hi,

I would suggest you to consider kbmMW Professional or Enterprise Edition.
It gives you the most feature complete REST functionality available for
Delphi and it is only a fraction of the features of kbmMW.

Check https://goo.gl/r94uYs to see a number of articles explaining some
areas of kbmMW.

Check also http://www.components4developers.com for more info.

best regards
Kim/C4D

Den 9/2/2015 kl. 19:39 skrev David Keith:
On 9/1/2015 22:24, N/A Programmer wrote:
My questions are:

Which delphi version should I upgrade to (I've got professional version right now)
If you use 3rd party Multi-Tier components Delphi pro will work just
fine. Best that you upgrade to a current version, like XE7 or later.
What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.
RemObjectsSDK is the undisputed leader in this field, although there are
several good ones. ROSDK is the most comprehensive, covering windows,
linux, mac, phones, javascript etc.

http://www.remobjects.com/ro/

Are there any books you'd recommend which cover this.
Don't know of any, although RemObjects has good documentation, tons of
examples online, great forum support and a broad user base, as well as
some videos. RO is very responsive to user support issues.


Erick
HTH
Kim Madsen

Posts: 362
Registered: 12/13/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 3:07 PM   in response to: Kim Madsen in response to: Kim Madsen
Sorry, was meant as an answer to the OP, not to you David.

best regards
Kim/C4D

Den 9/3/2015 kl. 00:07 skrev Kim Madsen:
Hi,

I would suggest you to consider kbmMW Professional or Enterprise Edition.
It gives you the most feature complete REST functionality available for
Delphi and it is only a fraction of the features of kbmMW.

Check https://goo.gl/r94uYs to see a number of articles explaining some
areas of kbmMW.

Check also http://www.components4developers.com for more info.

best regards
Kim/C4D

Den 9/2/2015 kl. 19:39 skrev David Keith:
On 9/1/2015 22:24, N/A Programmer wrote:
My questions are:

Which delphi version should I upgrade to (I've got professional version right now)
If you use 3rd party Multi-Tier components Delphi pro will work just
fine. Best that you upgrade to a current version, like XE7 or later.
What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.
RemObjectsSDK is the undisputed leader in this field, although there are
several good ones. ROSDK is the most comprehensive, covering windows,
linux, mac, phones, javascript etc.

http://www.remobjects.com/ro/

Are there any books you'd recommend which cover this.
Don't know of any, although RemObjects has good documentation, tons of
examples online, great forum support and a broad user base, as well as
some videos. RO is very responsive to user support issues.


Erick
HTH
David Keith

Posts: 196
Registered: 12/10/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 3:41 PM   in response to: Kim Madsen in response to: Kim Madsen
On 9/2/2015 18:07, Kim Madsen wrote:
Sorry, was meant as an answer to the OP, not to you David.

best regards
Kim/C4D

Den 9/3/2015 kl. 00:07 skrev Kim Madsen:
Hi,

I would suggest you to consider kbmMW Professional or Enterprise Edition.
It gives you the most feature complete REST functionality available for
Delphi and it is only a fraction of the features of kbmMW.

Check https://goo.gl/r94uYs to see a number of articles explaining some
areas of kbmMW.

Check also http://www.components4developers.com for more info.

best regards
Kim/C4D

Den 9/2/2015 kl. 19:39 skrev David Keith:
On 9/1/2015 22:24, N/A Programmer wrote:
My questions are:

Which delphi version should I upgrade to (I've got professional version right now)
If you use 3rd party Multi-Tier components Delphi pro will work just
fine. Best that you upgrade to a current version, like XE7 or later.
What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.
RemObjectsSDK is the undisputed leader in this field, although there are
several good ones. ROSDK is the most comprehensive, covering windows,
linux, mac, phones, javascript etc.

http://www.remobjects.com/ro/
Are there any books you'd recommend which cover this.
Don't know of any, although RemObjects has good documentation, tons of
examples online, great forum support and a broad user base, as well as
some videos. RO is very responsive to user support issues.

Erick
HTH
I figured as much. No prob.
David Keith

Posts: 196
Registered: 12/10/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 3:50 PM   in response to: Kim Madsen in response to: Kim Madsen
On 9/2/2015 18:07, Kim Madsen wrote:
Hi,

I would suggest you to consider kbmMW Professional or Enterprise Edition.
It gives you the most feature complete REST functionality available for
Delphi and it is only a fraction of the features of kbmMW.

Check https://goo.gl/r94uYs to see a number of articles explaining some
areas of kbmMW.

Check also http://www.components4developers.com for more info.

best regards
Kim/C4D

Is kbmMW supporting the Mac now? And phones? From Op:

'I will want clients to be mobile as well as Win/Mac'

Is this something you support on the... XML/JSON level? How do you provide support for Mac clients?
Kim Madsen

Posts: 362
Registered: 12/13/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 2, 2015 11:56 PM   in response to: David Keith in response to: David Keith
Den 9/3/2015 kl. 00:50 skrev David Keith:
On 9/2/2015 18:07, Kim Madsen wrote:
Hi,

I would suggest you to consider kbmMW Professional or Enterprise Edition.
It gives you the most feature complete REST functionality available for
Delphi and it is only a fraction of the features of kbmMW.

Check https://goo.gl/r94uYs to see a number of articles explaining some
areas of kbmMW.

Check also http://www.components4developers.com for more info.

best regards
Kim/C4D

Is kbmMW supporting the Mac now? And phones? From Op:

'I will want clients to be mobile as well as Win/Mac'

Is this something you support on the... XML/JSON level? How do you provide support for Mac clients?

Hi,

Yes kbmMW supports OSX, Android and IOS directly, full featured via
natively compiled clients, even server side.

In addition kbmMW have extensive support for XML and JSON also via REST.

best regards
Kim/C4D
erick engelke

Posts: 4
Registered: 3/8/02
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 3, 2015 6:17 AM   in response to: David Keith in response to: David Keith
I spent the night researching and like what I saw. I will try this on a small project first to get my feet wet..

My new problem is that I don't see anywhere to select this as the answer I chose on the forum.

David Keith wrote:
On 9/1/2015 22:24, N/A Programmer wrote:
My questions are:

Which delphi version should I upgrade to (I've got professional version right now)
If you use 3rd party Multi-Tier components Delphi pro will work just
fine. Best that you upgrade to a current version, like XE7 or later.
What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.
RemObjectsSDK is the undisputed leader in this field, although there are
several good ones. ROSDK is the most comprehensive, covering windows,
linux, mac, phones, javascript etc.

http://www.remobjects.com/ro/

Are there any books you'd recommend which cover this.
Don't know of any, although RemObjects has good documentation, tons of
examples online, great forum support and a broad user base, as well as
some videos. RO is very responsive to user support issues.


Erick
HTH
David Keith

Posts: 196
Registered: 12/10/99
Re: Database application questions  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 3, 2015 9:17 AM   in response to: erick engelke in response to: erick engelke
On 9/3/2015 09:17, erick engelke wrote:
I spent the night researching and like what I saw. I will try this on a small project first to get my feet wet..

My new problem is that I don't see anywhere to select this as the answer I chose on the forum.

David Keith wrote:
On 9/1/2015 22:24, N/A Programmer wrote:
My questions are:

Which delphi version should I upgrade to (I've got professional version right now)
If you use 3rd party Multi-Tier components Delphi pro will work just
fine. Best that you upgrade to a current version, like XE7 or later.
What technology should I be using - I will want clients to be mobile as well as Win/Mac. I would like it to be REST if possible, what 'name' does Delphi give to that? I've heard of Midas way back.
RemObjectsSDK is the undisputed leader in this field, although there are
several good ones. ROSDK is the most comprehensive, covering windows,
linux, mac, phones, javascript etc.

http://www.remobjects.com/ro/
Are there any books you'd recommend which cover this.
Don't know of any, although RemObjects has good documentation, tons of
examples online, great forum support and a broad user base, as well as
some videos. RO is very responsive to user support issues.

Erick
HTH
Selecting an answer isn't required on this forum. Just use the info that
has been freely supplied to your benefit.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02