Backendless VS. AWS Amplify

The ultimate value of a database platform is derived from the ease at which it allows you to work with your data using the APIs and manage it with an administrative interface. Ideally, you will be able to see individual objects in each table and manage your table schema (add, rename, and delete columns, set constraints, default values and establish validators for insertion and update operations).

Even more beneficial is the ability to run search queries on your data. As your database grows, it will become increasingly more difficult to find the data you are searching for. Having the ability to use a familiar language such as SQL to search your data quickly can be very valuable.

Architecting a database is challenging, but more challenging still can be modifying that architecture as your application’s needs change. Schema management tools may feature database indexes, constraints, and data validators to make modifying your database structure easier.

If the backend provider does not offer this flexibility, you may face significant challenges if you need to add columns to a table in the future. You may even need to entirely recreate the database to institute any changes.

In addition to those discussed above, some additional features to be on the lookout for include:

• Establish cross-table relations at the schema level.
• Establish object-relations using the administrative interface as well as the APIs.
• Manage spatial data with a visual interface.
• Generate API docs for CRUD operations.
• Assign data validators to your table columns, ensuring only properly formatted data is added to a given column.
• Assign a default value to your columns.
• Edit multiline text in data objects.
• Utilize data import and export functions, such as exporting a data table (both in its entirety and limited to a subset defined by a query) and importing data into your database.
• Personalize the order of table columns in your console.
• Hide columns that you don’t need to view.
• Build and run REST requests graphically

A mobile backend as a service platform will typically be constructed with user management at the top of mind. Your team – developers and administrators alike – can benefit from being able to view a list of users in a user-friendly console and enable and disable users.

It can also be useful to have the ability to securely change user passwords while maintaining user privacy; however, it needs to be possible to disable this feature as well. Having the ability to create new users and import and export user accounts provides added flexibility when migrating user data or assisting users.

The ability to manage custom user properties provides added flexibility and customization for your user data. User properties help you understand your user base’s demographics which, in turn, can help guide your app features and content.

Finally, in an increasingly social media-connected landscape, it can be beneficial for the user management console to enable you to see all of your social users and configure the social signup process.

Not all backend services provide an integrated file management system. This can mean finding multiple providers that are compatible with each other. For example, you may host your databases with one service and your files with another.

The ideal MBaaS platform includes built-in file storage and a graphical file manager. A file manager may allow you to view and modify the names of files and directories. You may also be able to upload files with a simple drag and drop, and edit files inline in the Console.

Some platforms allow you to zip, unzip, and archive directories. This allows you to reduce the size of files delivered from your backend to users that request them. As a result, the transfer speed may be much faster.

Zipping can also be used to reduce clutter and storage usage in your file directories. If you need to access zipped files that get added to your directory, or if you need zipped directories back, the system may also let you unzip them as well.

Additionally, the capability to search for files and directories recursively can save time and complexity in file service APIs.

Finally, you may want the ability to generate API docs for all of your file storage operations. API docs are valuable for collaborating within your development team, maximizing code reuse, and potentially interacting with external API hosting services.

Real-Time has become a minimum requirement for many backends. Real-time messaging facilitates the sharing of information instantly from one user to another or from the backend to a client. This is integral to business users as it allows information such as customer profiles and orders to pass instantly from the customer or an internal department to the department that needs it.

The capability to publish messages in a variety of data types and formats makes real-time even more powerful. For example, a message can be a primitive value (i.e. a number or a string) or a complex object structure, it could be a JSON object published by a JavaScript or REST client, or a Java object published by an Android or Java app. Add to the mix iOS publishers and business logic (Cloud Code), which can also publish messages, you have a wide variety of possibilities for what a message may look like.

Real-time messaging also allows for chat within your application. Chat functionality is finding its way into many types of apps, so it’s always valuable to have that capability available. Not only will you want to send push notifications from the console, your backend should also facilitate real-time chat between users.

Additional features of interest include the ability to add smart-text into messages, filter received messages, and unsubscribe from messages, messaging channels, or all messages. These features ensure your app users have the ideal experience when working with your app.

There are MBaaS platforms on the market that offer some or most of the features discussed in this article, but very few that offer them all. While number of features is not the only deciding factor when choosing a backend provider, it is an indication of the versatility and innovation built into the platform. It can also indicate that the platform is capable of supporting your app as it’s user base and functional needs grow.

Although both Backendless and AWS Amplify are fully capable MBaaS platforms, the extent of those capabilities varies greatly. AWS Amplify offers solutions for most of the basic needs of a developer, but requires the utilization of a variety of services to achieve those results. Backendless provides a robust solution for almost any backend need, all in one place.

If you would like to try Backendless for yourself, you can start with Backendless Cloud for free here or install Backendless Pro on your own machine for a free trial.