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

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

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

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

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

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

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

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

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