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 fr…

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 …

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…

[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 i…

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 sy…

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	2488	22 February 2021
Joplin Server pre-release is now available Development	230	65790	4 September 2021
API: How to access port 41184 without a desktop app to get API working? Support	5	259	8 June 2024
Joplin in the Web without terminal instance Features	5	218	29 January 2026
Joplin Server & Docker: Serval Questions Support	5	1280	2 July 2023

Editing the database directly from Joplin Server DB

Related topics