July 08, 2009

Yahoo boosts Web data joiner

YQL gets the ability to write and modify data as Yahoo adds 'missing' SQL verbs

Yahoo is enhancing on Wednesday its Web service API for querying and joining data across any Web source or service on the Web, with the addition of capabilities to write and modify data on Web services.

Specifically, the Yahoo Developer Network is offering a feature for the YQL (Yahoo Query Language) that extends the platform by adding "write" capabilities. YQL lets developers query and join data across a Web source or service on the Web.

[ In April, Yahoo also extended YQL with an "execute" function. ]

"Using our YQL Web service, apps run faster with fewer lines of code and a smaller network footprint. YQL uses a SQL-like language because it is a familiar and intuitive method for developers to access data. YQL treats the entire Web as a source of table data, enabling developers to select * from internet," said Jonathan Taylor, of the YQL team, in a blog post.

Wednesday's extensions add "missing" SQL verbs to YQL, including Insert, Update, and Delete. "This enables YQL Open Data Tables to insert new Twitter status messages, not just list them; to add new comments to a blog as well as read them; to store data in a remote database; to Insert Into Internet," Taylor said. Open Data Tables in YQL allow developers to use their own table definitions and bind to any data source using SQL-like syntax and fetch data.

Featuring a SQL-like language, YQL debuted in October and treats the Web as a source of table data. Web services can be accessed using a SQL-like language instead of using typical programmatic access, Yahoo said. YQL serves as a command line version of Yahoo Pipes,  which is a composition tool for mashing up and aggregating content from around the Web. The goal of YQL is to make data from Yahoo and the Internet accessible via a single common interface.

Paul Krill is an editor at large at InfoWorld.
Close

On Twitter now

Application development

Powered by Twitter

White Paper

D2D Virtual Tape Library Replication Primer

This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.

Download now »

White Paper

An Alternative to Virtualization for Datacenter Cost Savings

Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.

Download now »

White Paper

Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network

The emergence of WLANs has created a new breed of security threats to enterprise networks.

Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation

Download now »

White Paper

Bringing the Edge to the Data Center

Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.

Download now »

Sign up to receive InfoWorld Resource Alerts

Subscribe to the Developer World Newsletter

Receive a weekly roundup about the art and science of software development.

©1994-2009 Infoworld, Inc.