1. Sivaprakash BKR
  2. PowerBuilder
  3. Wednesday, 12 April 2023 08:18 AM UTC

Hello,

Using PB 2022, PostgreSQL

I'm migrating a client/server application to Cloud [No powerserver ].  While showing the demo to the client. client asked me what happens when there is an outage of internet ?

That client has another application (developed in .net by other vendor ), which stores the data locally during internet outage and transfer the data to cloud when internet connectivity available.   

Can this be done in PB based cloud application?  Either using Powerserver or without PS ...

Happiness Always
BKR Sivaprakash

 

mike S Accepted Answer Pending Moderation
  1. Thursday, 13 April 2023 13:34 PM UTC
  2. PowerBuilder
  3. # 1

Just use a local database server with your PB application.

the database server then syncs to your main cloud database.  Not really a powerbuilder problem then, just a data synchronization problem.  I have no idea what postgresql has for that.

Comment
  1. Sivaprakash BKR
  2. Tuesday, 18 April 2023 07:45 AM UTC
Thanks mike S,

That's what we have done already and is running successfully for the past one year. A client/server application at 2 branches, which will sync their data (replication) when internet connection is there. When connection is live, data transfer (replication) will take 2 min max.
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 12 April 2023 18:21 PM UTC
  2. PowerBuilder
  3. # 2

The client wouldn't want to spend a bunch of time and money on a solution to a non-existent problem.

They'd be better off investing in a second internet connection from a different company. Then make sure their internal network is able to handle one of them going off-line without causing too much interruption.

Comment
  1. Sivaprakash BKR
  2. Tuesday, 18 April 2023 07:50 AM UTC
Thanks Roland, Armeen.

Replication is another solution, which is running successfully.

I remember, Armeen was saying (during 2017 or so, when Appeon took over PB development) that they have an idea to introduce 'STORE & FORWARD' technology in future version of PB. I'm not sure what he meant by STORE & FORWARD and I presume that it's to solve this issue. :)

  1. Helpful
  1. Armeen Mazda @Appeon
  2. Wednesday, 19 April 2023 01:49 AM UTC
I don't remember saying store & forward back in 2017 but then again I don't remember what I ate for lunch yesterday. Anyway, no, I'm sorry this is not on our roadmap. Current roadmap is published here: https://www.appeon.com/developers/roadmap
  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 19 April 2023 14:54 PM UTC
Hi Everyone;

FWIW: I have long time customers that have been doing this Store & Forward for decades using things like ....

1) Some are using DBMS replication services

2) Some are using the SQLAnyWhere "MobiLink" product.

3) Some are using PB's "PipeLine" object class.

4) Some are using 3rd party software. etc

HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 12 April 2023 16:26 PM UTC
  2. PowerBuilder
  3. # 3

Hi BKR;

  FWIW: Most Cloud Providers provide automatic fail-over features that you can investigate to see which one works best for your application(s).

Regards ... Chris

Comment
  1. mike S
  2. Wednesday, 12 April 2023 17:46 PM UTC
I believe he is saying he wants to be able to handle when the network itself is out. like a cable is cut.
  1. Helpful 1
  1. Sivaprakash BKR
  2. Thursday, 13 April 2023 05:07 AM UTC
Yes, Mike s. Here there won't be internet connectivity which can last from few minutes to few hours.
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.