Baserow Cloudron app - Airtable alternative
marcusquinn last edited by marcusquinn
@bram Great stuff - looking forward to giving it a good test and helping with feedback.
Personal opinion but maybe shared. Something I've found, and I think others do too, is making open-source a sustainable business, and for users, avoiding gotchyas, lock-ins or usage taxes.
The business models I've found the happiest are with EspoCRM and Freescout.
Essentially, the FOSS is unlimited in usage, and the Premium is too.
Premium revenue coming from selling extra setup "Packs" that are typically only needed by businesses, and also effectively fast-track best-practice template setups.
So FOSS users get the full benefit of the framework to use, test,, feedback on and help evolve.
And those using the app to save or make time or money will happily pay for the premium packs as they get them setup with templates that would otherwise take a longer time to recreate.
I understand per-user licensing for vendor-managed SaaS because users numbers tend to correlate to support requests or expectations.
However, for self-hosted, I hope to encourage you to consider unlimited users and, instead look to premium packs, templates, setups, perhaps with an annual license.
So you have good and repeat income but businesses that have low margins and high user count needs aren't looking at prohibitive scaling costs because if they are self-hosting, they also tend to be self-supporting for 1st-line requests. Consider it support work-sharing
Keep up the great work, I love anything that encourages understanding database design and record-keeping and communications best-practice. I'm sure the world will thank and reward you for your innovation!
Thanks everyone for the warm welcome and for the info.
For now it is okay if Redis doesn't keep the persistent state, so we can use the one that is installed within the Basero app image. Would be nice to use the Cloudron addon in the future once Redis 5 is fully supported. Once the Docker healthcheck is supported we can use that.
Looking forward to your feedback!
I have a quick follow up question. Is it possible for Cloudron to generate a unique secret key and provide that as environment variable? Baserow depends on a secret key to create password reset and invite tokens, but this needs to be unique value for each installation. Otherwise if everyone uses the same key, it will become possible to create password reset tokens which is a security issue.
Something on the lines of (just some pseudo bash here):
if [[ ! -f /app/data/.secret ]]; then echo "SECRET_ENV=$(some way to generate a secret)" > /app/data/.secret fi source /app/data/.secret
Very much depends on how the app consumes this. Sometime like gitlab they have a secrets file like: https://git.cloudron.io/cloudron/gitlab-app/-/blob/master/start.sh#L92
@bram an example here : https://git.cloudron.io/mehdi/river/-/blob/master/start.sh#L64
if [ ! -f /app/data/session.secret ]; then dd if=/dev/urandom bs=256 count=1 | base64 > /app/data/session.secret fi
This will work for my use case. Thanks!
ianhyzy last edited by
This looks like a fantastic tool, can't wait to try it out on Cloudron!
Is the status of this known ? Coming to a cloudron near me soon ??
@timconsidine It's available now, just not in the store. Just follow instructions above and you'll be up and running in no time.
@doodlemania2 Cheers !
This post is deleted!
@doodlemania2 Having trouble with this :
Repeat errors like
App installation error: Installation failed: Unable to pull image tcmbp132021/baserow:1:3:0. Please check the network or if the image needs authentication. statusCode: 400
I can build locally and I can push docker image.
But interestingly docker for desktop reports 3.25Gb locally and repository only 1.1Gb
Does the image need authentication ??
Or maybe there is indeed a network error
And when I run the container locally, it starts and immediately fails
http://ocalhost:3000 doesn't respond and docker for desktop reports not started
I think there is a build problem
Maybe there was some network glitch going on
I did do
docker trustjust in case
But had to delete images multiple times and try again
Anyway now deployed to and working on cloudron - yay !
Thank you @bram !!
@staff any thoughts on publishing Baserow as unstable? I've been using it on and off and it's quite smooth. Not sure what else is needed from a packaging perspective though.
@timconsidine Glad to hear that it now works for you!
@girish Apologies for my super late response. I don't check the Cloudron forum that often, but luckily @tomershivani reached out to me via email notifying me about your question. I would love to have Baserow in the Cloudron app store. I am not sure which steps I exactly need to make. Is there a documentation page about this? Or is it just a matter of creating a new repo on git.cloudron.io containing the files that now live here https://gitlab.com/bramw/baserow/-/tree/develop/deploy/cloudron, add automated tests and you will do the rest? Would love to learn a bit more about this process and help with the automated tests would be much appreciated.
robi last edited by robi
@girish I just created an account on git.cloudron.io, but it seems like I can't create a new repository. When creating a new project I get the error "Namespace is not valid". All the other repo's are in the cloudron project https://git.cloudron.io/cloudron, but it seems like I can't create a new repo there. Am I missing something?
Alternatively, you can find the deploy code in our own public repo and copy it from there https://gitlab.com/bramw/baserow/-/tree/master/deploy/cloudron. It already has an MIT license there.
How would it work in the future if we release a new version of Baserow? Can we deploy the latest version to the app store?
jdaviescoates last edited by
@jdaviescoates That makes sense. I'll await his response.
@bram awesome, I will take it from here! Give me a day or two to look into this.
zagzoog last edited by
I just installed Baseerow on Cloudron. Is perfect for my use case. running beautifully. my question is regarding the web socket. I am not sure how to access it. Baserow is accessible through a sub-domain. what would be the url for the web socket api?
@zagzoog The web socket URL would be on
wss://api.baserow.io/ws/core/?jwt_token=YOUR_JWT_TOKENwhere you would replace api.baserow.io with your self hosted domain. So, if your Baserow copy runs on baserow.example.com, you should replace it with that. Both the backend and the web-frontend run on the same domain in Cloudron. More information about the web sockets and also some examples how to connect directly can be found here https://baserow.io/docs/getting-started%2Fweb-socket-api.
@girish Could you share any progress on having Baserow in the Cloudron App Store?
@bram Not yet, sorry been backlogged a lot. I will get to this soonish. Hopefully next week.
humptydumpty last edited by
@girish just want to remind you about Baserow