New SSWUGtv Show
Avoiding surprises with your SQL Server configuration… who is changing what? Raj Sabhlok of ManageEngine on the show to talk about more holistic monitoring of your servers, plus Laura Rose with time management tips.
[Watch the Show]
REST – OData vs. GData
Are these two different protocols really the same thing? As you may know, the intention of REST is not to define a specific protocol for software, but rather a strategy utilizing HTTP as a mechanism to interact with Data. Run a Google search on REST for more information.
Google and Microsoft have both defined protocols implementing the REST pattern for different environments. As I understand it, the OData (Open Data Protocol) sponsored by the Microsoft Open Specification Promise allows third parties to build Data Services to consume such services. OData services are typically hosted using WCF.
Google, on the other hand, has a competing specification which has libraries in Java, JavaScript, .Net, PHP and Python.
Both specifications have commonalities in that they support AtomPub and JSON as data packaging protocols, and they are transported over HTTP.
At the core of both protocols are the four data manipulation instructions (CRUD) embedded in HTTP parlance.
Create – POST
Retrieve – GET
Update – PUT
Delete – DELETE
For more information
- For GData see – http://code.google.com/apis/gdata/index.html.
- For OData see http://www.odata.org.
- If you would like to have an entertaining view of using OData, there is a nice presentation by Scott GU at http://www.hanselman.com/blog/CommentView.aspx?guid=b12ca136-0c26-4356-a5d8-6131f3e8d6ad#commentstart.
Are you using either of these REST technologies? If so, why not share your experience with our readers; drop me a note at btaylor@sswug.org.
Cheers,
Ben
Featured White Paper(s)
Encryption & Key Management for Microsoft SQL Server 2008
Written by Townsend Security
Simplify encryption and key management on … (read more)
Featured Script
View any new databases created on multiple servers
This Powershell script uses the native Provider that comes standard with SQL 2008. From one function I can see any new (crea… (read more)