# Backend 🔗

{% tabs %}
{% tab title="Introduction" %}
{% embed url="<https://www.youtube.com/watch?v=HovF-MHPVU8&list=PLMXGDzhAj1zuUJa2AN4zONbqOnAtLmhTL&index=5&t=394s&ab_channel=Blup>" %}
Backend Introduction
{% endembed %}

<figure><img src="https://youtu.be/6KFKNWZ0ll4?si=6lvUxmAaLd35PLie" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="Music" %}
{% embed url="<https://open.spotify.com/playlist/0vvXsWCC9xrXsKd4FyS8kM?si=2c7f55bd3f944878>" %}
Stream it!
{% endembed %}

<figure><img src="https://open.spotify.com/playlist/0vvXsWCC9xrXsKd4FyS8kM?go=1&#x26;amp;sp_cid=cd2a557585cf6ac8c1f2fe3cd33e0f50&#x26;amp;utm_source=embed_player_v&#x26;amp;utm_medium=desktop" alt=""><figcaption></figcaption></figure>
{% endtab %}
{% endtabs %}

In Blup, the Backend consists of 2 parts:

1. **Backend Bar**
2. **Backend Tab View**

### Backend Bar

The backend bar consists of a switcher to switch between sheets and SQL and the right-side menu consists of a backend menu, expand/minimize backend, and close backend.

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2FjUOGY23Ie8qUcpVQM6MX%2FUntitled%20design.png?alt=media&#x26;token=70a5b76a-2b04-4309-b050-417730f44d07" alt=""><figcaption><p>Backend bar</p></figcaption></figure>

#### Sheets SQL Switcher

This button helps you to quickly switch between the **Sheets** panel and **SQL** tab.

To build the backend of your app, you need to continuously switch between the **Sheets** and the **SQL**, this is where this switch button comes in handy.

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2FFYgeRXMrimVtG3acV9JO%2FUntitled%20design.gif?alt=media&#x26;token=16646a49-692c-4633-9208-09aaaef17fff" alt=""><figcaption></figcaption></figure>

#### Expand/Minimize Backend

The **expand/minimize Backend** button helps you to minimize or expand the window.

This button is quite useful when you want to use more space to work with the editor or the sheets section.

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2Fgit-blob-fc74d32892ae069200c5167ae3d61ba837cd5f7e%2Fexpand_minimize.gif?alt=media" alt=""><figcaption></figcaption></figure>

#### Close Backend

The **close backend** button is used to close the backend panel.

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2F3Ug3yIBb3Lka23ntOWv7%2FUntitled%20design.png?alt=media&#x26;token=32a39d97-7bd3-4d2e-8502-5e455482381a" alt=""><figcaption><p>Backend - close</p></figcaption></figure>

### Backend tab view

* When Sheets is selected in the Backend bar, the backend tab view shows.

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2F1BBxcn2zb5PPO9tOA2J3%2FUntitled%20design%20(1).jpg?alt=media&#x26;token=b3c20adb-e52e-4c28-8db8-f5e6c4b038fe" alt=""><figcaption><p>Backend - Sheets</p></figcaption></figure>

* When SQL is selected in the Backend bar, the left side of the backend tab view shows all SQL queries created by the user and SQL query manipulation, filtering tab, and the right side of the backend tab view has an SQL editor to edit the query.

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2FR5a2NMsoqEtLQ93nnRsd%2FUntitled%20design.jpg?alt=media&#x26;token=952beae0-5d57-4c6b-865a-caf00f976105" alt=""><figcaption><p>Backend - SQL</p></figcaption></figure>

{% hint style="info" %}
**Note:** You can also resize the backend panel by dragging the top of the backend panel.
{% endhint %}

<figure><img src="https://4209426742-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Me1x4TD1HxodVbK1aDe%2Fuploads%2FFFinUHYK3lbyqxi0g8N0%2FUntitled%20(1).gif?alt=media&#x26;token=fa0d6205-2ba7-4dc7-aaae-31c346a17ba3" alt=""><figcaption><p>Backend - resize</p></figcaption></figure>

### Music to go with.

{% embed url="<https://open.spotify.com/playlist/0vvXsWCC9xrXsKd4FyS8kM?si=2c7f55bd3f944878>" %}
Lofi music
{% endembed %}
