[Free] Baserow Database Extension - A Database Extension for Baserow

you may set the page =2 and size =10 in the Query parameters

Snipaste_2021-08-04_12-29-50

I have already implemented this feature after this post and tested too, working fine. But I am not going to announce the update as I also have to implment the self hosting feature when it will implmented I will launch the update.
I have added a page paramter to some blocks so user can fetch the records that they want. Like 20-30 and 30-40.

blocks

Superb extension @iamwsumit . Baserow can be good airtable alternative :grinning_face_with_smiling_eyes:

Great work!!

1 Like

btw, it can be done without extension
Baserow rest-api completely helpfull

but you are awesome, make more easier with your extension
Greatwork !!

Founder of Baserow here. Great job Sumit1334! It seems that your extension has a lot of functionality and I’m sure it will be useful to lots of people. I’m not that familiar with Kodular, but it’s great to see another integration. It would indeed be really cool if your extension could connect to a self hosted instance. It should just be a matter of changing the URL from https://api.baserow.io to something custom. Let me know if you have any questions. I would love to learn in a couple of weeks how many people are using your extension.

Peter, cool that you’re also from the Netherlands and that you’re already using Baserow!

We don’t have any API or row limits for the hosted and self hosted version at the moment. The hosted version is fair use. If we see a lot of requests, we might reach out or temporarily block access. The self hosted version doesn’t have any limits and will also never have any limits! Always unlimited rows, API requests, tables, etc for free. As long as your server can handle it, we’re okay with it. There will always be a free plan on the hosted version, but we are going to introduce data limits in the future. The paid plan will be generous though.

9 Likes

Hi, great to have you here.
Thank you.

Yes you’re right. The feature has been implemented and now it is under testing. I am going to release the update on tomorrow morning.

Great to have you here @bramw. Can you tell when there will be a Docker image ready so the selfhosting will be easier to deploy. I know you are working on it but do you have an ETA?

Baserow is a wonderful product. We have a lot of users using the free version of Airtable which has a limit of 1200 rows. Chances are when they are going to use this extension or accessing Baserow via the web component that you will see an increase in users.

1 Like

Great to have you here. While you are here I’d like to take the opportunity to suggest something that in my opinion could be game changer. I found out that baserow have websocket api however it is very limited. Would it be possible to implement functions to be able to use websocket api to add, update, delete data from table? This could be an alternative to firebase real time database. Thanks

That’s awesome!

I don’t have an ETA on production grade Docker images. This month (August) is going to be super busy., but I think we can reserve some time for that in September. It’s then also time for a helm chart or Kubernetes manifest files.

Thanks so much Peter! It’s always nice to hear when people like our product.

1 Like

Great suggestion. This is actually the first time I’m hearing about a request like that. The web socket API is only used for real time collaboration at this point. The backend only broadcasts certain events.

In short, it would definitely be possible! The code of Baserow is modular and clearly separated. That means that the REST API is completely separated from the code that actually creates, updates and deletes rows. We could use the web socket API to handle those actions. We just need to figure out a way to actually accept messages and call right handler function.

2 Likes

That would be a winner if you guys could make it happen. I talked to @iamwsumit about this when i purchased extension from him and he would make an extension for it.

Version 2

Version 2 of the extension is released.

Features

  • Self Hosting added. Now you can use you self hosted baserow by just changing the URL in extension property and rest is same.

  • Json Parse added for extract the lists from the response.

  • Page parameter has added. Now you can fetch custom data.

Blocks Added

Only 2 block has added to this version.

component_method

This block helps you to ectract the list of a particular column by response received from the events.
For example, if you have a response received by the Got All Row event.

{
    "count": 1024,
    "next": "https://api.baserow.io/api/database/rows/table/4946/?page=2",
    "previous": null,
    "results": [
        {
            "id": 0,
            "order": "1.00000000000000000000",
            "Name": "string",
            "Last name": "string"
        },
        {
            "id": 0,
            "order": "1.00000000000000000000",
            "Name": "string",
            "Last name": "string"
        }
    ]
}

If you want to get all the names from this json response then simply pass this json text to response parameter and Name to column Name. And the block will return you the list of all names.

image

A property has added for setting the URL for self hosting. If you are not using self host then ignore it.

Blocks Changed

image

page parameter has added to these three block for fetching the custom data from the table. Page parameter work in respected to max record and total rows of the tabel.
For example, Here I have a table

Firstname Lastname Age
Jill Smith 50
Eve Jackson 94
Eva Malik 54
Lorem Ipsum 49
Mark Hood 45

If you have used Get Column block with max record 2 and page 2 then row 3,4 will be fetched. This depend on your max record and total rows of the table. This simply divides the rows with your max record and divided rows can called page. You have 5 row, max record 2 then 5/2 then you will have 3 pages. Each page contains two record(your max record) . Now you can pass any pages from them to get the data. If you passed 1 then 1st,2nd row will be fetched and if you passed 3 page then 5th row will be fetched.

Thanks @Peter for his suggestion and testing the extension.
Thanks @72erdelyi for allowing me to use his self host account for testing.

Thanks for using my extensions
Cheers :grinning:
Sumit

5 Likes

Baserow is free means no bandwidth limits no rows limits no table limits no api request limits
like everything is free in baserow ???

1 Like

Until now so that could change. They have a fair use policy so if you put a really heavy load on the server they could limit your use of Baserow.

2 Likes

I tested with App Inventor so this is how my test app looks.

I changed my offline version of the following app to an online version.

3 Likes

Great Extension @iamwsumit I am really looking forward to use it for my app Onyx Note in the next update.

@bramw glad u are here. Can I use the self hosted version for a production app ? Currently my app don’t have much users. I have around 50 active users.

2 Likes

You can use it whatever you want. It’s on your server it costs you money. Hosted on baserow costs money to the company and they may put a cap on it when it gets abused.

1 Like

That’s right! You may use the self hosted version for free with as much users and data as you like :slight_smile:. Below you will find a couple on how to install easily on your own server.

https://baserow.io/docs/guides/installation/install-on-heroku

https://baserow.io/docs/guides/installation/install-on-cloudron

3 Likes