• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
More than one dbase file possible?
#1
Hi, 
I would like to make a major import to Mobile Sheets. In this case , I want to keep this import separate from my regular database. I know  Mobilesheets should take care of this no problem, but I do not want to take any chances whatsoever, backups or not. Right now the "Let Mobilesheets manage my files" option is unchecked.

So what are my options? 
1- Backup my database, erase everything and start a new database.

2- Would it be possible to just rename the database file and the db_journal file? One would expect in this case that MS would just re-create a new blank database file under the name "mobilesheets.db".
If this works, seems to me it would be quicker.

3- The ideal in this case would be of having the option of opening a second database file in MS. Correct me if I am wrong, but I don't think this is possible currently in MS. Has someone already asked for a feature such as this? Or am I the only one who thinks this would be desirable?

Dan
Reply
#2
It has been asked a few times.

AFAIK you can simply rename in Android version. If it works for W10 iis for Mike to say.
Reply
#3
Yes, you can just rename the database file (if you enabled Settings->Storage->Expose Database). Make sure MobileSheetsPro is fullly closed before you do this. MobileSheetsPro will just create a new database file the next time you load it.

Yes, others have asked for the ability to have multiple databases/libraries. It's on my list of things to add when time allows, but I have some other higher priority things that need to be worked first.

Mike
Reply
#4
Could you possibly explain more fully / clearly how I could use and load 2 or more dbases, using this approach of renaming the dbase file?

Could I keep the dbases in 2 separate folders, each with their own mobilesheets.db file in that folder (exposed, as above), then change the storage location to 'the other' file folder, and restart mobilesheets?

thanks,
Chris
Reply
#5
Even easier just duplicate the database dir, name it files1 or something and rename it back to files if you want tto use it's database (of course after renaming the current to files2 or something).
Reply
#6
(03-18-2018, 04:56 AM)BRX Wrote: Even easier just duplicate the database dir, name it files1 or something and rename it back to files if you want to use it's database (of course after renaming the current to files2 or something).

Thanks for coming back on it - I can make that work.

I can't help wondering if there is a way to 'insert' a startup page, in which the user can select a different directory path of the database to open, and if that might be relatively straightforward to code.  May need a switch in settings for user to activate it - off by default to not confuse people.  Or maybe store the X most recent locations selected.

All that aside, thx again.
Reply
#7
My plan is to provide a new option in the settings to "switch library", and this will be a list of databases the user has set up. On Android, I can support having those databases be in any folder the application has access to. For simplicity's sake, if "Expose Database" is disabled, I will only ask the user for a name for each library and each database file will be stored in the same directory in the internal application data directory. If expose database is enabled, then I'll let the user select the location for each database file, but I'll default to the storage location. Switching the active library will just update a preference file which the application will read at startup to figure out which database file to load. If you do something like perform a library backup, it will only back up the currently selected database. In fact, every action in the application will only act upon the currently active database. This will keep the feature and complexity from getting out of hand and it won't require huge design changes. Have multiple open databases at once is something I have no desire to support.

On Windows 10, I have to keep every database file in the application data directory next to mobilesheets.db - there is no flexibility in this as the SQLite library fails if the database files are not in that folder. So the user will be able to create multiple libraries and name them, but they will not have control over where the database files are stored.

I'll be curious if this approach will satisfy the needs of those who have requested this type of feature in the past. I'm open to feedback of course, but the one thing that I won't even try to support is using multiple database files at once.

Mike
Reply
#8
As one of the persons who bugged you a long time for this feature: Yes, this is precisely what I would like to be able to. My primary goal is to keep sets of song projects separated. Really separated, including eliminating the chance to clobber a song in a project that is (accidentally) shared with another.

I'm looking forward it...
Johan
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo & Digit.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup).
Samsung A3 (A320FL), Android 8.0 (emergency).
Reply
#9
Also, it would make troubleshooting a easier, since I would be able to reproduce a problem with a dedicated (small) database and send you the database dump so you have everything (data and settings) that matters.
Johan
www.johanvromans.nlwww.howsagoin.nlwww.hetgeluidvanseptember.nl
Samsung Galaxy Note 2 (N8010) 10.1", Android 7.1.2 (LineageOS), AirTurn Duo & Digit.
Asus Zenpad (Z300M) 10.1", Android 7.0 (backup).
Samsung A3 (A320FL), Android 8.0 (emergency).
Reply
#10
Same here. Less of my memory problems. Quicker loading times and so on.

Inevitably there will be requests for transfer between databases which will involve more than just renaming the files and reloading.

But this might be possible with exporting and reimporting msf files?

(I also still like to have to make a backup file of the database and all settings *without* the files for the sheets. This would be also helpful for multiple database which all access the same files directory).
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2018 MyBB Group.