Let’s say I created a simple customer contact database in XoJo and wanted to be able to move it between MacOS, Windows and Linux, is it possible to have it support that without jumping through hoops. In other words, could I just copy the database files between the systems and have them work?
And just to be clear, not putting it on the network and everything accessing it there.
yes it is the same file between platforms
at least for sqlite, as others need to reside on a server.
Thanks! That would be great for my purposes
Yes using SQLite this is possible but bear in mind these databases would not be in sync - they would be distinct from each other so you would have to make sure you had some control over which one is the latest one so you don’t lose data when copying to another platform for example.
I.e. you run the app on Mac, add data to the contacts database then you copy the program and database to Windows and make some changes to the contacts. At this point your Mac version is different to the Windows version - if you then make changes in the Mac version then you have multiple versions all with different data and syncing them up would be a challenge.
If you want to do this then you can really only have one master otherwise it will get real messy, real quick.
Makes sense. My plan would be if and when I put it on another system, I’d copy the database file from the master location as you mention.
Thanks.
Yes, and see here:
Like I say it can work but make sure you know which is the most up to date. If you plan on this expanding in the future then it might be worth looking into a server based database which the various client platforms can link into.