Database procedures and functions vs web services

In our development team we have:

  • 4 developers
  • one application uses PHP and database Microsoft SQL Server 2008r2, except one using PowerBuilder instead of PHP and one using MySql instead of Microsoft SQL Server
  • All applications are database-centered, some of them are for general public, some are not.

Question is: for the procedures and functions shared by all applications, what does it make most sense to use, database procedures/functions or web services? We could not find an agreement within the team.

Whatever you answer, please explain the reasons.

Answers


Webservices and Database Proc/Functions are two entirely different things. Webservices are the services over the web, mainly used when a client and a server interact and client interacts with the server through web or HTTP or any other protocol. Database proc/func - are created to interact with a login to a DB server.

In your case, if all the application are in the same domain... then you dont need to access through webservices and also it is a lot of overhead. You can create a common DB server , where you can keep these proc/func and can be consumed by all.


Need Your Help

Getting next results

php mysql sql sorting order

I have a table that is something like the one below.

ExtJS4 - Adding multiple model to a store then calling store.sync does not save all the data

extjs extjs4 extjs4.2

Good day, I am building a web application using ExtJS4 and I have a part there where I create multiple models then add them to a store then sync the store. However, upon calling store.sync(), I see a

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.