Martin table update

[IncidGeo]

Hi everyone,
I run Martin behind nginx in a docker. Our website is base on geodjango/maplibre/j and it allow the user to feed postgres/postgis via a drawing tool + a turf processing and a form. When a new entity is added with this tool the entity is immediately available in maplibre to be seen.

If i feed postgis with pg_admin or Qgis with a large amount of entity (parcells) in an other table, i need to restart Martin to see the new parcells. How does it exactly work ? Is it a normal behavior ?

[nyurik]

Martin would not auto-detect new tables/functions just yet (see #288), but it should make the new data instantly available without restarts if the data is added/modified in the existing tables/functions.

[gagecarto]

@IncidGeo - How did you deal with this situation or did you find a solution? I have the same issue where I need to force Martin reboot to see new data on PostGIS. I am also running behind NGINX.

[IncidGeo]

If by 'new data' you mean a new table, I think it's normal behavior. My problem was with a new entity in an existing table. I don't remember exactly what I did, but I think updating to the latest Martin and MapLibre solved the issue.

[gagecarto]

For me it's not new tables, but new rows in my tables. Have not yet found a work around and still have to restart Martin to have the new rows return tiles.

[IncidGeo]

Sorry, I got confused. I looked at my code and realized it had nothing to do with Nginx or Martin, the issue was on the client side. That said, I still had to update Martin due to a really slow startup problem.

I added the following functions to my code:

map.on('zoomend', function () { RefreshZone(); });
map.on('dragend', function () { RefreshZone(); });

I also added RefreshZone() at the end of the async functions that adds, saves, and deletes rows in the database.

Then, I defined the RefreshZone function:

function RefreshZone() {
    const baseUrl = "{{ base_martin_url }}";
    map.getSource('zones').setUrl(baseUrl + `/carto_projet_zxy`);
    map.getSource('zones_label').setUrl(baseUrl + `/carto_projet_labels_zxy`);
}

I guess I could have done better with a script that checks for the latest updates in the table and sets the URL only if needed. This script could also check for updates every, let's say, 5 seconds in case the map is not moved or dragged, and another user has made a change in the table.