What is the best way to upgrade

Startbeitrag von Sam Asid am 24.03.2015 06:18

Hello All,

I do appreciate all the help with my latest issue with sending email in version 12.

I have been considering upgrading from 12 to 20. A few questions on my mind now I thought I could do with some help.

1, What is the best (speed and ease of use) database to use for webdev? (I am considering mariadb, HFSQL or mysql)

2. How useful will be my version 12 code when I need to take my existing work onto webdev 20?

3. Should I start with 19 and upgrade to 20 as promised by pcsoft? Are there usually an upgrade issues since 20 will be relatively new in terms of tested functionality.

4. How many dongles will I get for purchasing all three variants?

Thanks in advance.



Hi Sam,

1 - best of all is to use PC Soft's own database, HFSQL.

2 - You can move most of your existing WinDev 12 code to WinDev version 20 by just opening the project from the WinDev 20 IDE. Warning messages will be issued for outdated (but mostly still supported) commands. WebDev is a very different case, the strategy of using WebDev differs from WinDev a lot! However, W-Language is still there, most of your existing WinDev code will be usable, but sometimes in different ways and different places. Keep iun mind, there's Server code and Client code.

3 - Version 20 is already here. If you buy a new bundle of WinDev, WebDev and WinDev Mobile then you will receive version 20. Anyway, the dongles of v20 will enable you to work with all versions from 5.5 upwards.

4 - 3 dongles for the three products.

von GuenterP - am 24.03.2015 10:05
Hi Sam,

In response:

1) I use HFSQL and find it fast and reliable. I know a lot of people use MySQL and I'll let them respond as I don't have experience of using it with WD. One big difference is that HFSQL has a utility to automatically apply database structure changes, but with MySQL I understand you have to handle it yourself.

2) Your code will be the same. This (for me) is one of the great things about WX products, PCS try to keep the code as backwardly compatible as possible. The only issues I've had when upgrading are minor; things like some SQL statements needing to be tweaked due to some changes made by PCS making HFSQL more ANSI compliant.

3) You're already considering an upgrade from 12 so I would guess that going to 19 or 20 wouldn't make much difference.

4) You will retain any dongles you already have and perform an upgrade on the dongle's firmware. You will receive a new dongle with any new licences you purchase.


von DarrenF - am 24.03.2015 10:08
Hi Sam,
there is an important issue when you upgrade to v19 (or 20), if you are supporting NON-Western European Languages in your apps...
You will have to switch to the unicode format (Project and Analysis).
There is a little switch for both (in the current configurations)

This turns this type of code : myString = "abcd ..." (where abcd is NON Latin) in a mess.
So you will have to go and EDIT ALL this type of assignment.

Steven Sitas

von Steven Sitas - am 24.03.2015 11:33
Hi Guenter,

Many thanks for the insight into the best way to upgrade. I guess I would have to upgrade sooner than later.


von Sam Asid - am 24.03.2015 13:45
Hello Darren,

Thanks for these insights.

Just one more question. What has been your experience with SaaS implementation on HFSQL?

Is it a must for me to use WEBDEV APPLICATION SERVER and what costs are associated with it?. If no what alternatives are available?

Best regards,


von Sam Asid - am 24.03.2015 14:03
Hi Sam,

None really, I've not gone down the SaaS route. As far as the WAS goes, other people might be able to go into more detail about their experiences, but as far as I know, it's mandatory to use the WAS if you intend to use the (in built) AAF features. As an alternative, I seem to remember someone implementing Apache, but as I've just stated, you'll be limited to what you can do.

von DarrenF - am 24.03.2015 14:29
Hi Sam,

Saas and HFSQL are two things. You can do Saas without DB or with it. HFSQL works well with many DB / users access, etc. (You create different DBs and users having access only on the given DB for each of your Saas customer.) It depends the loading you think you will have.

For Saas (or anything Web, like WebServices) using PCSoft technology, you will need WebDev Application Server and also WebDev for Saas (but for WebServices only, WinDev alone is sufficient since you can create WebServices in WinDev and deploy them on a WebDed Application Server).

Best regards,
Alexandre Leclerc

von Alexandre Leclerc - am 24.03.2015 15:14
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.