Using a relational database with Apppery.io

In a previous post creating a back-end NoSQL database on the Appery.io platform was described. Herein attempting to connect to a SQL Server 2012 is described.

It is quite straight forward connecting to a relational database.

Here is the procedure described on the site:

Login to the Appery.io site and click on API Express tab.

ApperyIO3_0.PNG

The API Express page opens as shown.


 ApperyIO3_1.PNG

In this case we just make a connection to SQL Server 2012. Make sure you have started SQL Server from Windows Services panel.

Click Create new DB connection.
The New connection page is displayed.


ApperyIO3_2.PNG

Provide a Name and click Create. It looks like you can also connect to a backup.
Page related to the connection name you provided opens (herein SQL2k12).



ApperyIO3_2.PNG

Fill in all the fields needed to make connection.

Connection name: SQL2k12
Connection type: Relational database (the other option is appery.io database)
Database type: SQL Server
Host: Hodentek\RegencyPark
Port: 1433 (default)
Database name: Northwind
database schema: dbo
username:
password:
Pool Settings:  accept defaults

Click Test.

Connection fails with the message credentials not accepted. However the SQL Server is running and the authentication information is correct.

Although Appery.io is supposed to connect to SQL Server, it appears the support for named instance is in the works at this point. However, it can connect to an Azure SQL Database and other relational databases such as MySQL. While conneting to a database on the web appears to be straight forward, connecting to a database server behind a router requires (local Network)  tweaking of the connectivity to the Internet.


Comments

Post a Comment

Popular posts from this blog

Apps with Mobile Roadie, the one-stop platform

Image
MobileRoadie is the platform to build mobile apps with rich features. It is also one-stop, build, manage, design and engage. It supports all media, photos, video and audio. The text color in the picture may not show you the logo clearly! Here are features taken from Mobile Roadie site . Using Photos: Upload your photos manually, or automatically pull in your photos from an RSS feed, Flickr account, Instagram account or hashtag, Mobypicture, Picasa, Twitpic, or Facebook Fan Page profile photos. Users will see your photos in a grid layout of your choosing, and can even play a slideshow of your photos. Embed news: Add news posts manually, or import automatically via RSS feed, Twitter account, or Google News keywords.     Each item has artwork, title, date & time, and HTML story content. FAN Wall:     Import your past and upcoming events from Artistdata, Bandsintown, Songkick, Plancast, Ticketmob, SonicLiving, Eventbrite, or ad...
Read more

Towards cross-platform development..

There are lots and lots of Apps. In fact there are over a couple of million Apps including all of the major brands, Apple, Google, Blackberry, Microsoft with Apple at the top and Microsoft in the bottom. But this is a growing market. The variety is truly bewildering, different size devices; different operating systems(OS); different programming languages;  and different orientations. This post is not very recent but you can see how the various mobile operating systems compare: http://www.ibtimes.com/android-vs-ios-whats-most-popular-mobile-operating-system-your-country-1464892 The interactive image in the article really shows the popularity of a given OS/device among different geographical regions. Windows Phone Apps is for example based on Microsoft's Window 7, 8, 8.1 OSs using .NET. With Windows OS and Visual Studio one can build Apps for all of Microsoft devices covering Phone, Tablet and Desktop. However Microsoft Windows Apps sans Html5/CSS/Javascript is OS specific. E...
Read more

Installing Android Studio 3.0 on Windows 10

Image
Android Studio 3.0 is the official Integrated Development environment (IDE) for Android app development. Android App studio brings in many features : • A flexible Gradle-based build system • A fast and feature-rich emulator • A unified environment where you can develop for all Android devices • Instant Run to push changes to your running app without building a new APK • Code templates and GitHub integration to help you build common app features and import sample code • Extensive testing tools and frameworks • Lint tools to catch performance, usability, version compatibility, and other problems • C++ and NDK support • Built-in support for Google Cloud Platform, making it easy to integrate Google Cloud Messaging and App Engine The installation is straight forward on Windows 10 as the installation program downloads all the necessary items during Android Studio installation. It is driven by a wizard which makes it very easy. You can downlo...
Read more