[Free] Baserow - Open source no-code database

Baserow Extension

Hello Guys, Today I am launching my new extension Baserow which is an open-source no-code database & considered as an Airtable alternative. This extension will help you to get/store/delete the data of the baserow database.
Thankyou to @Ranjan_Kumar_Singha for sponsoring this extension.

Blocks :

I've my table looks like in baserow :

Company CEO
Tesla Elon Musk
Amazon Jeff Bezos
Walmart Doug McMilion
Google Sundar Pichai

1. Set Token

blocks (2)
This block is used to set API token & should be intialized first along with Set Table block. On baserow, Go to your dashboard, Click on your profile, then setting and API token to get the token for the particular group.

2. Set Table

blocks (3)
This block is used to set the table id of your particular table from which you wanted to fetch/write data. It should be intialized first.

3. Get List Fields

component_method
This block is used to get the column name, type, id, if it is Primary, etc. of the table. It will trigger OnFieldListed block.

4. OnFieldsListed


This block is triggered after GetListFields. This will give all the column names, ids, types etc. in YailList.
For example,
gave;

5. GetAllRows

component_method (1)
This block will help you to get the rows of the table of particular page and particular size. Page defines page of rows which should be returned and accepts int. Size defines how many rows should be returned per page and accepts int. It will trigger GotAllRows event method.

6. GotAllRows

component_event (1)
This block is triggered after GetAllRows method. It will give the list of rows of the table.
For example,

gave,

7. CreateRow


This block will help you to create a new row in your table. columns and values accepts YailList. Remember columns length and values length should be same. If success, then it will trigger RowCreated method.

8. RowCreated


This event is triggered from CreateRow method and it will give the response. For example, using above block from CreateRow gave this response,

{
   "id":5,
   "order":"5.00000000000",
   "Company":"Microsoft",
   "CEO":"Satya Nadella"
}

9. GetRow

blocks (8)
GetRow method will help you to get the particular row of the table. Remember row id is not a index id. rowId accepts integer row id. If success, GotRow method will be triggered.

10. GotRow


This event will be triggered from GetRow method. It will give you list of data of the row. For example, using above block from GetRow method gave ,

11. UpdateRow


This block will help you to update existing row with new values. columns & values both accepts YailList. If success, It will trigger RowUpdated method.

12. RowUpdated


This block will be triggered from UpdateRow method . It will give response. For example,

{
   "id":1,
   "order":"1.00000000000",
   "Company":"Tesla",
   "CEO":"Sir Elon Musk"
}

12. MoveRow

blocks (14)
This block will help you to move the existing row before another row. rowId and beforeId both accepts integer. beforeId helps to move the row related to the given rowId before the row related to the provided value. It will trigger RowMoved method.

13. RowMoved


This method will be triggered from MoveRow method. It will give you jsonResponse for move row.

14. DeleteRow

blocks (16)
This method will help you to delete particular row from row Id. It will trigger RowDeleted Method.

15. RowDeleted


This event will be triggered from DeleteRow method if successed.

16. GetColumn

blocks (18)
This method will help you to get the particular column data. Page defines page of data which should be returned and accepts int. Size defines how many rows of data should be returned per page and accepts int. It will trigger GotColumn event.

17. GotColumn


This event is triggered from GetColumn method. It will give you list of datas in a particular column. values will be in YailList.

18. GetCell

blocks (20)
This method will help you to get a single cell from rowId and column name . This will trigger GotCell method.

19. GotCell


This event is triggered from GetCell method. value is string data of the cell.


Please see here for the extension's version 2 documentation :


This extension is open-sourced here :

Version 2: com.oseamiya.baserow.aix (109.0 KB)

Version 1: com.oseamiya.baserow.aix (108.8 KB)

12 Likes

Nice extension

Note that although this extension is 'free,' Baserow itself is not necessarily free. If a developer uses this platform.

  1. It is not clear how long the Baserow Hosted version will remain free. Note "Free for now"
  2. The self hosted (free) option requires your own server and requires you to create a Redis database. Baserow uses Redis for asynchronous tasks and the real time collaboration. You can install Redis with the following commands. So, why not use a CloudDB with your own Redis server?

Free does not necessarily mean free of costs to use the database, just the access extension. :cry:

and a reminder:

MIT indicates Extensions have always been a "use at your own risk" affair. We as a team do not have the capacity to vet every single extension (at last count around 2% of projects include extensions and there are over 3000 unique extensions) so, use the extension at your own risk. Actually, the do not vet any of the extensions in the wild for malicious activity. Be aware even Google are aware of the risks as they prohibit apk attachments to gMail.

4 Likes

Ya, but, its free alternative to some other ones, Anyone can deploy own instace and use it freely

Nice and epic extension @Sneha_Sharma
:smiling_face_with_three_hearts:

2 Likes