in General, Libraries/Info Sci, Tech

Wanted: Database front end solution

At work we’re in the process of digitizing a local special collection, to be made accessible online.

We plan to get all the relevant data in a MySQL database, and are looking at front end options. We’d like it to handle two things in particular:

1. Allow remote login and editing of records, so the current collection holder can do some maintenance.

2. Allow restricted access to certain items. For example, the public at large can see just some items in the collection. Other items can only be viewed after some users log in.

I realize its vague so far, but I don’t have a lot of other details yet. Anybody know of a solution? Open source is preferable.

I could code #1 on my own, but I’m not quite confident enough in my abilities to make sure that #2 is completely secure.