Video Tutorial: How to Build a REST API for a Custom SQL Query

This video shows how to use the SQL and Script components to build a Login service. The SQL component runs a custom SQL query to check if a user exists in a database. The Script component adds custom logic to check what the SQL component returned and defines the response (user found or user not found).

Looking for more videos on enterprise integration? Watch the API Express playlist.

What is Appery.io App Builder?

In three previous blog posts I told you about Appery.io Server Code, Push Notifications and API Express. Appery.io App Builder is another core component in the platform. The App Builder is where you build your app (the client side). The App Builder is where you design and build the app pages, drag and drop UI components, define navigation between pages and any other UI logic.

When you create a new app in the App Builder, you can create an app with one of the following UI frameworks:

  • Ionic
  • Bootstrap
  • jQuery Mobile

Every new app that you create (regardless of the UI framework) comes with Apache Cordova (PhoneGap) installed. Cordova enables you to access native devices APIs via JavaScript. The following Cordova plug-ins are available out-of-the-box:

  • Cordova Media Plugin
  • Cordova Device Plugin
  • Cordova Contacts Plugin
  • Plugin for Google Analytics
  • Cordova Network Information Plugin
  • Cordova File Plugin
  • Cordova Device Orientation Plugin
  • Cordova Console Plugin
  • Cordova File Transfer Plugin
  • Cordova Globalization Plugin
  • Barcode Scanner Plugin
  • Cordova Splashscreen Plugin
  • Cordova Camera Plugin
  • Cordova Vibration Plugin
  • Cordova Battery Plugin
  • Push Notifications Plugin
  • Cordova Media Capture Plugin
  • Cordova Device Motion Plugin
  • Cordova InAppBrowser Plugin
  • Cordova Notification Plugin
  • Cordova Geolocation Plugin

3rd party and custom Cordova plugins can be added as well.

The app is designed using the visual drag and drop editor. At the same time, you can write any custom code to customize the app as much as you need. As you are building a hybrid mobile app, you can write custom HTML, CSS, and JavaScript. You can also import any custom JavaScript libraries.

In addition to creating a hybrid app, you can also build a mobile web app that runs directly in the browser. When you are done building your app, you can get:

  • Android app (Cordova)
  • iOS app (Cordova)
  • HTML5 mobile app

Right inside the App Builder you can launch the build service which will package the app for either Android or iOS. If you are creating an HTML5 mobile app, you can host the app with the Appery.io platform or export the web resources (HTML/JS/CSS) and host it on a server of your choice.

Every mobile app has to talk to some backend or server. Your app can easily use Appery.io Push Notifications, Server Code, API Express or the Database for its backend. Your app can also easily connect to any 3rd party API.

To test the app, you can launch it directly in the browser. This is the case where you can test everything but the native functionality. To test any native functionality, you can test the app inside the Appery.io Tester app for Android or iOS. This app allows you to test your hybrid app without installing it on the device.

A Weinre debugger is also available to debug the app when installed on the device. When running and test the app directly in the browser, you can use the powerful Chrome Developer Tools for debugging.

We have a number of short videos on building an app on our YouTube channel here.

Happy coding.

How to Run, Test and Share Your Hybrid App Fast, Without Installing it on the Device

How do you share your hybrid app during development with the client, colleagues or even just friends to get feedback? It’s not simple. One approach is to build a binary for iOS (.ipa) or Android (.apk) and send it to the person who wants to try the app. This approach is complicated as it requires people installing the app on the device. Non-technical folks probably don’t know how to do that. Luckily there is a much simpler and faster approach. Let me show you this approach.

When you are building a hybrid app in Appery.io platform, you get access to a simple, yet very powerful app called Appery.io Tester app. This app, freely available for iOS and Android makes it very simple and fast to test your hybrid app on the device without having to install the app. Running the app on the device helps you test native APIs such as camera very quickly. This is how the app looks:

Appery.io Tester app for Android
Appery.io Tester app for Android

Continue reading “How to Run, Test and Share Your Hybrid App Fast, Without Installing it on the Device”

Build a Mobile App with Geolocation and Google Maps in 5 Minutes

This video shows how to build a mobile app with Geolocation and display the location on Goole Maps in 5 minutes.

Check out other videos in Build in 5 Minutes series.

AT&T Bootstrap Week: Learn How to Build a Complete HTML5/Hybrid App with Appery.io

As part of AT&T Bootstrap Developer Week, I will be showing how to build a complete HTML5/hybrid mobile app with Appery.io cloud platform. This is an excellent preparation for the AT&T Summit hackathon January 3-4, 2015.

Topic

Learn How to Build a Complete HTML5/Hybrid App with the Appery.io Cloud Platform

What

Appery.io is a cloud-based platform with visual development tools and integrated backend services. With nothing to install or download, Appery.io allows rapid HTML5 and hybrid app development entirely in the cloud. In this session you will learn how to build a complete mobile app. We will build the app UI using a visual drag and droop editor, connect to an API backend, and use Cordova for native device features. We will then test and deploy the app. This is a live coding session where attendees will be able to test the app as it’s being built.

When

Tuesday, December 19, 9 AM Pacific Time

Register

Register to attend this online tutorial.

Fast Mobile UI Development with Page Templates

This video shows:

  • Creating and using page templates for fast mobile UI development.
    When you use page templates, making changes is fast as you only need to modify the template and all pages that use that template will be automatically updated.
  • Using the Panel component for global app navigation (slides from the left)

Using New UI Themes in Appery.io

This video shows how to add and use new jQuery Mobile UI themes in Appery.io.

Building Airport Status Mobile App with Appery.io [Video]

This video shows:

  • Creating a jQuery Mobile app
  • Creating and binding Airport Status service to the page
  • Testing the app in the browser
  • Customizing the app UI
  • Showing how to build a binary app for iOS, Android, and Windows Phone

New Webinar: Building Mobile Apps in Appery.io with Facebook API

What
Creating mobile apps in Appery.io with Facebook API

When
Wednesday, May 14, 11am Pacific Time

What you will learn
Learn how to connect and use Facebook API when building a mobile app in Appery.io platform.

Register
Register for this webinar

Creating jQuery Mobile App With Yellow API in Appery.io [Video]

This video shows how to create a jQuery Mobile search app with Yellow API in Appery.io: