Blup Sheets (Backend) 🔗
Pre-built backend For Blup.
Video
Music
Lofi music
BlupSheets is a powerful GUI-based database that is built from ground zero to work hand-in-hand 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.
Blupsheets database is similar to a traditional relational database in the sense, in blupsheets also store data in the form of a table [rows and columns].
Note - You can either insert the data into the database manually or you can use the Blupsheet node to insert data dynamically, based on the feature of the app choose whatever you like.
When you open Blupsheets, from its button present in the tools section [left-hand side panel], you will see that blupsheets consists of several sections, so let's go over each section one by one.
This button helps you to collapse or close the blupsheets panel in blup [hide blupsheets ].
This button helps you to quickly switch between the blup lightning panel and blupsheets panel.
When you have opened BlupLightning and BlupSheets, it will be hard to navigate back and forth between these two panels. This is where the switch button comes in handy.
It shows you the table on which you are currently working.
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.
This button is used to delete the current table.
This section consists of all the data stored in the table in the form of rows and columns.
In the bottom bar or bottom section of blupsheets, you can see that all the tables present in the blupsheets are shown here. Also, there is an add button if in case you wanted to create a new table.
Note – by default, there is a table present in blupsheets
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. You can also store this data into other tables, but this table consists of this data by default..
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 the database i.e. how many tables does it have and how many columns each table has 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 app], then you can define a table with column-like student id [number], student name [single line text], student department [single line text], student date of birth [date and time].
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.
To modify the table present in blupsheets press the options icon present next to each column name heading.
Clicking on this option icon will show you multiple options:C
- Change the field type
- Rename the column
- Delete the column
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 option according to your needs.
This option is used to change the name of the column to anything that you wanted to have
Note: The names should not contain any space between them. You can use '_' instead.
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 cannot be recovered.
Lofi music
Last modified 9mo ago