N
N
Nikolay Bozdyrev2021-03-25 13:44:10
Data exchange
Nikolay Bozdyrev, 2021-03-25 13:44:10

In what language should I write a program for data exchange between Sybase SQL Anywhere 17 and Bitrix24 databases?

Greetings! At the enterprise there was a requirement to make a daily exchange between two CRM. There is not a lot of data, about 30 thousand clients each have 10-20 parameters, but the amount of data is growing. In Bitrix24, everything will be transmitted by webhooks (POST requests) using php scripts. A question in that what means theoretically "kosher" to pull out the data from a DB "Sybase SQL Anywhere 17"?

Now small tasks are solved by the same php: when the script is launched, it connects to the Sybase database, receives data and transfers it for processing, but there is not much data. Will php cope with getting big data? Or is it a "perversion" and you need to use delphi, python, etc.?

Numerous options were proposed by possible contractors, I must admit that monsieur contractors know a lot about perversion, and the proposed solutions were radically different in their architecture.:
1.) Someone suggests taking data, zip it and sending it to an intermediate processor that will implement the second contractor, implement everything in delphi, because this is an icon and there is nothing better.
2.) Someone says that you just need to run a php script every n minutes, which would replenish the queue of jobs for sending and the queue of jobs for receiving data, while displaying all this in a beautiful form and in real time.
3.) Someone suggests implementing everything in python, because picking up, processing and sending post for python is not a problem at all.

I explain: the data is planned to be received and transferred to the php handler, the intermediate data will be stored in MySql, and the results of the executed webhooks (requests in Bitrix24) will be logged and stored in the same MySql.

All opinions are interesting! But please refrain from holivars, I'm not trying to find out which PL is better, I'm trying to understand which language is best suited for this particular task.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dimonchik, 2021-03-29
@dimonchik2013

there is no better delphi, but it has one drawback - it does not write itself, and there are fewer and more expensive progers
python is the best,
but if you already have an unfortunate PHP guy - try the
feature on it that there are already some asynchrony in Pykha, and for a long time, but progers who can do this are also not cheap, and are almost always familiar with Python
, and non-progers are also familiar with Python

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question