Dear group,
A mysql wrapper class, which just uses the CRUD operations for large scale
php development.
Is the same advisable for the mysql stored procedure? Following is a link I
got from
search http://www.phpclasses.org/browse/package/1615.html. All it does is do
the ADD/EDIT/DELETE/View
in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure?
The sp not only
does normal CRUD but implements business logic too. Advice me, thanks
--
sathyashrayan AT GmAAil (DOT) com,
TN,chennai,India. 7 1800
"sathyashrayan" <sa***********@ATGmaIl.comwrote in message
news:48***********************@news.sunsite.dk...
Dear group,
A mysql wrapper class, which just uses the CRUD operations for large scale
php development.
Is the same advisable for the mysql stored procedure? Following is a link
I got from
search http://www.phpclasses.org/browse/package/1615.html. All it does is
do the ADD/EDIT/DELETE/View
in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure?
The sp not only
does normal CRUD but implements business logic too. Advice me, thanks
stored procedures are NOT scalable with application development. NEVER
implement business logic IN A DATABASE! not only will you find yourself
unable to maintain your application because validation is all over the
place, but for the same reason, you will find it virtually impossible to
make head-way in fixing bugs or adding enhancements. further, you are
requiring your developers to know MySql language constructs beyond cursory,
they will have to likewise know PHP. while the latter is a given, you will
find it harder to employ those who know both equally well...and that will
cost you.
imo, that consideration trumps your question about implementing stored
procedures using crud...save the amusement i get from associating the one
(sp's) with the literal interpretion of my feeling on the same (i.e. sp's
are crud!). don't do it my brutha.
:)
"Barry" <no****@example.comwrote in message
news:Y8************@newsfe07.lga...
>
"sathyashrayan" <sa***********@ATGmaIl.comwrote in message
news:48***********************@news.sunsite.dk...
>Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from search http://www.phpclasses.org/browse/package/1615.html. All it does is do the ADD/EDIT/DELETE/View in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure? The sp not only does normal CRUD but implements business logic too. Advice me, thanks
stored procedures are NOT scalable with application development. NEVER
implement business logic IN A DATABASE! not only will you find yourself
unable to maintain your application because validation is all over the
place, but for the same reason, you will find it virtually impossible to
make head-way in fixing bugs or adding enhancements. further, you are
requiring your developers to know MySql language constructs beyond
cursory, they will have to likewise know PHP. while the latter is a given,
you will find it harder to employ those who know both equally well...and
that will cost you.
imo, that consideration trumps your question about implementing stored
procedures using crud...save the amusement i get from associating the one
(sp's) with the literal interpretion of my feeling on the same (i.e. sp's
are crud!). don't do it my brutha.
:)
Thanks for the reply. But any information for Sp just talks about the
besiness logic in the back end along with other things. For Example have the
wiki http://en.wikipedia.org/wiki/Stored_procedure in the para
"Simplification of data management"... But wiki is not the final though..Am
I missing something basic?
"sathyashrayan" <sa***********@ATGmaIl.comwrote in message
news:48***********************@news.sunsite.dk...
>
"Barry" <no****@example.comwrote in message
news:Y8************@newsfe07.lga...
>> "sathyashrayan" <sa***********@ATGmaIl.comwrote in message news:48***********************@news.sunsite.dk. ..
>>Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from search http://www.phpclasses.org/browse/package/1615.html. All it does is do the ADD/EDIT/DELETE/View in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure? The sp not only does normal CRUD but implements business logic too. Advice me, thanks
stored procedures are NOT scalable with application development. NEVER implement business logic IN A DATABASE! not only will you find yourself unable to maintain your application because validation is all over the place, but for the same reason, you will find it virtually impossible to make head-way in fixing bugs or adding enhancements. further, you are requiring your developers to know MySql language constructs beyond cursory, they will have to likewise know PHP. while the latter is a given, you will find it harder to employ those who know both equally well...and that will cost you.
imo, that consideration trumps your question about implementing stored procedures using crud...save the amusement i get from associating the one (sp's) with the literal interpretion of my feeling on the same (i.e. sp's are crud!). don't do it my brutha.
:)
Thanks for the reply. But any information for Sp just talks about the
besiness logic in the back end along with other things. For Example have
the wiki http://en.wikipedia.org/wiki/Stored_procedure in the para
"Simplification of data management"... But wiki is not the final
though..Am I missing something basic?
yes...everything i just said. and, wiki is NOT a good reference on
application architecture.
sathyashrayan wrote:
"Barry" <no****@example.comwrote in message
news:Y8************@newsfe07.lga...
>"sathyashrayan" <sa***********@ATGmaIl.comwrote in message news:48***********************@news.sunsite.dk. ..
>>Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from search http://www.phpclasses.org/browse/package/1615.html. All it does is do the ADD/EDIT/DELETE/View in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure? The sp not only does normal CRUD but implements business logic too. Advice me, thanks
stored procedures are NOT scalable with application development. NEVER implement business logic IN A DATABASE! not only will you find yourself unable to maintain your application because validation is all over the place, but for the same reason, you will find it virtually impossible to make head-way in fixing bugs or adding enhancements. further, you are requiring your developers to know MySql language constructs beyond cursory, they will have to likewise know PHP. while the latter is a given, you will find it harder to employ those who know both equally well...and that will cost you.
imo, that consideration trumps your question about implementing stored procedures using crud...save the amusement i get from associating the one (sp's) with the literal interpretion of my feeling on the same (i.e. sp's are crud!). don't do it my brutha.
:)
Thanks for the reply. But any information for Sp just talks about the
besiness logic in the back end along with other things. For Example have the
wiki http://en.wikipedia.org/wiki/Stored_procedure in the para
"Simplification of data management"... But wiki is not the final though..Am
I missing something basic?
Forget what Barry said. He's still in the 1980's, with no idea what
he's talking about. SP's were designed to implement business logic -
and are excellent for this purpose.
I've been using SP's for well over 20 years now (starting with DB2 on
mainframes), and they work great. But sometime I do find them to be
overused. You shouldn't, for instance, use them for something which can
be done in a simple SQL statement. They can, however, be used for more
complex data validation than could be done with other methods such as
foreign keys. In MySQL, they could also be used to emulate recursive
SQL (which I hope MySQL will get some day - talk about powerful!).
But there's no need to emulate SP's in PHP. MySQL supports them now.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp. js*******@attglobal.net
==================
sathyashrayan wrote:
"Barry" <no****@example.comwrote in message
news:Y8************@newsfe07.lga...
>"sathyashrayan" <sa***********@ATGmaIl.comwrote in message news:48***********************@news.sunsite.dk. ..
>>Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from search http://www.phpclasses.org/browse/package/1615.html. All it does is do the ADD/EDIT/DELETE/View in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure? The sp not only does normal CRUD but implements business logic too. Advice me, thanks
stored procedures are NOT scalable with application development. NEVER implement business logic IN A DATABASE! not only will you find yourself unable to maintain your application because validation is all over the place, but for the same reason, you will find it virtually impossible to make head-way in fixing bugs or adding enhancements. further, you are requiring your developers to know MySql language constructs beyond cursory, they will have to likewise know PHP. while the latter is a given, you will find it harder to employ those who know both equally well...and that will cost you.
imo, that consideration trumps your question about implementing stored procedures using crud...save the amusement i get from associating the one (sp's) with the literal interpretion of my feeling on the same (i.e. sp's are crud!). don't do it my brutha.
:)
Thanks for the reply. But any information for Sp just talks about the
besiness logic in the back end along with other things. For Example have the
wiki http://en.wikipedia.org/wiki/Stored_procedure in the para
"Simplification of data management"... But wiki is not the final though..Am
I missing something basic?
I should also add, if you want more info on SP's in MySQL, I suggest you
check out comp.databases.mysql. Instead of those who only think they
are experts but don't really know much, you'll find real database
experts there.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp. js*******@attglobal.net
==================
"Jerry Stuckle" <js*******@attglobal.netwrote in message
news:g5**********@registered.motzarella.org...
sathyashrayan wrote:
>"Barry" <no****@example.comwrote in message news:Y8************@newsfe07.lga...
>>"sathyashrayan" <sa***********@ATGmaIl.comwrote in message news:48***********************@news.sunsite.dk.. . Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from search http://www.phpclasses.org/browse/package/1615.html. All it does is do the ADD/EDIT/DELETE/View in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure? The sp not only does normal CRUD but implements business logic too. Advice me, thanks stored procedures are NOT scalable with application development. NEVER implement business logic IN A DATABASE! not only will you find yourself unable to maintain your application because validation is all over the place, but for the same reason, you will find it virtually impossible to make head-way in fixing bugs or adding enhancements. further, you are requiring your developers to know MySql language constructs beyond cursory, they will have to likewise know PHP. while the latter is a given, you will find it harder to employ those who know both equally well...and that will cost you.
imo, that consideration trumps your question about implementing stored procedures using crud...save the amusement i get from associating the one (sp's) with the literal interpretion of my feeling on the same (i.e. sp's are crud!). don't do it my brutha.
:) Thanks for the reply. But any information for Sp just talks about the besiness logic in the back end along with other things. For Example have the wiki http://en.wikipedia.org/wiki/Stored_procedure in the para "Simplification of data management"... But wiki is not the final though..Am I missing something basic?
Forget what Barry said. He's still in the 1980's, with no idea what he's
talking about. SP's were designed to implement business logic - and are
excellent for this purpose.
uhm, no, i don't think so. now...here's where providing a cite would do you
well, jerry. simply declaring what you will, no matter how narcasistic you
are, doesn't make it so.
I've been using SP's for well over 20 years now (starting with DB2 on
mainframes), and they work great.
said the man with no clients.
"sathyashrayan" <sa***********@ATGmaIl.comwrote in message
news:48***********************@news.sunsite.dk...
>
"Barry" <no****@example.comwrote in message
news:Y8************@newsfe07.lga...
>> "sathyashrayan" <sa***********@ATGmaIl.comwrote in message news:48***********************@news.sunsite.dk. ..
>>Dear group, A mysql wrapper class, which just uses the CRUD operations for large scale php development. Is the same advisable for the mysql stored procedure? Following is a link I got from search http://www.phpclasses.org/browse/package/1615.html. All it does is do the ADD/EDIT/DELETE/View in stored procedure file. Any more links possible?
Is it necessary to go for active data table for mysql stored procedure? The sp not only does normal CRUD but implements business logic too. Advice me, thanks
stored procedures are NOT scalable with application development. NEVER implement business logic IN A DATABASE! not only will you find yourself unable to maintain your application because validation is all over the place, but for the same reason, you will find it virtually impossible to make head-way in fixing bugs or adding enhancements. further, you are requiring your developers to know MySql language constructs beyond cursory, they will have to likewise know PHP. while the latter is a given, you will find it harder to employ those who know both equally well...and that will cost you.
imo, that consideration trumps your question about implementing stored procedures using crud...save the amusement i get from associating the one (sp's) with the literal interpretion of my feeling on the same (i.e. sp's are crud!). don't do it my brutha.
:)
Thanks for the reply. But any information for Sp just talks about the
besiness logic in the back end along with other things. For Example have
the wiki http://en.wikipedia.org/wiki/Stored_procedure in the para
"Simplification of data management"... But wiki is not the final
though..Am I missing something basic?
i was perusing this topic this morning and thought you'd like to read some
thoughts that are counter to stored procedure use defined on wiki...whos
author, i believe, has very little experience in system architecture - at
least at the data layer. anyway, forget the guy in the link refers to .net
and asp. the issues discussed are language independent. also, notice how he
echos two of the points i made in my original response to you. http://www.ytechie.com/2008/05/store...alability.html
despite what jerry's isolated view is - he himself has no public web site -
they are those with actual experience working with volumes of traffic and
data who would know best. if you google 'do "stored procedures" scale', you
will find one u.s. ton of those taking issue with jerry's advice. jerry
simply likes to chime in and bash as many others as possible along the way.
as you can tell by his thousands of posts per day, jerry has no job nor life
outside of usenet. he looks to be 65 based on his picture from the net. i
doubt he's employed. he probably picks up a programming bone thrown his way
every once in a while. again, though, given his 'presence' here the last
bone was some time ago.
cheers. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Luc Foisy |
last post by:
Last week many of our server and client servers had a power problem. Not =
quite sure how the servers were handled, wasn't on site, but I don't =
think some of these servers got shut down...
|
by: Mark Everett |
last post by:
Hi,
I am currently running out of space on one of my database servers. Is
it possible to move the relevant files for tables onto another drive
and instuct MySql to use both folders for it's...
|
by: tangus via DotNetMonster.com |
last post by:
Hello all, I'm really struggling with getting some Active Directory code to
work in ASP.NET. Can you please provide assistance? I am executing the
following code:
Dim enTry As DirectoryEntry =...
|
by: eieiohh |
last post by:
MySQL 3.23.49
PHP 4.3.8
Apache 2.0.51
Hi All!
Newbie..
I had a CRM Open Source application installed and running. Windows Xp
crashed. I was able to copy the contents of the entire hard...
|
by: jpr |
last post by:
Hello, I have a problem with my database and need some help.
My database has a main menu named MENU which allows to access all the
different forms of the program I am trying to develop. One of...
| |
by: jrs_14618 |
last post by:
Hello All,
This post is essentially a reply a previous post/thread
here on this mailing.database.myodbc group titled:
MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode
I was...
|
by: bill |
last post by:
I have been "Googling" for about an hour and am turning up squat! I just
started receiving this error when trying to log into a MS Access database
from a vb .net web application. Recycling IIS...
|
by: Vio |
last post by:
Hello everyone,
i currently a beginner in php.
I want to ask about Win2003 Active Directory users. Is it possible to
retrieve Win2003 AD (just username & password) with php.
I'm currenty...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |