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.

"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.

Join the newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags Yahooyql

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Paul Krill

InfoWorld
Show Comments

Essentials

Mobile

Exec

Budget

Back To Business Guide

Click for more ›

Brand Post

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill

MSI GT75 TITAN

I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Featured Content

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?