1. S&F Datentechnik
  2. PowerBuilder
  3. Tuesday, 14 March 2023 14:08 PM UTC

Hello,

is anyone using Azure managed databases (PaaS) with PowerBuilder or PowerServer applications?

Which database product do you use exactly?

Would love if anyone could share their experiences, use cases and opinions on suitability for production use.

Regards
Frieso

mike S Accepted Answer Pending Moderation
  1. Tuesday, 14 March 2023 14:39 PM UTC
  2. PowerBuilder
  3. # 1

yes, sql azure.   Using elastic pools, general purpose.  I have *also* tested the on-demand version, and business critical. 

 

If you open the firewall you can use PB.  we do that for some things that are NOT critical.  This is because the connection can and does drop a lot more often than in a typical client/server (not often, but it does happen).  Note that this is not secure unless you are using encryption on the database connection or if you are using an azure vpn. 

 

Powerserver is used for our main production application, sql azure elastic pools (general purpose) for the database.   Using PS 2020 AND PS 2022 (still in user testing, but expecting to fully move over in next several months).  PS 2020 is on an azure vm.  PS2022 is using a container app for the web api.

 

sql azure gives you some really really good tools.  it is slower than a dedicated sql server (unless you get business critical $$$$) , but that can be fixed with better indexing or better processes. 

 

By default sql azure does non-select blocking updates similar to how oracle has always worked.  It's a setting available for standard sql server (or maybe just enterprise).  In regular sql server, when read committed is used, a select is blocked if an update has occurred, and the transaction has not committed.  With the non blocking update setting on, the select is not blocked, instead it reads the last committed values.  this is great in some ways, but terrible if you need to prevent another process from selecting rows that you are processing within a transaction.  for that, you may need to use select for update locking, which is a table hint in sql server (oracle has better way).  I actually have a white paper that i've been working on that goes a bit more in detail on this and how to get it to work in powerserver.

 

You can use this URL to determine the best location to host from:   Azure Speed Test 2.0

 

 

 

 

 

Comment
  1. Armeen Mazda @Appeon
  2. Tuesday, 14 March 2023 16:26 PM UTC
Thanks Mike for sharing all your Azure knowledge!
  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.