Hello
I am working on a side project where I want to sync selected Joplin notes with a custom web dashboard that displays key tasks and tags. For storage & querying, I am using Microsoft SQL Server.
I have written a small script that extracts data from the resources
& notes
folders via the Joplin API and pushes it to a SQL table. However; I am running into challenges with keeping the sync reliable and filtering out deleted / encrypted notes efficiently.
The main goal is to create a live dashboard (maybe in Power BI or a Flask app) for weekly review meetings. But the problem is; sometimes note updates don’t reflect in the database in real time, and I’m not sure if the issue is with the webhook I am using / a delay in Joplin’s data exposure. Has anyone tried a similar setup using Microsoft SQL Server or other relational databases?
Also; I am documenting this as part of a broader guide I am preparing on what is Microsoft SQL Server, for non-tech users using Joplin in small teams. Any thoughts or guidance on optimizing the sync pipeline, or even contributing to a plugin idea, would be appreciated!
Thank you !!