Before you begin
Tutorial level: intermediate.
Prerequisites: an Appery.io account.
Creating Amazon AWS Account
1. Open the link – https://aws.amazon.com.
2. Click Create a Free Account.
3. In the new page, enter the e-mail, select
I am a new user. and click Sign in using our secure server.
4. On the next page, fill in all the fields and click Create account.
5. The next step is providing all the contact information. After that, click Create Account and Continue.
6. After that, enter your payment information and click Continue.
7. The next step is your identity verification by telephone. Make all the necessary corrections in the fields and click Call Me Now. After you get a call from an automated system, you’ll be prompted to enter your PIN-number on the phone.
8. If everything has been done correctly, you’ll be redirected to the next page where you should select the AWS Support Plan and click Continue.
Congratulations! Your registration has been completed.
Creating a database
1. Now, you can login with your account on the main page.
2. Proceed with your login and password.
4. On the next page, select
5. And then click Launch DB Instance.
6. Then select a DB Engine (here –
PostgreSQL) and confirm your choice.
7. On the next step, select
No (if the DB accessibility in several zones is not critical in your case) and click Next Step.
Mind the message that appears when you select
Create new Security Group for the
VPC Security Group(s).
By default, accessing the database is made possible with the current mail (the instance was created with), but below you will find how you can change it, if necessary.
10. After all the necessary fields have been filled in, click Launch DB Instance.
11. As a result, the success message appears.
12. Now, let’s click View your DB Instances and wait for the instance to be created. When the status changes to
available, your database is ready and can be used. Click the triangle sign on the left to open the full view:
13. For getting access, we use the following:
- URL –
- Port –
- Database name –
- Username and password – the previously set credentials.
Creating a database table
Now, to start working with API Express, we need to create a table(s) by using special database tools.
1. Let’s take, as an example,
2. Download the soft, install it, and run.
3. On the main page, click Add a connection to a server.
7. Right-click on
Tables, then select
9. Add the columns to your table by clicking Add and defining their names and types.
14. In the
New Table dialog, also click OK.
Filling the table with data
Let’s add some data to the table.
Ensure, that the table has a primary key defined.
Now, when we have a table filled in, let’s create an app and check how our model works.
Adding database to API Express
1. In the Appery.io builder, go to the
API Express tab.
2. There, click Create new DB connection, fill in all the required information (see step 15 from the
Logging into AWS and Creating DB section above), enter any name, select
Relational database as
Connectional type, and, for
Database type, select
3. To ensure it works, click Test and then – Save.
4. Now, let’s create a new project: under the same
API Express tab, click Create new project, enter its name and click Create.
5. Open it and click on the
7. The model saved, now it can be tested.
Creating an App
1. In the builder, go
Apps > Create new app > Bootstrap AngularJS App.
2. Name the app and click Create.
3. In the app:
CREATE NEW > Extensions > API Express Generator.
5. In the new window, enter the service name (for example,
APIExpressService_users), confirm, and reload your browser page.
6. After reloading, the list of created Services and JavaSscript appears in the
7. Now, switch to
Pages > Screen1, and add the following
Inputto enter an
idfor search. For the
Buttonto invoke a
getrecord function(change its
- and a
Textto get the returned entries (change its
9. Then, add the
get function, click Edit, then – Invoke service. For the service name, enter:
10. Now, define the following mappings and click Save and return:
11. For a successful response case, add the following to the code (to apply the UI changes):
12. And, for the error, add the following:
alert("Error on get object");
Testing the app
Click TEST to test the app.