Gun Inventory software

[mojo]

Originally Posted by normanvin

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

I was planning on just hosting it on one of my servers. Would you just want the data or the whole application to be hosted on your home machine?

Originally Posted by mjfletcher

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.

Yep, I could easily write an "export" function to export out all the data. I always thought of it as a hosted app and not one where people could download the code and use it on their own (like a true open source application) but that's not a bad idea.

Originally Posted by jofreder

Sensitive Data stored with encryption.

What would you consider sensitive data? The only thing that I could think of is the serial number. I would require anyone to put any personal info in the system for user setup. Only thing required would be an email address.

[jofreder]

Originally Posted by mojo

What would you consider sensitive data? The only thing that I could think of is the serial number. I would require anyone to put any personal info in the system for user setup. Only thing required would be an email address.

Serial Numbers Yes, Certain pieces of Purchase or sales details, Personal info if any(email for one) and anything that could let the law or would be bad people know what guns are mine if they were sneaking into the data storage( File or Database), bypassing the apps interface. No offense intended but, I would not store my Gun details in a storage format that is exposed to the internet or run by someone else.

[mjfletcher]

Originally Posted by mojo

Yep, I could easily write an "export" function to export out all the data. I always thought of it as a hosted app and not one where people could download the code and use it on their own (like a true open source application) but that's not a bad idea.

I was thinking more along the lines of being able to click and generate a spreadsheet or some other such document that the user could print so they have a 'hardcopy' record just in case. Maybe export wasn't the right word.

Getting home and finding ones home has been broken into is stressful enough without having to try to remember a web addy, and even if you remember it, if the computer was stolen too you're pretty much stuck unless you ahve a printed copy of your data.

But a downloadable version of it that people can run locally would be something i'd definitely be interested in, but then again, im a computer geek.

"There are 10 types of people in the world, those who understand binary and those who don't"

[marinakorp]

Originally Posted by jofreder

No offense intended but, I would not store my Gun details in a storage format that is exposed to the internet or run by someone else.

Exactly

I use Gun Safe... have a local copy on the Home PC and one on a protected Pen drive

Work OK... a little buggy, and reporting is not great... but a good start

[mojo]

It would be easy to have every field encrypted where only the user can view the data because they would be the only one with the passphrase. It would make the system a lot slower ... everything is a balancing act.

[jofreder]

Originally Posted by mojo

It would be easy to have every field encrypted where only the user can view the data because they would be the only one with the passphrase. It would make the system a lot slower ... everything is a balancing act.

I would not suggest Encrypting every field but find some way to encrypt certain things. Yes, it will slow everything down, your storage space will increase, development will take a hit and you too would not be able to view, update data in the back end. Personally, I like to get to the data directly for trouble shooting, mass updates, testing, etc... too much encryption will cause you greif in the long run, find a balance. And don't forget this should run in a Secure Socket.

[jofreder]

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.

This would be ok but for those that are not as Computer savvy may have difficulty dealling with installing IIS, PHP ,apache or what ever your OS supports to host web apps. It might limit your client list.

[mjfletcher]

Originally Posted by jofreder

This would be ok but for those that are not as Computer savvy may have difficulty dealling with installing IIS, PHP ,apache or what ever your OS supports to host web apps. It might limit your client list.

Valid point, and easily handled. Theres many embedded http servers that can be included as part of the package (easiest way to go), as well as XAMPP, a distribution of the apache webserver that includes php, mysql, and perl all in one package that auto configures itself making installation no different than installing any other program.

[whyzdom]

Mac Version!

[andrewjs18]

Originally Posted by mjfletcher

Valid point, and easily handled. Theres many embedded http servers that can be included as part of the package (easiest way to go), as well as XAMPP, a distribution of the apache webserver that includes php, mysql, and perl all in one package that auto configures itself making installation no different than installing any other program.

they're ISP should allot ftp space...so they could upload it there and run it that way.