How to integrate a Turso database with Azion using a template

The Turso Starter Kit accelerates the integration of a Turso database, created using Turso’s LibSQL SDK, into an edge function. It also provides an interface to easily create, update, and delete items in your database.

This template uses LibSQL 0.5.3.

Requirements

To use this template, you must:

• Create a Turso account.
• Install the Turso CLI.
• Have a GitHub account to connect with Azion and create your new repository.
  • Every push will be deployed automatically to this repository to keep your project updated.
• Enable Edge Functions and Application Accelerator in your Azion account.
  • To enable them:

1. Access Azion Console > Account menu.
2. Select the Billing & Subscriptions option.
3. Select the Subscriptions tab.
4. Activate the switch for each module.

Getting the template

To start using this template:

1. Access Console.
2. Click the + Create button on the homepage.
3. In the modal, select the Templates option.
4. Browse and select the Turso Starter Kit card.

Setting up the template

In the configuration form, you must provide the information to configure your application. Fill in the presented fields.

Fields identified with an asterisk are mandatory.

1. Connect Azion with your GitHub Account.

• A pop-up window will open to confirm the installation of the Azion GitHub App, a tool that connects your GitHub account with Azion’s platform.
• Define your permissions and repository access as desired.

2. Select the Git Scope to work with.
3. In Application Name *, define a name for your edge application.

• Use a unique and easy-to-remember name. If the name has already been used, the platform returns an error message.
• The bucket for storage and the edge function will use the same name.

4. Enter the following information:

• Turso Authorization Token *: the authorization token to access your Turso account.
• Turso Organization *: the name of your organization in Turso. For individual accounts, enter your login user.
• Turso Group: the name of the group in the organization where the database will be created. Default value: default.

5. Click the Deploy button to start the deployment process.

During the deployment, you’ll be able to follow the process through a window showing off the logs. When it’s complete, the page shows information about the application and some options to continue your journey.

Key configurations

This template deploys a basic edge application with a domain to access the interface and an edge function including a CRUD query example. Additionally, it creates an instance and a Default Rule to execute the function, as well as sets new environment variables for your Turso credentials.

It also creates a new GitHub repository, including a GitHub Action to enable a continuous development workflow and a new Turso database you can manage, with integration under the /turso route.

Managing your database

You can use the Azion domain to access the application through the browser and interact with the database through the static interface that was created.

By using this interface, you’re able to create, retrieve, update, and delete items in your posts database, which is now linked to this new application. To do so, the interface provides an input area and icon buttons to manage your data as required.

All changes will be reflected on your application and your Turso database as well.

Managing the template

Considering that this initial setup may not be optimal for your specific edge application, all settings can be customized any time you need through Azion Console.

To manage and edit your edge application’s settings, proceed as follows:

1. Access Azion Console.
2. On the upper-left corner, select Products menu > Edge Application.

• You’ll be redirected to the Edge Application page. It lists all the edge applications you’ve created.

3. Find the edge application related to your template and select it.

• The list is organized alphabetically. You can also use the search bar located in the upper-left corner of the list; currently, it filters only by Application Name.

After selecting the edge application you’ll work on, you’ll be directed to a page containing all the settings you can configure.

Adding a custom domain

The edge application created during the deployment has an assigned Azion domain to make it accessible through the browser. The domain has the following format: xxxxxxxxxx.map.azionedge.net/. However, you can add a custom domain for users to access your edge application through it.