1. Sivaprakash BKR
  2. PowerBuilder
  3. Wednesday, 19 June 2019

Hello,

Using Powerbuilder 2017 R3 / 2019 with Postgresql database

Need to access data from a local [ intranet ] server, from a mobile application.   Mobile apps is to read barcode, fetch relevant data from the database, show it, print it and save the entered data again to the database.  Database resides in the local intranet server, which could be accessed through wifi.   Mobile application could be used by atmost 10 users.

What solution available for this ?   

This is going to be developed afresh.  

Happiness Always
BKR Sivaprakash

 

Govinda Lopez Accepted Answer Pending Moderation
0
Votes
Undo

Hi Sivaprakash,

 

You can use PowerServer 2017 R3 or PowerServer 2019. Both versions support PostgreSQL databases (see here). You could install your PowerServer on a computer that connects to your intranet and deploy the applications from there. That way your devices will have the DB connection available.

 

Another option is that you can use the new C# Web API features of PowerBuilder/PowerServer 2019. You would create a Web API in a server that connects to the local intranet and have your app use that Web API.

 

We have a lot of online resources available for you to learn how to do it on both scenarios. You may find more info at https://www.appeon.com. Or you can go directly to the Product Manuals website where you can also find tutorials.

 

I hope this helps.

 

Regards,

Comment
Thanks Mariano,

I'll contact Sales Department. Would like to spell out here too that I'm an ISV and owning Powerbuilder Universal licenses. And none of my customers own any PB licenses. Would like to know what solutions available for mobile apps developed using PB that my small sized customers need not invest on license.



So a solution without Powerserver will fit these clients.

  1. Sivaprakash BKR
  2. Thursday, 20 June 2019
Hi Sivaprakash,

PowerServer must be installed on the server where your mobile applications will be hosted. Of course, a PowerServer license is required for this. There is a number of PowerServer editions, each with different capabilities and pricing, the sales team can help you compare editions to see which one is right for the project.



The 2nd approach would be the Web API approach Govinda mentioned earlier. PowerBuilder 2019 Cloud or Universal Edition includes new C# features aimed at allowing developers to take their existing business logic in PowerBuilder (DataStores), and port it over to C#, to publish the business logic as .NET Web API's that can then be consumed by either a PowerBuilder client or any other platform capable of consuming .NET Web API's. In essence, you could develop a mobile front end in a different platform and have it consume your business logic through web API's that were developed in PB and ported to C#.
  1. Mariano Collado
  2. Friday, 21 June 2019
Thanks Mariano Collado,

That's what I'm thinking. To develop mobile apps using some other language that will consume .NET Web API's. Hope Appeon will soon think and work for small clients too.
  1. Sivaprakash BKR
  2. Saturday, 22 June 2019
There are no comments made yet.
  1. Wednesday, 19 June 2019
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.