Xano - Getting Started Step 1: Database

Welcome to Xano, the no-code platform that simplifies backend development for web and mobile applications. In this guide, we'll walk you through creating database tables and adding data, the first step in building your backend with Xano.

Understanding the Database

The database is the heart of your application, where all the data, content, and information are stored. Think of it as a filing cabinet holding all the data for your application. Within this filing cabinet, you have different folders (or tables) that organize your content and data.

Accessing the Database Page

To access the database page, click on the "Database" option in the left navigation bar of the Xano dashboard. Here, you'll find the database tables you created during the Jumpstart wizard, along with a preview of their schema (the data structure within the tables).

Exploring Database Tables

Let's explore one of the existing tables, such as the "Merchant" table. Click on it to open a familiar spreadsheet-like view. Xano automatically provides an ID column for uniquely identifying each row (or record) and a timestamp column for tracking when each record was created.

Adding Columns (Fields)

To add more columns (fields) to a table, click the "+" button at the top. Xano will present you with various field types to choose from, including text, numbers, dates, and more advanced options.

For example, let's add a "Name" text field to the "Merchant" table to store the merchant's name, and a "Description" text field for a brief description.

As you enter data, Xano automatically saves your changes, making it convenient to work with.

Creating Relationships

One of the powerful features of databases is the ability to create relationships between tables. This allows you to associate data from one table with data from another table.

In the "Deal" table, let's add a "Deal Type" text field and create a couple of deals:

Now, to associate these deals with a specific merchant, we'll create a relationship between the "Deal" and "Merchant" tables. Click the "+" button to add a new column, then choose the "Table Reference" option. Select the "Merchant" table from the prompt.

Xano will add a "Merchant ID" column to the "Deal" table. You can now enter the ID of the merchant record you want to associate with each deal. For example, if the "Firestone Grill" merchant has an ID of 1, you can enter "1" in the "Merchant ID" column for the deals you want to associate with that merchant.

And that's it! You've successfully created database tables, added data, and established relationships between tables, all without writing a single line of code.

Remember, Xano provides various resources, including videos and documentation, to help you dive deeper into database best practices and advanced topics.

Happy building!