Publii, Dropbox and syncing the db.sqlite file
- This topic has 9 replies, 2 voices, and was last updated 1 year, 1 month ago by .
- March 7, 2020 at 11:15 pm #2006Verhoeckx
Hello Publii developers,
I use Dropbox to share the code of a website between me and a customer, and I notice that sometimes it takes a very long to sync the db.sqlite file.
- Is it possible that Publii locks the db.sqlite file and prevents it for syncing (uploading and/or syncing)?
- Is it true that you need to restart Publii in order to see a change in the db.sqlite file (and by this way in a post)?
I have run some test but I can’t find (yet) a clear pattern of what is happening.
VerhoeckxMarch 9, 2020 at 11:58 pm #2024Verhoeckx
Do people here have a good experience with Dropbox and working together on a site?March 10, 2020 at 11:37 pm #2033Tomasz Dziuda
Publii uses the db.sqlite file directly (not in a memory), so yes – it is possible that Publii locks that file.
At this moment Publii is not prepared for a parallel work. It is still good if you want to create a website with other people not in parallel.March 11, 2020 at 6:16 pm #2054Verhoeckx
So what do think is the best workflow?
I think that I have to ask my customers to close Publii after they have edited a post (or several posts)?
If they (and me) do that:
- They unlock the db.sqlite file.
- Get the new content when they start Publii the next time.
VerhoeckxMarch 11, 2020 at 6:42 pm #2056Tomasz Dziuda
It seems to be the only solution in my opinion, but to be honest – it does not sound like a fluid workflow. Unfortunately at this moment I cannot propose anything better :/March 11, 2020 at 6:59 pm #2057Verhoeckx
I have to agree with you!
Publii is absolutely a wonderful and efficient system. The fact that it’s a client application makes it really accessible for customers and this is one of the reasons (besides the speed and the unhackable setup) that I chose Publii for building the next couple of websites. The fact that’s a client application has only one drawback: you have to sync the files in order to be able to work together (which creates the problem above). In an ideal situation Publii would run on a server and you would have to access it there. But as I understood from Bob this isn’t possible at the moment. If it would, Publii could become the next ‘WordPress killer’. Having said that: I also understand that it takes a lot of time, energy and money to develop this. (and I can’t help you because I don’t know how to program with Node.js and Vue).March 25, 2020 at 3:21 pm #2203Verhoeckx
Can I ask you a question?
The coming weeks I will work on two websites simultaneously.
Do you happen two know what happens when you open/start Publii?
Does is open both db.sqlite files or only the one that you are currently using?
VerhoeckxMarch 25, 2020 at 3:32 pm #2204Verhoeckx
The reason I ask is that when Publii opens both db.sqlite files, and I’m constantly working in one of the websites, I block an other user for editing the sqlite file of the other website. This would be very impractical.March 25, 2020 at 4:21 pm #2205Tomasz Dziuda
Publii closes current DB connection before site switch: https://github.com/GetPublii/Publii/blob/2b2f4c4618b07969c1dd6d3753b63ecf878a7d22/app/back-end/app.js#L211-L213March 25, 2020 at 8:20 pm #2206Verhoeckx
Ah, that’s good news! Perfect!! Thanks!
- You must be logged in to reply to this topic.