Library database - help required

Discussion in 'The Rehearsal Room' started by dbate, Apr 20, 2007.

  1. dbate

    dbate New Member

    Messages:
    17
    Location:
    Abingdon, Oxfordshire
    I'm after some help here, folks!

    I'd like to computerise our band music library, and make all the information available via a database on an area of the website that's restricted to band members. Anyone got experiences of how to set up such a database? In fact, can anyone send me the files I need to upload and populate?!!

    A gent in our band has the expertise and has offered to do it, but it seems a shame for him to spend the time if it's already been done.

    Oh yes - it needs to be free! :)

    Cheers

    Dave
     
  2. The problem, o-ex-percussion-section-leader, lies in the html coding needed to search and display on the band's website, rather than in the database itself. I can send you an example library file in MS Access, but can't help with the web-based front end.
     
  3. madrich

    madrich Member

    Messages:
    44
    Location:
    Cardiff, Wales
    The librarian at Kew Wind Orchestra (Chris Gould) has written a package which does what you ask (it also keeps track of parts and things). Have a look:

    http://www.musiclibrarian.net/
     
  4. johnmartin

    johnmartin Active Member

    Messages:
    1,816
    Location:
    Lochgelly
    I've been working on just such a package using the free database MySQL and PHP for the coding. I've got it working at home for th ebands music library. I am intending to put it online in the future. I could put a sample of the stuff online to let you see.

    You need to be knowledgeable about the main technologies in initial development but once the pages are done the whole thing should run like any other windows program.
     
  5. dbate

    dbate New Member

    Messages:
    17
    Location:
    Abingdon, Oxfordshire
    Thanks John. So presumably the host will need to be happy with SQL and PHP.

    Dave
     
  6. johnmartin

    johnmartin Active Member

    Messages:
    1,816
    Location:
    Lochgelly
    Most decent ISP's will be. If they support Linux servers then you should be fine. These technologies are more suited to that environment than Windows. I use a company called plugsocket, very reasonable.
     
  7. johnmartin

    johnmartin Active Member

    Messages:
    1,816
    Location:
    Lochgelly
    I've stuck a quick and dirty search facility onto my bands database on our website. You can access it at http://www.lochgellyband.com/library_search.php

    I'm on holiday this week so I'll get the rest of the code up in a fortnight or so.
     
  8. dbate

    dbate New Member

    Messages:
    17
    Location:
    Abingdon, Oxfordshire
    Thanks John. I'll have a play with it!

    Cheers

    Dave
     
  9. TheMusicMan

    TheMusicMan tMP Founder Staff Member

    Messages:
    14,640
    Dave - did you ever manage to get this sorted for your band?

    The alternative is to use a Windows hosting account which will enable you to use MS Access.
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice