BlupSheets πŸ“Š
Pre-built backend For Blup.
Video
Music
Lofi music

BlupSheets

BlupSheets is a powerful GUI based database that is built from ground zero to work perfectly with blup. It is built on top of AWS so your data is highly secured and all your data is highly available, so you can load/save data into BlupSheets.
Blupsheet database is quite similar to a traditional relational database which means that in blupsheets also data is stored in the form of a table [rows and column].
Note - You can either insert the data into the database manually or you can use Blupsheet node to insert data dynamically, based on the feature of the app choose whatever you like.

Components of blupsheets

When you open Blupsheets from its button present in the tools section [left-hand side panel].
You will see that blupsheets consist of several sections, so let's go over each section one by one.

Status Bar Section

Collapse button

This button helps you to collapse or close the blupsheets panel in blup [hide the blupsheets so that another section of blup is highly visible].

Switch Button

This button helps you to quickly switch between the blup lightning panel and blupsheets panel.
When you have opened multiple components at the same time, so it's quite hard to go back and forth between those components, so you can use this button to quickly switch between them.

Table name

It shows you the table on which you are currently working.

Refresh Table button

This button helps you to refresh the table, this button is quite useful helpful when the table is constantly refreshing/ updating with data, therefore this button helps you to get the updated data each time.

Delete Table button

This button is used to delete the currently selected table

Middle Section

this section consists of all the data that is stored in the table in n the form of rows and columns. This section shows you the data in the form of a table.
this section consists of all the data that is stored in the table in n the form of rows and columns. This section shows you the data in the form of a table.

Bottom Section

In the bottom bar or bottom section of blupsheets, you can see that all the tables are present the blupsheets are shows here. Also, there is an add button if in case you wanted to create a new table.
Note – by default, there are two tables present in the blupsheets
    1.
    Users table - This table consists of all the login information of the user, data gets stored in the table when the user used the google sign-in method to login into the app. Note – you can also store this data into other tables, but this table consists of this data by default.
    2.
    Blup Insights Tables

Understanding the working of Blupsheets

If you wanted to use blupsheets as your backend database first you need to define the schema for the database which means that you need to structure to the database i.e. how many tables does it have and how many columns does each table is having and what the type of column in a particular row.
For example - suppose you are building apps that can store the data of students [student management apps], then you can define a table with column-like student id [nuimber], student name [single line text], student department [single line text], student date of birth [date and time].

How to create a new Table in blupsheets

To create a new table in blupsheets go to the bottom section of the blupsheets and then click on the plus/add icon present next to the user's table, it will create the new table.
When a new table is created by default two-column with single line text as types are already generated for you. These by default columns can be easily modified you can change the name as well as types of both columns in the table.

Modifying table in blupsheets

To modify the table present in the blupsheets like changing of field type or changing the name of the column or deleting a particular column are done by pressing an options icon present next to each column name heading.
Clicking on this option icon will show you multiple options

Change the field type

This option present in the dialog box will help you to change the field type of the column.
Clicking on this option will show you a dropdown menu which consists of several options like number, date and time, paragraph etc choose any options according to your needs.

Rename Column Name

This option helps you to change the name of the column to anything that you wanted to have
Note – it is recommended that the name should not contain the space in between, because it sometimes leads to the problem.
For example, if you wanted to give the student name as a column name then instead of space between the word you can use like this student-name or student_name both are correct.

Delete

This option helps you to delete the currently selected column with all the data present in the column.
Note – when you delete any column all the data that is stored in that column will be deleted and can not be recovered.

Music to go with.

Lofi music
​
Last modified 1mo ago