TR Forums

I'm looking for an online database equivalent of MS Access or LibreOffice Base where I can store the catalogue for our band's music library.

We currently have a laptop running LibreOffice Base but this means that only the laptop can access it. Access from Android, Chromebooks, i-Things is required.

As well as the catalogue itself, I want to be able to build tables with our concert programs in them so that I can go and do queries to find out when we last played a piece - so this is a bit more than a standard catalogue and why I need a database where I can do proper SQL queries from forms rather than just a spreadsheet. We do this in Base currently.

Anyone got any pointers? Preferably free or very low cost? I do have my own Linux webserver which is already running MySQL and Apache for other things, but I don't really want to spend a bunch of time writing PHP / Perl / Python or similar to try and build something myself. This does mean that I can host it on my server rather than paying for online storage.

Use firebase. It is pretty cool. You may develop a small app around it to access from pc handheld etc.

Parse server might work for you pretty well as well.

If you're comfortable with it, you can back end LO Base onto MariaDB, PGSQL, Firebird, etc. Use it to build your schema, migrate the data, then layer an interface of your choice on top.