MobileSheets Forums

Full Version: Managing a database that is too big for my device?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Being a heavy user of MS (never going back to the old paper mess) I'm planning to scan my bookshelf full of sheet music to MobileSheets. However, according to my calculations, I will be running out of storage space on my tablet(s).

What would be the best practice in managing a really big database? I'm envisioning maybe having the full metadata (database) stored on the tablet, but the "media" files (pdfs) lying online in a cloud storage. They would then be automatically downloaded "on-demand" only. Often used collections or set lists could optionally be preloaded offline. Does MS already support something like this?

Any tips would be appreciated. ?
I have my Files on the sd card. With my own folder structure. This workes fine but you have to pay attention when synchronizing to an other device.
Seems to me that storing stuff in the cloud has one big disadvantage - what happens if you have no net access when you need to bring something down?
Not only no internet, but slow internet. I think I would use my PC with a big memory card or drive. Fewer things to go wrong, quicker access and multiple backup options [eg. 2 locations].
Cloud? Never! I've had too many bad experiences with flakey (or absent) internet on stage.

Tell MSPro to use a big SDcard as storage location. That has always been a very powerful MSpro feature.
Sure, I would never take the risk of relying on internet access on a gig. So the solution I'm looking for would have to allow for offline access to critical parts of the library. But if I scan my full bookshelf to MSP, maybe 99% of the library will be non-critical. It will just be my digital archive, safely stored in the cloud.
Just curious: How many gigabytes of storage do you expect to need?
Here's how I manage a pretty similar situation (see screenshot):
In MSP I manage the files myself
d:\HerbertsGoogleDrive\_MobileSheets\ is my MSP storage location
d:\HerbertsGoogleDrive\ is synchronized by 'Google Drive for Desktop'
Almost all sheets that I use on stage are 'one file per song' chordpro files or PDFs exported from ChordPro, MuseScore, ABC or Finale. They are in the subfolders of _MobileSheets\Songs\
A number of essential songbooks that I want to carry around all the time for sessions, practicing and rehearsals are in _MobileSheets\Fkbk0\
These two folders are maintained in my main mobilesheets.db and synchronized to the tablets that I use on stage.
On my notebook (where storage space is only limited by the 15 GB of the free GoogleDrive) I have many more files and several separate MSP databases to keep track of the whole collection, hljpa.db for the Hal Leonard Jazz Playalong series, MSPTest.db for test purposes and a really big one for everything.
A great feature of MSP: if all paths are relative, the MSP databases are compatible and can be copied easily between Android and Win10 devices.
I have about 5 GB of sheet music on my tablets. I have just learned the advantage of transferring music via USB drives and SyncLibrary (device) rather than the Companion app.

In my case, all tablets can do SyncLibrary as either client or server, but be careful not to sync from an empty tablet!

In my case, two out of three tablets can do BatchImport from a USB drive, but one of them cannot; it can do Import/SystemFileBrowser from a USB drive, but that is painful for more than a few files as you must select them individually (Multi-select is a long press on each one). Discussions in the forum show that other users have similar limitations, related to specific models of tablets and/or versions of AndroidOS. If your tablet cannot do Batch Import from a USB drive, a workaround is probably to put the music onto an SD card and do BatchImport from that.

I segment my music by Genre, one for each group with which I play, plus some general ones like ChamberMusic, Showtunes&Pop, and Classical (the last two are implicitly piano solos). On my Mac each Genre is a folder, and after copying to USB drive I do 12 BatchImport-s from each folder to its Genre.