Gun Inventory software

[XD45]

Sounds like a good idea, and I think incyn covered alot of possible ideas to be used. I'd love to have some technology brought to my setup, right now i just have a bunch of tags, and a dry erase board so I can mark down when i take something in/out of its storage spot.


Not always easy keeping track of 40+guns, alot which i've never touched.

[mojo]

What about having fields like "Manufacturer,Action,Condition" pre-filled drop down lists? I was thinking model but that might be a lot to keep up with.

[mjfletcher]

Originally Posted by mojo

I started writing a web-based gun inventory application and I'm looking for some ideas for features from this community. Why am I asking here? Well, as I just recently started my collection I know that I will be missing things that I will want down the road as my collection/experience grows. There are a lot of people here with much more experience than I have so I thought I'd ask for help. BTW ... I do not plan on making this a commercial product. Actually, I was thinking about making it free for everyone to use if I can get "satisfied" with it.

Only suggestion I have would be to include MySQL compatibility in it. MySQL is free, open source database software and most scripting languages (like PHP) have MySQL access functionality built in. If you're going web based, PHP/MySQL is a dynamite combination.

[mjfletcher]

Originally Posted by andrewjs18

also, if its going to be web-based, maybe a username and password field to keep the data secure.

Web based doesn't necessarily mean internet accessible, just that it uses a browser to view pages rendered using html. Its easy enough to include one line of code that will permit access to the program from only the machine its installed on, ie: browser addy http://localhost/GunInv

But password protection is still a great idea.

[mojo]

Originally Posted by mjfletcher

Web based doesn't necessarily mean internet accessible, just that it uses a browser to view pages rendered using html. Its easy enough to include one line of code that will permit access to the program from only the machine its installed on, ie: browser addy http://localhost/GunInv

But password protection is still a great idea.

Very true ... but I was planning on it being internet facing.

Also, this is a LAMP based app.

[normanvin]

if the program is internet based where would the info be hosted? Could it then also be mirrored on a persons home pc?

[mjfletcher]

Originally Posted by mojo

Very true ... but I was planning on it being internet facing.

Also, this is a LAMP based app.

Looks like you've got it all covered, Linux (Long Live Tux!!!), Apace, MySQL, and PHP.

[mjfletcher]

Originally Posted by normanvin

if the program is internet based where would the info be hosted? Could it then also be mirrpred on a persons home pc?

Using the software and DB he is, it would be very easy to export userdata into a spreadsheet, text file, or pretty much any other format and include a link in the users control panel to do that.

[jofreder]

Sensitive Data stored with encryption.

[Scrumpyjack]

I've been using GunSafe for a few years now and really like it. It is far better than the spreadsheets I created.

http://www.somanyroads.org/gunsafe/