I have a quick question, If I edit the data of the Postgres or SQLite DB that stores all the sync notes in the Joplin Server, does this change my local data after the next sync?

Only if you change update_time, I think

If I can change the data directly from the server, So Technically we can make a Web app on top of the Joplin server which can use the Server Auth(as we can use the user details directly from the server DB) and view and edit directly from the browser. I know there are many websites to access data from Joplin but I guess they use the clipper service and so work on the localhost, making a web app on top of the Joplin server will make many things easy, users can access it from anywhere from ( though they have to set up the VPS and sync with Joplin server). In short 3 docker containers running on a VPS Joplin server, Postgres, and the web app where the web app will use the Postgres data for auth, showing, and editing the notes.

I'm not sure, but weren't there server APIs that were also used in the collaboration plugin from last year's GSOC? Because when editing directly in the DB also all entrys from other tables of Joplin (resources, ...) must always be edited or updated or otherwise it could come to inconsistencies and e.g. resources are deleted because they are no longer tracked correctly ...

That's why I didn't experiment with this on my server. [image] JackGruber: there server APIs that were also used in the collaboration plugin from last year's GSOC? I will check the codes for the collaboration plugin. It will be great if can somehow make a web app on top of the Joplin server. Most of the things are already working with the Server, Adding an Edit thing will make it perfect.

[image] JackGruber: I'm not sure, but weren't there server APIs that were also used in the collaboration plugin from last year's GSOC? I don't think so. If I recall correctly it used a separate server for coordination, not the joplin server.

[image] krishna: If I can change the data directly from the server, So Technically we can make a Web app on top of the Joplin server which can use the Server Auth(as we can use the user details directly from the server DB) and view and edit directly from the browser. You don't need to limit it to only use the Joplin server though. You might as well use the sync code from Joplin and make the web app just another Joplin client syncing with any supported sync target type.

That seems cool, It will take some time but if everything works out well it can be very useful to everyone, I will start the project in a few days after some research on the working of the web app and stuff we can add to it.

FYI, I'm about (I still need a few days) to release Joplin-vieweb in a docker way, far far simpler than this way of doing. I'll post in this post when it's ready. In two words, the setup will be one command line (docker-compose up, change admin password (which is admin, logical ;-), setup cloud sync, and you're done). A schema of the containers here.

Editing the database directly from Joplin Server DB

Support

roman_r_m 21 April 2022 20:06 9

Also check out Joplin-vieweb: a simple web viewer for Joplin notes

Topic		Replies	Views
Joplin Web Interface w/ Joplin Server Features	3	2558	22 February 2021
Joplin notes web client? Features	9	466	14 September 2026
Joplin Server pre-release is now available Development	230	67064	4 September 2021
API: How to access port 41184 without a desktop app to get API working? Support	5	302	8 June 2024
Joplin in the Web without terminal instance Features	5	291	29 January 2026

Editing the database directly from Joplin Server DB

Related topics