Tutorial Series: SQL Azure, DreamFactory & Telerik AppBuilder – Introduction

Tutorial Series: SQL Azure, DreamFactory & Telerik AppBuilder – Introduction

Let’s build an app! In this tutorial series, I will walk you through how to build a basic mobile application using SQL Azure, DreamFactory and Telerik AppBuilder.

  1. Part 1:This article
  2. Part 2: Building the database

Every once in a while you come across a match that is made in heaven. It might be anything at all. You know that couple. They were just made to be together. Bose Surround Sound and 4320p. Apple pie and ice cream. I digress.

I recently have been testing various development tools, APIs and platforms and came across a dream match.

The pieces of the puzzle come together like this:

Front End API Data

 Telerik AppBuilder

Telerik AppBuilder

 DreamFactory

DreamFactory

Microsoft SQL Azure

SQL-Azure

 

Telerik AppBuilder: (formerly Icenium)

This is a gem of a find. AppBuilder takes the mundane hard tasks and makes them disappear, leaving you with just the nuts and bolts to add on. Choose between a hosted web IDE, a windows standalone IDE or a Visual Studio plugin. I personally use the standalone IDE as it has support for automatically updating the apps on my connected devices as I’m building. Absolutely perfect when trying to fine-tune areas of your app.

Some people may not like the licensing of Telerik from past experiences, but AppBuilder comes with a free starter edition! Go forth, and build.

 

DreamFactory

This, right here folks, is pure genius. A common API that consumes multiple data sources and is accessible from anywhere. That’s right. DreamFactory provides unified REST and JSON services for websites, web apps and native applications with the click of a button. Yes, no code.

Point DreamFactory at a web accessible SQL database and BOOM, fresh API served instantly. Secure authentication is the appetizer that comes with every meal. MongoDB, S3, Azure Tables, SimpleDB, SendGrid, MySQL, and CloudFiles all under a simple unified API.

DreamFactory is open source, to boot. Read more about DreamFactory in this article by Bill Appleton.

 

Microsoft SQL Azure

While many people may debate S3 versus Azure versus Google App Engine versus <insert your poison here>, I’m not promoting one over the other. I just happen to have free Azure credit though my MSDN subscription and I must say, SQL Azure is easy.

Pricing is very comparable right now as well, and I have received emails from Microsoft announcing decreases in Azure pricing so now is a good time to check it out.

That being said, you can easily swap out SQL Azure in this series for another publicly accessible database, like MySQL, for example. The database creation will be amazingly simple.

 

So with that being said, lets get started shall we? Part 2: Building the database

agrothe (9 Posts)

Andrew Grothe is an enterprise developer with an interest in HTML5 mobile and game development. Andrew is current working on a casual HTML5 game at http://spacecutegame.com and maintains the http://webapplist.info website.