Inventory Database

Discussion in 'Mac Programming' started by jsbarone, Jun 26, 2007.

  1. macrumors regular

    Joined:
    May 8, 2007
    #1
    Hey Guys,

    I'm trying to put together a lightweight, web based inventory database for the hospital I work at. We're currently using an *OLD* access 97 database that we all want to get rid of. The information stored within is really simple---pretty much just Service Tag, Computer Name, Date Updated, ram, an comments. We have about 1200 pcs here that we'll need to inventory.

    My question is this: What would be the easiest, most stable way of getting this done? We don't need anything frilly---what do you guys recommend?

    Thanks,

    J
     
  2. macrumors regular

    GothicChess.Com

    Joined:
    Apr 6, 2007
    Location:
    Philadelphia, PA
    #2
    Even for "simple" projects, programmers work best from a "spec" (short for specification) that describes what you want to achieve.

    In your case, what is presently unknown:

    1. Will there be just one "view" of the data, or will the user have options from the brower level?

    2. The database engine can drive queries such as search, sort, select... etc., so do you intend to make the browser communicate such queries to the db engine?

    3. Are certain db features prohibitted through a security hierarchy? For example, can a "guest" add or delete records? If not a guest, can a db admin access it remotely and add/change/delete records, etc.

    While sounding simple, your post can mask some hidden requirements, and it is best to think about them now rather than later.
     
  3. macrumors 6502a

    Joined:
    Dec 4, 2006
    Location:
    Katy, Texas
  4. macrumors regular

    GothicChess.Com

    Joined:
    Apr 6, 2007
    Location:
    Philadelphia, PA
    #4
  5. macrumors 68040

    iSee

    Joined:
    Oct 25, 2004
    #5
    I second the Ruby on Rails suggestion, probably with a MySQL DBMS behind it (or SQL Server or whatever if you already own it).

    You can get going really quick with it.
     
  6. macrumors 68040

    MongoTheGeek

    Joined:
    Sep 13, 2003
    Location:
    Its not so much where you are as when you are.
    #6
    Filemaker might be an option. Really easy to use and administer.
     

Share This Page