Posts

XPath & XQuery Tutorial for SQL Pros (Video)


Prior to starting at Altova I had zero experience with both XPath and XQuery. The first task I was presented with was to train myself on both query languages as quickly as possible and produce a concise video that would serve as an XPath tutorial and XQuery tutorial. It was important to develop a thorough understanding of their features and capabilities because both languages are integral to app development in MobileTogether and querying data in XMLSpy. I started with a strong background in SQL, learning XPath and XQuery by building queries first in SQL, and then determining how to replicate them in both query languages.

Read more…

Tags: , , , , ,

How to Learn a New Programming Language this Summer


What better goal to set for your summer than learning a new programming language? Forget the “beach books” this summer and set your sights on diving into a new coding language – but which one should you pick?

As reported by EDC there are approximately 24 million professional software developers on Earth, and almost 700 notable programming languages (according to Wikipedia). I would wager a bet there is a staggeringly equal number of places online where you can learn one programming language or another. Whether you are already one of those 11 million coding experts or a newbie to programming, there is a plethora of information out there to sort though.

For the purposes for this blog post, we will certainly look at the world’s most-widely-used programming languages in 2021, but also at important languages for data manipulation and querying, so we’ll discuss: C and its derivatives (C++, C#, and Objective-C), Java, Python, R, JavaScript, Ruby, SQL, and XQuery.

Deciding where to start depends entirely on the kind of development scenarios you have in mind, so we’ve broken things down for you to make it easier. It doesn’t matter if you are a seasoned programmer looking to add a new language to your repertoire or a novice who doesn’t know the difference between C, C++, Objective-C, or C# yet. We have assembled a list of explanations to help you choose which language you may want to conquer next.

shutterstock_416174497_700py
Read more…
Tags: , , , ,

Enabling Let’s Encrypt in MobileTogether


MobileTogether Server, the backend hub for apps built in MobileTogether Designer, now supports the ability obtain SSL certificates using Let’s Encrypt. Let’s Encrypt is a free service aimed at encrypting all HTTP traffic on the web. This feature is supported in MobileTogether Server starting with version 5.1 and adds to the ability to upload your own certificate.


The video tutorial above walks you through configuring MobileTogether Server to utilize SSL encryption when communicating with MobileTogether clients. It covers the use of both Let’s Encrypt and certificates generated using a trusted certificate authority.

SSL certificates generated using a trusted certificate authority can be uploaded directly to MobileTogether Server. This configuration can provide several advantages to system administrators. These types of certificates are typically good for a much longer period of time, requiring fewer maintenance windows. In addition, you can keep your MobileTogether Server completely isolated from the outside world as this method does not require any external ports to be opened. The process to obtain these certificates can be much more complex and expensive. Verification typically requires you to provide information to the issuer and wait for a response which can delay your implementation.

Let’s Encrypt integration was added in MobileTogether 5.1. Let’s Encrypt is a certificate authority whose goal is to provide encryption to the entire Internet. Certificates generated are free of charge. Unlike other methods of generation, though, Let’s Encrypt certificates are only good for 90 days. MobileTogether Server is capable of automatically renewing these certificates every 60 days, but requires a scheduled server reboot each time this action occurs. Lastly, Let’s Encrypt requires your server to be accessible from the outside world; they will need to communicate with MobileTogether Server on port 80 to verify your server’s identity.

The ability to encrypt communication between client and server is becoming ubiquitous. MobileTogether allows you to easily secure all communication to your mobile clients using SSL encryption and new support for Let’s Encrypt greatly reduces the set up complexity.

Tags: , , , ,

Configuring MobileTogether Server to Work With Your Network


Configuring MobileTogether Server to work properly on your network will require some changes to be made. MobileTogether Server is designed to sit within your network’s DMZ and enabling it to accept connections from clients both inside and outside your network will require your network administrator to open a collection of ports.

This video tutorial will walk you through the ports required to make MobileTogether function. It provides you with a baseline setup that will work inside most corporate networks. Please note, however, that every network is different and some configuration changes may be required. To support this, every port MobileTogether Server uses can be customized; all the ports listed in this tutorial are default and can be changed.

The image below outlines the network ports required by Altova LicenseServer to properly validate files.

Clients will need to be able to connect both internally and externally. We recommend using the default MobileTogether ports, and remapping them to 80 and 443 at each of your firewalls. This is discussed in greater detail in the video.


Finally, a set of ports will need to be opened for administrator purposes. These ports should be limited to your internal network only.

Tags: , , , ,

Configuring MobileTogether Server & LicenseServer


Part of the Altova MobileTogether framework, MobileTogetherServer is the back-end hub that powers your native apps for Android, iOS, Windows, and the web.  The server provides high performance data processing, comprehensive caching, instant deployment of apps, and more.

Every developer looking to install MobileTogether Server will also need to obtain a copy of Altova LicenseServer. LicenseServer is a free product that simplifies license management for all Altova products, including MobileTogether Server. Licenses are managed via an easy-to-use web-based administrator console.

The video tutorial below will walk developers through the steps needed to install both MobileTogether Server and LicenseServer. It covers obtaining and running the installer followed by a basic configuration that will have you deploying enterprise apps in under an hour. This video is the first part in a short series that will eventually discuss SSL Certificate deployment, network configuration, and deploying apps to each of the app stores.

If you’re new to MobileTogether and would like to learn more about developing mobile apps, please head over to the MobileTogether Demos page where we have a collection of video tutorials.

Tags: , , , ,

Implementing Basic Filtering in Your App


There are numerous ways to implement searching and filtering within mobile apps.  MobileTogether Designer allows developers to perform filtering on either your mobile app or on the server via a SQL query.  Knowledge of each of these methods, along with the use cases for them, is an essential tool every mobile developer should possess.

This video tutorial continues to build out the books database project that has been constructed in previous tutorials.  It will cover the steps needed to implement basic filtering in your mobile app.  Additionally, it also introduces developers to the usage of user defined XQuery functions which provide a method to centralize application logic.

 

 

If you’re new to MobileTogether Designer, please take a moment to view the MobileTogether Demos page where we have provided links to additional video tutorials and demo apps.

Tags: , , , ,

Creating and Deleting Database Records with MobileTogether


Creating, deleting, and validating records is an essential bit of functionality in all data driven apps. By using MobileTogether Designer, developers can produce cross platform apps capable of handling these functions and more in record time.

The video tutorial below expands upon the concepts introduced in previous videos. It covers the steps required to add functionality for creation, deletion, and data validation to your mobile app.

If you’re new to MobileTogether Designer, please take a moment to view the MobileTogether Demos page where we have provided links to additional video tutorials and demo apps.

Tags: , , , ,