Some people complain about stored procedures as bad because they inject business logic into the database.
My answer to this is that then the stored procedures are used the wrong way.
Stored procedures should be used to get data in and out the database. Used this way they represent the holes in and out of the database.
Name the stored procedures cunningly and you have an easy way to find the only ways to insert data into the customer table, the only way to update the order table and only ways to select multiple rows from role.
I have not found the perfect naming scheme. Anyone?
skip to main |
skip to sidebar
http://www.selfelected.com/
Experience about programming and architecture
Musings about delivering and quality
Findings about projects and people
THIS SITE HAS MOVED
COMMENTS ARE DISABLED AND ARTICLES ARE COPIED AND EVERYTHING IN THE PRESENT AND FUTURE WILL HAPPEN ON
http://www.selfelected.com/
Software patents halts innovation.
Please sign the petition for the sake of all of us.
Credits
Go to ms K for keeping me sane.
Go to mr J for the laughs and the truth.
Go to ms B for naming this blog.
Go to mr J for the laughs and the truth.
Go to ms B for naming this blog.
About Me
- LosManos
- Göteborg, Sweden
- Developing solutions mainly on the Windows platform during my working hours. Hoping to make the world a better place the rest.
My other projects
LIUSClasses
Handy dotnet functions, unit tested and proven in production
EarClip
Keep you bookmarks online - 0.6
Kopain
Simple editor with a tree navigator - 0.1
Selfelected ideas
Another blog which just contains ideas.
Handy dotnet functions, unit tested and proven in production
EarClip
Keep you bookmarks online - 0.6
Kopain
Simple editor with a tree navigator - 0.1
Selfelected ideas
Another blog which just contains ideas.
Heroes, in alphabetical order
Tools
Agent Ransack
A good file searcher that is both simple to use and have regular expression for the more advanced user. It of course searches the folders that Micorosft's built-in avoids. Cost free.
Autohotkey
Global hotkeys. A simple scriptable solution to utilise the windows button. Start an application or simulate the keyboard with a simple keystroke. Open source.
DPack
A must-have tool for VSNet2003/5/8. The functionality I use the most is alt-M to list and easily search through methods in the active file and alt-U to open files without having to search for them in the project explorer. Free.
Keepass
This is a password storer. It is open source to make sure the encryption is valid. I use the older 1.x version since it has the same database as the Windows Mobile client. This makes it possible for me to always have my passwords at hand.
Keynote
A simple hierarichal text editor. Bring it up with a keystroke, jot down your notes, let it vanish. Open source.
c# code format
A gratis solution for CSSing source code for use in blogs like this.
Notepad2
An open source text editor. It is not the best but it replaces Notepad in a correct way and hence gets rid of the bugs in Notepad.
Pastebin
A free site for discussing code instead of pasting it back and forth in chat or email. Easier to try than to explain.
PDFCreator
I you want to create PDF documents but don't want to spend money on Adobe's bloated solution do use this open source PDF printer. It installs a printer and when printed to creates a PDF document on your hard disk. Works for any application that can print.
Spamgourmet
A free site for one time email addresses.
Winmerge
A nice diff tool. Compares files and directories. Much better than Windiff/Sourcesafe. Open source.
A good file searcher that is both simple to use and have regular expression for the more advanced user. It of course searches the folders that Micorosft's built-in avoids. Cost free.
Autohotkey
Global hotkeys. A simple scriptable solution to utilise the windows button. Start an application or simulate the keyboard with a simple keystroke. Open source.
DPack
A must-have tool for VSNet2003/5/8. The functionality I use the most is alt-M to list and easily search through methods in the active file and alt-U to open files without having to search for them in the project explorer. Free.
Keepass
This is a password storer. It is open source to make sure the encryption is valid. I use the older 1.x version since it has the same database as the Windows Mobile client. This makes it possible for me to always have my passwords at hand.
Keynote
A simple hierarichal text editor. Bring it up with a keystroke, jot down your notes, let it vanish. Open source.
c# code format
A gratis solution for CSSing source code for use in blogs like this.
Notepad2
An open source text editor. It is not the best but it replaces Notepad in a correct way and hence gets rid of the bugs in Notepad.
Pastebin
A free site for discussing code instead of pasting it back and forth in chat or email. Easier to try than to explain.
PDFCreator
I you want to create PDF documents but don't want to spend money on Adobe's bloated solution do use this open source PDF printer. It installs a printer and when printed to creates a PDF document on your hard disk. Works for any application that can print.
Spamgourmet
A free site for one time email addresses.
Winmerge
A nice diff tool. Compares files and directories. Much better than Windiff/Sourcesafe. Open source.
Labels
- architecture (15)
- code (7)
- database (9)
- documentation (7)
- fail-at-once (6)
- innovation (1)
- misc (36)
- not-yet-fully-invented (16)
- project (25)
- solid code (31)
- strong typing (4)
- tip (22)
- wishlist (4)
1 comment:
Good day, excellent blog!
I consider stored procedures are a good way to keep your application clean by storing the data access layer logic and operations right in where the data is. In the other hand, keeping your code in 2 different environments would require one and the full developer team to be disciplined and consistent with parameters, procedures naming, data retrieval and good testing.
For me a good notation would be to use, first, the entity to which the procedure is related to, then the functionality(ies) and finally the parameters (consider Hungarian notation as well).
form_add_customer
form_add_order
form_update_order_by_customerName
form_update_order_by_id
user_add
user_update_password
In my opinion this is a fast and clear way to find where is the procedure and find out what in God's name it is supposed to do.
M.-
Post a Comment