The CRM system implements auto-update of data. However, the script does not automatically trigger when the data on the server is updated itself, and only starts working when I manually request data from the server. This needs to be fixed.

Frontend: JS creates an EventSource to the SSE endpoint, listens for push notifications. If SSE is unavailable, it switches to AJAX polling via fetch()/XHR at intervals.
Backend: PHP daemons (totum-gom) under systemd support long-lived SSE connections, monitor database changes, and send insert/update/delete events to clients.

Ideally, this should happen step-by-step as follows:

User opens the table → JS creates new EventSource('/stream/table/{id}').
Another user makes changes → trigger in the database → PHP daemon creates an SSE event, for example event: update, data: {...}.
Event is sent to all connected clients → JS parses evt.data → updates the DOM.
If EventSource does not work → JS makes a GET /api/table/updates?since=… after N seconds and processes the changes.

Thanks to SSE and systemd daemons, changes are reflected instantly without reloads.

I will send server access details in private message

Proposals 2 Withdrawn 1

Andrew Sliusar

0 0

Projects -
Rating -
Rating 120

Budget: 3000 UAH Deadline: 2 days

I have experience implementing auto-refresh via SSE and fallback to AJAX. I will check the trigger logic in the database and the handling of demon connections. I will fix it so that events are sent immediately after changes, without the need for manual API calls.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Oleh Orlov
Ukraine

Projects 2
Rating -
Rating 327

Auto-renewal error

Client's review of cooperation with freelancer

Auto-renewal error

5.0

Oleh Orlov

Freelancer's review of cooperation with Oleh Orlov

Auto-renewal error

5.0

Andrew Sliusar

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Javascript and Typescript

Automation based on Google Sheets for signing up for trial classes (online language school)

Fix the opening of Trust Wallet when clicking the link in the TikTok profile header.

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.