PDA

View Full Version : Inventory Database




jsbarone
Jun 26, 2007, 03:56 PM
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



GothicChess.Com
Jun 26, 2007, 04:32 PM
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

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.

toddburch
Jun 26, 2007, 04:33 PM
Ruby On Rails?

Todd

GothicChess.Com
Jun 26, 2007, 04:35 PM
But, to answer your question a little more fully, what you are talking about is a database-driven website. The two core technologies are php and MySQL.

And a link to get started:

http://www.sitepoint.com/article/php-mysql-tutorial

iSee
Jun 26, 2007, 05:03 PM
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.

MongoTheGeek
Jun 27, 2007, 07:40 AM
Filemaker might be an option. Really easy to use and administer.