Category Archives: SQL

WSO2 Releases Goernance Registry 3.0.1, ESB 2.1.1, WSAS 3.1.1, IS 2.0.1 AND Mashup Server 2.0.0

Posted on October 13, 2009 by dimuthu

WSO2 announced an another round of release of their famous SOA products. WSO2 Governance Registry 3.0.1 WSO2 ESB 2.1.1 WOS2 Web Services Application Server (WSAS) 3.1.1 WSO2 Identity Server (IS) 2.0.1 WSO2 Mashup Server 2.0.0 Although the version numbers say … Continue reading →

Posted in carbon, esb, Governance, Governance Registry, mashup server, SOA, SQL, web services, wsas, wso2 | Tagged , , , , , , , | 2 Comments

Making Good SOA Great

Posted on January 31, 2009 by dimuthu

WSO2 is preparing for the first major release of their enterprise java product series after adapting the OSGI technology. You can already try out the betas from the wso2.org site. WSO2 Web Services Application Server (WSAS) WSO2 Enterprise Service Bus … Continue reading →

Posted in carbon, DataServices, SQL, Tutorial/Guide, web services, wso2 | Tagged , , , , , | Leave a comment

Article Introducing PHP Data Services

Posted on January 5, 2009 by dimuthu

Now you can view the article I wrote titling “Introduction to PHP Data Services“. There I explain how you can design and implement Data Services in PHP using WSF/PHP Data Services Library. This article covers, Designing your Data Service API. … Continue reading →

Posted in database, DataServices, design, php, REST, RESTful, SOA, SQL, Tutorial/Guide, web services, WSDL, wsf/php, wso2, xml | Tagged , , , , , , , , , , , | Leave a comment

Data Services Best Practices

Posted on December 18, 2008 by dimuthu

In simple term, data services are exposing data as web services. Anyway it is not a complete definition. Actually there are situations where we use data services not only to read data, but also to create, update or delete data. … Continue reading →

Posted in data services, DataServices, design, php, SOA, SQL, Tutorial/Guide, web services, wso2 | Tagged , , , , , | 8 Comments

PHP Data Services with PostgreSQL

Posted on December 7, 2008 by dimuthu

LAMP (Linux + Apache + Mysql + PHP) stack powers many servers in the Internet today. For a LAMP  server, PostgreSQL could be the first alternative to Mysql. Similar to PHP + MySQL,  PHP + PostgreSQL too can be easily … Continue reading →

Posted in 2 minutes guide, DataServices, php, REST, SOA, SQL, Tutorial/Guide, web services, WSDL, wsf/php, wso2 | Tagged , , , , , , | 2 Comments

Steps to Convert a SQL Query to a Data Service

Posted on November 27, 2008 by dimuthu

With WSF/PHP Data Service library, you can convert a SQL query to a Data Service very easily in few steps. Decide your SQL query first, For the query you may require some input parameters, and you have to decide what … Continue reading →

Posted in DataServices, php, SOA, SQL, Tutorial/Guide, web services, wsf/php, wso2 | Tagged , , , , | Leave a comment

RESTful URL Mapping in WSF/PHP

Posted on November 16, 2008 by dimuthu

In a RESTful design, choose of URLs for resources are really important. The URL uniquely represents a resource. Service consumers can change some parts in the URL to access different other resources. So it is clear that the URL consists … Continue reading →

Posted in DataServices, php, REST, RESTful, SQL, Tutorial/Guide, web services, wsf/php, wso2 | Tagged , , , , , , | 1 Comment

Use of MySQL ‘GROUP BY’ to Derive Statistics

Posted on November 6, 2008 by dimuthu

We use ‘GROUP BY’ SQL construct to query the data with aggregating some rows according to a field. For an example say if your blog database store your blogs in a table call ‘Blog’ and it has ‘Date’ as a … Continue reading →

Posted in DataServices, drupal, SQL, Tutorial/Guide | Tagged , , | Leave a comment