Click here to Skip to main content
15,889,335 members

The Insider News

   

The Insider News is for breaking IT and Software development news. Post your news, your alerts and your inside scoops. This is an IT news-only forum - all off-topic, non-news posts will be removed. If you wish to ask a programming question please post it here.

Get The Daily Insider direct to your mailbox every day. Subscribe now!

 
GeneralRe: The return of the Unix wars? Pin
PIEBALDconsult3-May-12 11:01
mvePIEBALDconsult3-May-12 11:01 
NewsEFF Coders' Rights List Pin
AspDotNetDev3-May-12 8:06
protectorAspDotNetDev3-May-12 8:06 
NewsedX - Education of the future Pin
Alexander DiMauro3-May-12 4:45
Alexander DiMauro3-May-12 4:45 
NewsMicrosoft opens New York research lab, hires mainly Yahoo researchers Pin
atbennett3-May-12 4:07
atbennett3-May-12 4:07 
NewsA Coder Interview With Matthew Brand Pin
Terrence Dorsey2-May-12 10:37
sitebuilderTerrence Dorsey2-May-12 10:37 
NewsThree things you should never put in your database Pin
Terrence Dorsey2-May-12 10:36
sitebuilderTerrence Dorsey2-May-12 10:36 
GeneralRe: Three things you should never put in your database Pin
PIEBALDconsult2-May-12 12:17
mvePIEBALDconsult2-May-12 12:17 
GeneralRe: Three things you should never put in your database Pin
AspDotNetDev2-May-12 17:26
protectorAspDotNetDev2-May-12 17:26 
I don't fully agree with any of them.

1) If the files are of a sensitive nature, store them in a database. It simplifies the security model. Also, if backups are an issue, store them in a different database than the one you backup more frequently. Other files that don't require security (e.g., images) can obviously go wherever, though a CDN is ideal.

2) At my job, we sometimes have to restart the servers because of various issues. Storing session to a database makes it possible for users to retain their session state (so they don't, for example, have to log in again). Storing session out of process might work in some cases, but not if the machine must be restarted. Still, would be nice if we didn't have such finicky servers. *grumbles*

3) I love logging. At my last company, we HAD to log pretty much everything so the data could be audited later. Databases are the perfect place to store logs. If performance is an issue, one can easily store logs on a different database that may even be on a different server. And one should of course abstract out the medium the logs are stored to, so that medium can be changed later. Some employees at my company decided to email every error that happens on our site, but they are so numerous that they are ignored and email is hardly useful for aggregating data (would be nice so we could show which of our servers are most error prone). If we had a proper abstration in place, we could just switch from email to a database. And if we started to log a ton, we could use that abstraction to defer to a queue that bulk inserts into a database.

GeneralRe: Three things you should never put in your database Pin
PIEBALDconsult3-May-12 3:22
mvePIEBALDconsult3-May-12 3:22 
GeneralRe: Three things you should never put in your database Pin
AspDotNetDev3-May-12 7:48
protectorAspDotNetDev3-May-12 7:48 
GeneralRe: Three things you should never put in your database Pin
PIEBALDconsult4-May-12 8:41
mvePIEBALDconsult4-May-12 8:41 
GeneralRe: Three things you should never put in your database Pin
AspDotNetDev4-May-12 8:52
protectorAspDotNetDev4-May-12 8:52 
GeneralRe: Three things you should never put in your database Pin
Not Active3-May-12 2:03
mentorNot Active3-May-12 2:03 
GeneralDon't take it seriously... Pin
Dave Kerr2-May-12 22:57
mentorDave Kerr2-May-12 22:57 
GeneralI'm right. I'm always right. For every situation. Pin
Chris Maunder3-May-12 7:16
cofounderChris Maunder3-May-12 7:16 
GeneralRe: I'm right. I'm always right. For every situation. Pin
AspDotNetDev3-May-12 7:36
protectorAspDotNetDev3-May-12 7:36 
NewsBest Practices Exist for a Reason Pin
Terrence Dorsey2-May-12 10:36
sitebuilderTerrence Dorsey2-May-12 10:36 
GeneralRe: Best Practices Exist for a Reason Pin
PIEBALDconsult2-May-12 12:06
mvePIEBALDconsult2-May-12 12:06 
GeneralRe: Best Practices Exist for a Reason Pin
AspDotNetDev2-May-12 17:38
protectorAspDotNetDev2-May-12 17:38 
GeneralRe: Best Practices Exist for a Reason Pin
Not Active3-May-12 2:09
mentorNot Active3-May-12 2:09 
GeneralRe: Best Practices Exist for a Reason Pin
chuckforest3-May-12 2:35
chuckforest3-May-12 2:35 
NewsCSS: The Good Parts Pin
Terrence Dorsey2-May-12 10:35
sitebuilderTerrence Dorsey2-May-12 10:35 
NewsMy Coding Style and Guidelines Pin
Terrence Dorsey2-May-12 10:34
sitebuilderTerrence Dorsey2-May-12 10:34 
NewsViewport Sized Typography Pin
Terrence Dorsey2-May-12 10:33
sitebuilderTerrence Dorsey2-May-12 10:33 
NewsFinally, a Shark With a Laser Pin
Terrence Dorsey2-May-12 10:33
sitebuilderTerrence Dorsey2-May-12 10:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.