In this tutorial we will be building a very simple todo app with Lowdefy. It will load the todos via GraphQL from a SQLite database hosted on Airsequel.

This is what the final app will look like. Not pretty, but functional!

If you find any problems in this tutorial, please feel free to leave a comment!

Setting up the Airsequel Database

Upload following SQLite database to <your-company>.airsequel.com:

todos.sqlite

Keep the browser tab with the overview page open, since you’ll need the database id later.

Creating the Lowdefy app

1. Create the directory and the boilerplate code:

   mkdir lowdefy-todo-app
   cd lowdefy-todo-app
   npx lowdefy@latest init
   

2. Start development server:

   npx lowdefy@latest dev
   

You should now see the welcome screen running at localhost:3000/welcome:

Since Lowdefy does not have a dedicated GraphQL connector yet (https://github.com/lowdefy/lowdefy/issues/298), we simply use the more generic AxiosHttp module to make the necessary HTTP POST request.

Therefore add following block right below the name: … line:

connections:
  - id: graphql_api
    type: AxiosHttp
    properties:
      baseURL: https://<your-company>.airsequel.com