Using Stored Procedures Instead of Inline SQL

sabkaraja · Post by **sabkaraja** » 10 Aug 2005, 14:35

I have tried to understand and modify some parts of the mantis bugtracking system.

What I felt intimidating is the fact that the whole code is just in the page.

Isnt it time that the sql be moved from the code into the db as stored procedures?

It will be easy for developers to customise the system. We may be able to see an increase in the features

thraxisp · Post by **thraxisp** » 10 Aug 2005, 19:43

That requires MySQL 5.1 which is just being released. Further, I don't know if all databases support the same syntax and semantics for stored procedures. It could open up a mess with database compatibility.

Post by **vboctor** » 10 Aug 2005, 22:27

At the moment the approach we are taking is to have all the queries in the APIs, rather than in the pages. If there are any queries in the page, then it should be moved the the APIs.

Maybe one day we will use stored procedures, but I don't see this happeing soon.

Regards,
Victor
Subscribe to Mantis blog
http://www.futureware.biz

sabkaraja · Post by **sabkaraja** » 11 Aug 2005, 11:47

cool.

Dont mind if the data and logic are separated in API. I just mentioned SP as a means).

I believe, once data is separated from view, more and more people will try playing with customisation and benefit the community (myself included!)

Cheers

Speaking up for the lesser mortals (developers)