• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Best options for true web applications from PB apps

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved Best options for true web applications from PB apps

  1. How-to
1
Votes
Undo
  1. Daniel Vivier
    Daniel Vivier
  2. PowerBuilder
  3. Saturday, 6 August 2022 19:17 PM UTC

If we want to create true web application versions of our client/server PB applications, and maintain both versions, what do users recommend as the best technological options?

Obviously it's not PowerServer, because it's not really a web application, and runs only on Windows. We want something you can run from any O/S.

Ideally it would be able to share some code with our installed client/server applications, to avoid a complete re-write.

I'm aware of TopwizWeb but haven't heard any user feedback on its use for significant-sized applications. 

I know that the web DW is discontinued so that doesn't seem to be an option.

I also know there are 3rd-party converters (such as mobilize.net) from PB apps to web technologies, but obviously then you end up with something completely disconnected from your original PB code and you have to maintain two entirely separate code lines, if you want to maintain both versions.

Just building something with modern web technologies from scratch, i.e. a complete re-write of the functionality, seems prohibitively difficult and error-prone.

What are your thoughts? Thanks. 

  1. PowerBuilder (Appeon)
OLE connection to MS Outlook
Themes - Long database query screen goes blank
Responses (5)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Sunday, 7 August 2022 01:41 AM UTC
  2. PowerBuilder
  3. # 1

One option to consider is migrating your PB business logic into C# Web API layer using PowerScript Migrator.  PowerScript Migrator included with PB CloudPro subscription.  You would need to manually to develop the HTML UI... there is no automatic conversion of that.

Comment
Daniel Vivier
  1. Daniel Vivier
  2. Monday, 8 August 2022 19:52 PM UTC
My concern about that, Armeen, is like what Miguel said - it's no help with the front end, plus as soon as you have done the conversions, the C# code is disassociated with the original PB code (DWs and PowerScript). So if you are trying to maintain both versions (PB and web application) with similar functionality you are still maintaining 2 related but different-language code bases all of the time. Double the effort, and error prone.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 8 August 2022 22:34 PM UTC
I understand. Only solution I am aware of to maintain one set of code for both client/server and Cloud/Internet app is PowerServer or do the remote desktop workaround that you mentioned.
  1. Helpful
Carl Bolduc
  1. Carl Bolduc
  2. Friday, 14 July 2023 19:30 PM UTC
Late to the party but you can modify the PB app to use a rest client and call the REST api, just like the new web client that you want to build. The process is described here:

https://docs.appeon.com/powerscriptmigrator2022/PB_to_CSharp_Porting_Business_Logics_with_Minimum_Refactoring_Hassle/index.html#call-the-web-api-from-powerbuilder

By doing this, you would have two clients to maintain (PB and HTML/JS) and a single API that takes care of the business logic.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Sunday, 7 August 2022 11:37 AM UTC
  2. PowerBuilder
  3. # 2

Hi Dan,

In my opinion, "migrating you business logic to C#" might be a nice start, but there might be a lot of dependencies with dw columns being visible or not (for example) and other attributes of a visual datawindow. I'm not so sure how difficult it would be. Then there's the other thing of still having to pay licences to Appeon.

Personally I would indeed start from scratch or not start at all, but that's just my opinion on not having seen a lot of success yet of companies doing similar stuff, migrating big applications (unless using powerserver !!).

regards,

MiguelL

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Sunday, 7 August 2022 15:21 PM UTC
  2. PowerBuilder
  3. # 3

you should still consider starting with powerserver deployment.  Yes it is windows only, but it is a cloud application.  Most of the techniques for managing your customers's data and deployment of the application is the same.  The server setups will be similar too.

You only really lose out to customers on MAC who refuse to run a windows emulator, and those on tablets that don't want a windows tablet.  

 

you can start to migrate the code to web services and call it from PB/PS, and it will also be available for your future web/html applications to use.

 

Comment
Daniel Vivier
  1. Daniel Vivier
  2. Sunday, 7 August 2022 15:31 PM UTC
Mike we already have a perfectly good option that has the advantages of PowerServer, AND works on Macs, which is a remote-control solution using Graphon (same sort of idea as Terminal Server or Citrix). The next thing, if we do it, has to be a true web app.
  1. Helpful 2
There are no comments made yet.
Daniel Vivier
Daniel Vivier Accepted Answer Pending Moderation
  1. Monday, 8 August 2022 19:58 PM UTC
  2. PowerBuilder
  3. # 4

TopWiz Software's TopWizWeb, which allows you to call into PB code directly from your HTML, with "TopWizWeb Server Pages", sounds like something appealing to try out. Haven't done so yet but likely will.

I should also mention that as I understand it, the PB C# stuff states that only limited DBMSs are supported using ODBC, and that does not include Firebird SQL, which is what we use, and are very happy with. Any other ODBC datasources are "use at your own risk, not supported". Back when we were considering trying out PowerServer a few years ago we tried ports to get our existing code working with both MySQL and PostgreSQL and ran into significant difficulties with both of them. And that would be yet another case where we consistently maintain aspects of 2 code bases if we weren't using Firebird for the web app version.

Comment
Load more comments
Mark Goldsmith
  1. Mark Goldsmith
  2. Thursday, 11 August 2022 12:04 PM UTC
Thanks very much for your feedback!
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Monday, 17 July 2023 15:16 PM UTC
I have B4A installed. I played around with it a couple years ago. I had created a simple app that made webservice calls to populate dropdowns. B4A can be used for free but I am pretty sure there is a paid support option if your company needs that.
  1. Helpful
Mark Goldsmith
  1. Mark Goldsmith
  2. Monday, 17 July 2023 21:11 PM UTC
Thanks Roland for the input. Since I first inquired on this a year ago I had to set it aside due to other priorities. My hope is to pick it up again within the next couple of months.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Saturday, 15 July 2023 05:02 AM UTC
  2. PowerBuilder
  3. # 5

If you don't want to maintain 2 different versions: client/server and another using html. Simply forget about the client/server. The html frontend will run anywhere.

regards

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Saturday, 15 July 2023 13:18 PM UTC
Hi Miguel ... yes - native, web & mobile. ;-)
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Monday, 17 July 2023 07:39 AM UTC
... forget Powerbuilder. It doesn't have that feature.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


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