Real-Time GeoJSON Updates in MapLibre with SQLite?

[Swamp2k9]

I'm working on a project that involves handling data for hundreds of locations, with each location linked to a unique GeoJSON file.

From this post, I've realized that using individual files isn't efficient for runtime operations. This post suggests that it might be possible for points.

I'm now exploring a solution similar to Firebase, called TrailBase, which enables real-time updates using SQLite. It offers features such as SQLite's virtual columns and the ability to make API calls.

My question is: Once changes are made to the GeoJSON data within the SQLite database, will MapLibre automatically reflect these updates on the map by adding, editing, or deleting points?

[sargunv]

MapLibre doesn't query your database for you, and doesn't have any awareness of when data changes in your database.

To control when data is refreshed, you can use a ComputedSource, implementing a function for retrieving data at a tile, and calling one of the invalidate functions when your data is updated.

[Swamp2k9]

Thanks for the quick response. It sounds like ComputedSource is what I'm after.

I'll follow your advice and will keep you in the loop if I come across any issues.

Thanks again 🥳