Sync using OneDrive

26 posts
Re: Sync using OneDrive
User avatar
MisterY
Super MMEX User

Posts: 142
Joined: Sat Jan 24, 2015 2:11 pm
Actually, if it can do a row-level replication, I'd be happy to implement it in addition to existing file-level sync.

https://github.com/moneymanagerex/andro ... issues/991
Re: Sync using OneDrive

wizardict
New MMEX User

Posts: 14
Joined: Fri Aug 26, 2016 9:27 am
I agree that many users would not know how to set up their own server, but would want the functionality it provides. I think ultimately there would need to be a "server" installation of MMEX. That should be fairly simple, an installed for a SQL DB of choice and the sync component. For the initial phase though I would say implement the sync and let people with can set up their own server try it out.

In terms of support I think you would find this requires less support than the current system, not more. The issues you're having with dropbox sync is that dropbox was never intended to sync database files in this way, trying to use something for a purpose it was not intended for is always going to cause issues. By implementing something that is designed for this purpose, once the bugs are sorted it, it should work fairly smoothly.


I appreciate this is potentially a fair bit of work, but I think it's worth it. I like MMEX but there are numerous other free open source solution out there that do a similar job. The thing that set MMEX apart for me (and why I'm here) is that I need the ability to enter transactions when I'm out of the house. That's when I make most of my smaller transactions, and currently regularly forget to record them when I get home. The android integration you currently have sort of resolves that issue, but there are too many limitations. Not least the fact that if I forget to close the desktop version and enter a transaction on android I'm going to end up with 2 versions of the database that are difficult to reconcile.

Take a look at the SymmetricDS site and see if you're happy with it and what it can do (there are other similar solutions out there but I think this is the best fit for this project). I believe if you get this right it will really set MMEX apart from the crowd.
Re: Sync using OneDrive

trice001
New MMEX User

Posts: 1
Joined: Wed Mar 29, 2017 4:23 am
thanks for that.
Re: Sync using OneDrive

javiermarcon
New MMEX User

Posts: 4
Joined: Fri Mar 31, 2017 11:35 am
Excelent idea on using symmetricds to manage cetralized database. Is there a tutorial on how to configure symmetricds to sync several mmex databases?

Thanks.
Re: Sync using OneDrive

wizardict
New MMEX User

Posts: 14
Joined: Fri Aug 26, 2016 9:27 am
javiermarcon wrote:Excelent idea on using symmetricds to manage cetralized database. Is there a tutorial on how to configure symmetricds to sync several mmex databases?

Thanks.
As far as I'm aware no testing or development has been done in this area so far, so there are no tutorials as you would be breaking new ground. Whilst I think there's agreement that it would improve synchronisation, there are a lot of other things to work on and devs only have a certain amount of time.
Re: Sync using OneDrive
User avatar
MisterY
Super MMEX User

Posts: 142
Joined: Sat Jan 24, 2015 2:11 pm
Yes, I'd certainly encourage anyone interested to explore and contribute. As I keep saying, it's an Open Source hobby project.
Please keep in mind that, even though in MMEX there are several participating developers, for Android there is only one person (more or less) actively involved so don't expect much in terms of development or documentation at this point.
Without two-three or more actively participating developers, I don't think we'll be progressing much in the short term.
Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 1 guest