Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: Re: OT: Database Certificate == 'Good Career Move'?

by Jenda (Abbot)
on Nov 28, 2002 at 00:04 UTC ( [id://216210]=note: print w/replies, xml ) Need Help??


in reply to Re: OT: Database Certificate == 'Good Career Move'?
in thread OT: Database Certificate == 'Good Career Move'?

If I would be hiring a programmer I would be most interested in his code. Not what cool sites/programs did he work on, what cool pages does he have to show but ... is his code readable? Does he handle errors carefully? Is the application multi-user safe? (Sure , you can't prove it is, but sometimes it's dead easy to see it is not.) If something breaks does the admin/developer get enough information to find and fix the problem?

Show me your code and I know who you are.

Jenda

P.S.: I've seen quite a few webbased applications that appeared to be working ... but only because the author ignored all errors and reported success even if the action blew up and because we were lucky and the race condition did not happen just as we were looking.

A great example was the project I'm spending most of my time now when we got it to fix and extend. Stored procedures did not care whether their commands succeeded, middle tier ignored errors comming from the database, ASPs ignored errors from the middle tier, most variable names were just one letter, ...

And the multiuser safety? Well ... there was a table with an Identity field (MS SQL, autogenerated ID), instead of inserting the row and getting the generated ID they

  1. connected to the DB
  2. fetched the max(ID)
  3. disconnected
  4. incremented it (in the ASP!)
  5. did some unrelated stuff to increase the likelihood of problems
  6. connected to the DB
  7. tried to forcefully insert the new row with this ID (using SET IDENTITY_INSERT ON)
  8. disconnected
  9. ignored the result of the action and reported success

I could not kill them ... they were too far.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://216210]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2024-03-29 13:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found