Site Sponsors:
PHP CRUD - New Project 
Decided to share this one:

https://sourceforge.net/projects/phpcrud/

Today many say that "CRUD" stands for "Create Retrieve Update and Delete." While fine for an SQL mindset, many old-timers got used to the acronym standing for "Create READ Update Delete" way back in the 1970's. Indeed, the term dates back even farther than ISAM. ...

By way of a handy completeness check-moniker however (the intended use?), the pattern works much the same for both camps. --The only difference is a record-oriented, rather than a QUERY oriented, mentality; Enjoying an expected result set of 1:1, -v- 1:*... or the difference between knowing what to expect, and perhaps having WAY too many (*) data coming back to process / secure effectively.

When designing software, be sure to know the difference. Why? Because while the classic 1:1 usage is easy and succinct, supporting the modern variant will imply many more activities. Discussions over things such as pre-queries, limiting queries, session limits, timeouts, roles, SQL injection attacks, view creation (etc.) invariably have to be considered. Activities that will consume not only design & implementation time, but data-processing resources, as well.

(Note: If you have followed a permalink to this article, then you will not have noticed a subsequent example. -Here is an interesting example.)

Enjoy,

-Rn

(*) Data is plural - Sounds odd, don't it? :)


[ view entry ] ( 4389 views )   |  permalink  |  related link

<<First <Back | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | Next> Last>>