PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

Brian Swan's Blog: Using SQL Azure Federations via PHP

Note: This article was originally published at PHPDeveloper on 21 January 2012.
PHPDeveloper

Brian Swan has a new post to his blog about using Azure Federations in your PHP applications:

In a nutshell, SQL Azure Federations introduces an abstraction layer for the sharding of SQL Azure databases. The value in federations lies in your ability to have elastic scalability of the database layer of your application (to match the elastic scalability of the rest of your application when it's running in the cloud). And, one nice thing about the way federations work is that nearly everything can be done with simple SQL commands. Of course, that means that using SQL Azure Federations via PHP should be easy. So in this post, I'll introduce you to SQL Azure federations by showing you how to use them via PHP.

He uses the SQL Server drivers to make the connection to the Azure instance and, based on his included code, creates a federation and tables inside it. He also shows how to insert data into these tables, split up a federation, insert data after this split and how to query a federation member with the filtering on or off.