Re: Best way to write logs
SkyCoder,
If security is an issue then the dtabase is the way to go.
Re: Best way to write logs
I agree with randem. Db tables are the way to go for this issue and that is what we use. I'm a commerical developer in the Insurance industry and we use Db tables for everything.
We use to them to store error trapped runtime errors and we use them to store personal application preferences (we used to use the registry for this, but many companies these days are rolling out computers to their employees with the registry locked down so we had to devise another method for storing user configurable preferences).
Re: Best way to write logs
I also agree...
User preferences, user logs - tracking time in/time out of appliations - where they connected from - number of rows affected...
We do everything with tables. If we are going to load data from a text file into our database, we first load it into a "staging" table - we then process that staging data into transactions in the real data tables.
If we are going to produce W2's or 1099's or DIRECT DEPOSIT data for a bank, we first load the data into "fixed width column" tables - then simply create text files from that.
The database has a complete history of every process in and process out.
The only thing we don't store in the DB are images of students (for example) - we store the path to the filename. We drew the line at that point...
Re: Best way to write logs
Quote:
Originally Posted by szlamany
The only thing we don't store in the DB are images of students (for example) - we store the path to the filename. We drew the line at that point...
That is interesting. We do store accident scene photos (for those of you who don't know, I am a commerical developer in the Risk Management industry), and scanned images of police reports as well as a varity of other scanned documents relating to a claim.
As a point of curiosity, why did you decide not to store student photos?
Re: Best way to write logs
Quote:
Originally Posted by Hack
As a point of curiosity, why did you decide not to store student photos?
They change every year for one thing...
Also - with a 20 building WAN, we can chose to put them on a server local to the building and have the PATH in the DATABASE know that each building is on a different server...
Re: Best way to write logs
Quote:
Originally Posted by szlamany
They change every year for one thing...
Da...that makes sense...you are dealing with students after all.