|
FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile |
| | | | | |
| Débuté par Beauregarderson, 16 juin 2017 07:39 - 7 réponses |
| |
| | | |
|
| |
Posté le 16 juin 2017 - 07:39 |
I have created a POS application using version 20. It uses hfsql c/s files. I use HAdd/Modify/Delete for single records and HExecuteSQLQuery for multiple records. I was going to use Fabrice's WXReplication, but from the documentation it seems that any queries that use HExecuteSQLQuery will not work with replication. It also sounds necessary to use WebDev server and I don't want to have to buy WebDev.
I'm starting to think it would be less work to switch to MySQL which I believe has built in replication I can trust compared to PCSoft's built in replication. Can anyone share their experiences using WinDev with MySQL and/or replication? |
| |
| |
| | | |
|
| | |
| |
Posté le 16 juin 2017 - 08:10 |
Hi,
we have a POS solution as well and we're bi-directionally replicating the databases of cash registers and server databases using our own solution, which is 10+ years old. Direct Database access is done from the cash registers which are initiating the replication. While MySQL databases are not secure and you'd have to use a web service or a socket connection, HFSQL C/S is secure. We never ever had a security issue with HFSQL C/S. So, switching to MySQL would cause a lot of additional work to you and MySQL isn't free anymore. The main database of our system is running on the servers (Windows and CentOS ones) of our customers. Replication is done on basis of GUIDs, the current "official" system is using 8-byte integers, which I deeply mistrust. Fabrice Harari's system uses GUIDs too. See thread http://27130.foren.mysnip.de/read.php… Fabrice has an open source replication system, see the link in his signature. |
| |
| |
| | | |
|
| | |
| |
Posté le 16 juin 2017 - 08:39 |
Hi,
Can't you use Triggers in the HFSQL Server side to catch the changes that the stored procedure is making, and handle them the same way as HADD, HMODIFY, HDELETE ?
https://doc.pcsoft.fr/en-US/?3044369&name=Server_trigger
If you would implement this, I think you can catch all changes whether they are made in the application or on the server. And you only need to handle this on the server else you catch the change twice.
Maybe something you can check-out !
Hope this helps !
Danny |
| |
| |
| | | |
|
| | |
| |
Posté le 16 juin 2017 - 14:03 |
Hi,
Quote
Beauregarderson
I have created a POS application using version 20. It uses hfsql c/s files. I use HAdd/Modify/Delete for single records and HExecuteSQLQuery for multiple records. I was going to use Fabrice's WXReplication, but from the documentation it seems that any queries that use HExecuteSQLQuery will not work with replication. It also sounds necessary to use WebDev server and I don't want to have to buy WebDev.
I'm starting to think it would be less work to switch to MySQL which I believe has built in replication I can trust compared to PCSoft's built in replication. Can anyone share their experiences using WinDev with MySQL and/or replication?
You can use all the READING queries you want. If you are using WRITING queries, then no, it's not possible (and I explain in details why you WILL have data inconsistencies in some cases when trying to replicate the result of queries on temporaly different datasets).
Best regards |
| |
| |
| | | |
|
| | |
| |
Posté le 16 juin 2017 - 23:54 |
Hi all,
different Situation, but same question: I have a System running where I Need to synchronize two databases, one inhouse at the customers site and one for a customer Portal running on a rented root Server (Windows).
I also use many SQL Update Statements, so Fabrice's solution does not work for me.
I am using the buildt in HFSQL bi-directional replication, which is working fine.
But I am running into Performance issues with the HFSQL Server. I installed MySQL for test reasons, and I do not have this issues using MySQL.
So I am also thinking about to Switch to MySQL, using the MySQL replication.
@ Guenther: Why do you think MySQL is not secure, because of the open port? As I only have 2 databases this should not be an issues, as I would use VPN for the replication.
@ Fabrice:
Quote
and I explain in details why you WILL have data inconsistencies in some cases when trying to replicate the result of queries on temporaly different datasets
Why?
Best Regards
Stefan. |
| |
| |
| | | |
|
| | |
| |
Posté le 17 juin 2017 - 07:30 |
Quote
@ Guenter: Why do you think MySQL is not secure, because of the open port? As I only have 2 databases this should not be an issues, as I would use VPN for the replication.
MySQL is a hacker's generic playground. We have more than a dozen web sites under Wordpress (they're using MySQL) running and we routinely stop any internet communication with MySQL databases. My nephew's company takes care of 500+ Wordpress web sites and again, all MySQL databases are closed to the outside. Maybe that a VPN connection helps in isolating communication between two computers on the web but not necessarily. From a viewpoint of security we routinely mistrust MySQL ...
Performance problems? Which type of? Did you adjust the HFSQL server using https://help.windev.com/en-US/… ?? HFSQL Server is configurable and shouldn't give any performance problems unless there are several hundred clients communicating at the same time. If your server hardware allows for more than a single thread then you could run several Manta services on the server (number of processor cores - 1) to ease the load. |
| |
| |
| | | |
|
| | |
| |
Posté le 17 juin 2017 - 07:52 |
| |
| |
| | | |
|
| | |
| |
Posté le 17 juin 2017 - 13:50 |
Quote
Performance problems? Which type of?
Hi Günther,
the Performance is ok except of one query, which is very slow and used very often.
3 Tables:
Auftrag_Kopf (Shipping_Orders)
===========
Auftrag_KopfID (Primary Key, guid)
.....
Auftrag_Pos (Shipping Details)
===========
Auftrag_PosID (Primary Key, guid)
refAuftrag_Kopf (guid)
sReference (string)
nPieces (numeric)
nWeight (Numeric)
...
Umsatz (Shipping costs)
========
UmsatzID (Primary Key, guid)
refAuftragKopf (guid)
sDiscription (string)
nAmount (Numeric)
Auftrag_kopf : Auftrag_pos 1:n
Auftrag_kopf : Umsatz 1:n
so each order has:
1 row in Auftrag_kopf containing adress data etc-
n rows in Auftrag_pos containing the shipping Details
n rowse in Umsatz containing the shipping costs.
I Need a result which Shows in one row:
Adress data from Auftrag_kopf, the total sum of weight and pieces from Auftrag_pos and the total sum of shipping costs from table Umsatz.
I tried to join the tables, which works with excellent Performance, but the result is wrong,
as: If i have 2 lines in Auftrag_pos the sum of the entries in table Umsatz are calculated twice.
So I join only Auftrag_kopf with auftrag_pos and calculate the sum of table Umsatz with an Sub query, which is extremely slow.
Best Regards
Stefan. |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|