Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
I only discovered there were some procedures on the DB I've worked with for nearly 3 years. ...
Everything was business logic until I found that there was no explanation for the behavior of one of the tables or what the hell could be making ... "oh shit is it?"
That's more of a documentation / onboarding issue, but it was amusing.
Word has it Lee Holloway who founded Cloudflare actually had huge amounts of logic in stored procedures that encapsulated a great deal of what Cloudflare did in the early days of that company. -
@N00bPancakes
Do you know any link where I can look at the database complete design as reference?
I remember that there is such website but my memory seem to be failing me. -
@mr-user Sorry I do not know.
-
@N00bPancakes Back then stored procedures were significantly faster.
I wanted to know what is the worst mistake you make on database.
I have actually implements the logic of token access control on database and not on business logic layer.
The database have a login procedure which accept username and password. That login procedure actually hash the password and try to authenticate user.
If it is a correct user , it generate a token. In other to use other procedure on database , you must provide a token. By using that token , the procedure know who is it and what permission is granted to that user.
question
database mistake