Baserow - an Open Source, Self Hosted, No Code Database alternative to Airtable.

The amazing folks over at Baserow reached out to me, and have kindly offered up a discount code for all of you to take advantage of on their paid plans. This code is good through August 20, 2022.
Take advantage of this code to get 10% off of your first paid transaction for Premium, Advanced, or Enterprise license plans.
That's right, if you pay for 1 year of Premium, Advanced or Enterprise you'll get 10% off for that first year.
If you only want to go monthly at first, not to worry, you still get 10% off that first month by using the discount code they provided.
ADDITIONALLY! You could win 1 year of their Premium level service at no cost to you by leaving a comment on this video, and giving them your most creative idea for a way to use Baserow. They will look through the comments for their favorite ideas, and award the winner with 1 year of Premium at no cost. So good luck and let's see those comments!
====== Here is the Poll Link I Promised ======
base.routemehome.org/form/iDdz...
=== Links ===
Show Notes
wiki.opensourceisawesome.com/...
Baserow Home Page
baserow.io
Baserow Github
github.com/bram2w/baserow
Support my Channel and ongoing efforts through Patreon:
www.patreon.com/bePatron?u=23...
=== Timestamps ===
00:00 Beginning
00:09 About Baserow
02:45 Baserow Special Offer Teaser
03:10 Thank you to my Patrons over at Patreon, and my subscribers on KZbin
03:50 A Baserow User Interface Overview
10:15 Installing Baserow with Docker
17:40 Bring Up Baserow
18:35 Setup NGinX Proxy Manager to get to Baserow from outside my network
19:00 Our First Run on Baserow
21:20 Create our First Database and App in Baserow
32:00 The Baserow Discount and Comment Contest Information
=== Contact ===
Twitter: @mickintx
Telegram: @MickInTx
Mastodon: mastodon.partecipa.digital/ @MickInTX
Try out SSDNodes VPS Services! Amazing Specs for incredibly low costs. I'm running a 32 GB RAM / $ CPU Server for only $9 a month! Seriously. FOr long term server usage, this is the way to go!
www.ssdnodes.com/manage/aff.p...
Get a $50.00 credit for Digital Ocean by signing up with this link:
m.do.co/c/a6a61ae55242
Use Hover as your Domain Name Registrar to get some great control over you domains / sub-domains:
hover.com/SHPaiirr
Support my Channel and ongoing efforts through Patreon:
www.patreon.com/bePatron?u=23...
What does the money go to?
To Pay for Digital Ocean droplets, donations to open source projects I feature, any hardware I may need to purchase for future episodes (which I will then give to a subscriber in a drawing or contest).
=== Attributions ===
Intro and Outro music provided by www.bensound.com

[@petertlatlaa6492]

You always bring valuable knowledge & software(Open Source), This GUI product is the way to go. Great job man!

[@AwesomeOpenSource]

Glad you think so!

[@john_turner]

Dude I just had so many ideas we could use this for. I work for a non profit so we use quite a few open source software and self hosted offerings. I am already pretty much in love with this product, but having some basic way to do an approval flow built in would totally round this product out. I have went back through and watched a ton of your old videos on things you have found I didn't even know existed. Thank you for all the cool things you continue to show us!!!!

[@AwesomeOpenSource]

I'm supre glad Baserow looks goot for you, and so happy my past content is helping as well.

[@john_turner]

@@AwesomeOpenSource yeah keep up the good work buddy.

[@baserow]

Hey John, Baserow integrates with other automation/integration platforms like n8n, Zapier, and Make to facilitate this type of approval flow, but we're also working on an Automation Builder. 👀 Stay tuned!

[@lukeo4435]

Excellent discussion of what a webhook is and how they can be used. Many thanks!

[@AwesomeOpenSource]

Glad it was helpful!

[@alexanderfriedrich3700]

So here is my Use Cases & Feature request: GraphQL support, like what Stapi offers, would be a killer feature for Baserow. So that I could use Baserow as my Django-based Backend that is my Database/-source for WeWeb (a fronted builder for scalable no code react and vue based web-apps). I love building the front end in WeWeb using their GraphQL integration, so a dynamic Baserow GraphQL endpoint would be perfect. While WeWeb has a good rest API integration (which Baserow already supports), that can be used instead of GraphQL, the development experience with GraphQL is something else I don't want to miss. Basedow is what I've been looking for (since it's Django-based and open source). What a great video! Thanks for sharing!

[@AwesomeOpenSource]

Love it!

[@MrGarfield]

04:52 That was very funny to hear 🙂 You pronounced Deutch as Dutch / but Nederlands = Dutch and Deutch = German However i'm new to your channel and watched a lot of video's already i love your way to make thinks clear. I don't remember what video it was but i was searching for some Wireguard information and i got it up and running in about 5-10 minutes on my Local & VPS after watching your video about that🙂 I was looking for an particular setup way to access things and Wireguard does this out of the box if you just enter the IP subnets 🙂

[@AwesomeOpenSource]

First, glad you're here. And yes, it just didn't register that it was deutch (German), not dutch... I'm learning. As for Wireguard, it is an amazing project for sure! As is Baserow!

[@markattila9835]

A man who uses nano is by definition a good man!

[@AwesomeOpenSource]

100%

[@ArsalanAli-ge3uz]

Love your work man!

[@AwesomeOpenSource]

Glad you enjoy it!

[@baserow]

Nice video, thanks making it!

[@AwesomeOpenSource]

You bet!

[@wizdude]

Thanks for the video. This looks great and I’m wondering if I can use this with a client to setup a booking workflow. They have a head office that takes calls and assigns jobs to on-site people. The on-site people do the job and then populate the remainder of the form to finish it off. The client already has something they have designed with another SaaS product but I want to see if Baserow could achieve the same result with less pain. Cheers 😊

[@AwesomeOpenSource]

Yes, absolutely

[@baserow]

This is definitely possible-feel free to jump into the community if you need any guidance in building this!

[@chianasgeek6730]

Hehe. Nederlands is Dutch. Deutsch is German 🙂x

[@AwesomeOpenSource]

Well, I'm learning as I go. Thank you for that information. I should have known it.

[@jayvl09]

I use memento on android. They can link with Google sheets for cloud access (Sheets is text data only though). I like the 1 tap input shortcut but their import/export is nonstandard. I'll look into this, structured input is so useful for smartphone notes as I hate typing, but cloud access and standardized formats are major features for my database usage...

[@AwesomeOpenSource]

Very cool. This may just work for you.

[@HERALDHERALD]

I'd use it for my start up to offer event/outreach assistance to coalitions of international civil society orgs. They need tech too.

[@AwesomeOpenSource]

That's a heck of a great idea.

[@rollycervantes1326]

Hi awesome video as always, I have question how did you make nginx to work applying SSL mine have an internal error. hope you can help me thanks cheers

[@AwesomeOpenSource]

I just went to double check and make sure, but I didn't do anything special. Can you ping me at discuss.opensourceisawesome.com? I'm @ mickintx, and perhaps I can help you out.

[@silnitesh]

Hi, loved your video. I am trying to set up a webhook from baserow to rocketchat but I am getting a error 503 when I check the baserow trigger test. Can you please help me with this?

[@AwesomeOpenSource]

Jump over to the chat on discuss.opensourceisawesome.com and I'll see if I or anyone there can help.

[@RobH8210]

Would definitely want an implement an inventory system. Think i'd want to catalog all items in my home and make the export transferrable into the cloud in case something happens to my house and I need it for insurance, or reference to replace or see what I own.

[@AwesomeOpenSource]

Excellent idea. I've been meaning to do something just like that in fact. Thanks for that.

[@RobH8210]

@@AwesomeOpenSource no problem. I'm a IT architect during the day and really been using your videos to get back up to speed as my day job just changed to be less people and more software oriented again.

[@FaisalAbdin-pc4hb]

Hello, could you do a video on Saltcorn as well? Its a no-code platform; basically an interface to manage databases and build apps upon it. Its very good but not a lot of guides that are easy to understand and deploy for the average user. Thank you in advance. Keep up the great work :)

[@AwesomeOpenSource]

Let me see what I can find on it.

[@TareqSojol]

Hey Brian, Following for a long time but just pulled up the courage to setup my own server. It has been two days and I already figured out nginx. I wanted to set up baserow and nocodb badly. I was good with nocodb, but baserow setup conflicts with port 80 and 443. in the video you mentioned that you will show where to make change for the port, but I couldn't noticed where you said that. Can you please elaborate on that. I am stuck on the port!!

[@AwesomeOpenSource]

So, in the .env file when I was talking about the caddy port, that's where you want to make that change. Then in the docker-compose file you'll need to make that same change for caddy in the caddy section. That should do it. Just make caddy listen on a different port, and then use NPM to send the traffic to that port.

[@TareqSojol]

@@AwesomeOpenSource Thanks Brian. I tried baserow. but it wasn't good enough to use in my business. I found another awesome open source tool. Grist. Its a wonderful app. You can selfhost too, although the team version is much more painful to host with authetik. You should give it a look and do a video on it if you like. Anyways, Stay Awesome!

[@AwesomeOpenSource]

Thanks for the suggestion. I've looked at Grist in the past, but wasn't ready to cover it, maybe I need to take another look.

[@perpetuel7118]

Great content, thanks👍. Do you think that it is possible to create a multi tenant web app with baserow as the database. I already did a web search and didn't find any answer to that.

[@AwesomeOpenSource]

It could be. Just depends on how you structure your tenant separation.

[@Michael201078]

Big like for this video

[@AwesomeOpenSource]

Thanks for liking, glad you enjoy it.

[@scintillarebd8596]

Awesome video, any plan to create a video on hosting Gristlabs/Grist?

[@AwesomeOpenSource]

I'll take a look at it.

[@imoldovan]

Besides the good content I also like the lack of floating talking head. :)

[@AwesomeOpenSource]

hahaha. No one really wants to see my head floating around... they want the Open Source.

[@jasonharper6765]

Nice video. Just what I was looking for. However the promo code is not working on the baserow site.

[@AwesomeOpenSource]

Sorry, yeah, the promo code was time limited, and this was last summer when I made the video.

[@Amanmalviyadance]

These instrunctions are not working anymore, if you use the current pull from baserow git repository and run the docker-compose.yml file , you get an error : port 5432 failed: FATAL: password authentication failed for user "baserow" on docker-compose up . I have followed the steps exactly as mentioned. Please help me on fixing this for the latest version

[@AwesomeOpenSource]

Sorry to hear that. I haven't tried this one in a while. They have likely made updates since this video was made. I'll see if I can figure out what has changed, and update my documentation.

[@DuncanCunningham]

Question: Baserow is cost per user. Does that mean those building the apps or users filling out the forms. If it's for those filling out the forms, then this won't work for us, we have thousands of users filling out forms but very few building the apps.

[@AwesomeOpenSource]

Hmmmm. Not sure how they charge actually. Let me ping my contact and see if I can get some details for you.

[@baserow]

Hi Duncan, if you're just sharing the forms to be filled out, you wouldn't be charged for that, no. Only certain types of roles get charged as users. You could have one user creating forms and have those shared forms filled out by thousands of people. In that case, you'd only pay for one user.

[@k36242]

I can used to request items for my inventory system...

[@AwesomeOpenSource]

Indeed. Love it.

[@mohammadalhamad1809]

what version of ubuntu you used please

[@AwesomeOpenSource]

This was probably on a 20.04 server, but the application was really running in docker, so any version of ubuntu for the host would work.

[@postermelone6761]

Please do Shuup as well, its an open source multi-vendor marketplace.. tile desk and Shuup,.. these request have huge desperation and obsession behind them due to how effective they might be, another request may be the fediverse packs, like funkwhale, which comparably could be better than the other music streaming software solution.. You Santa now i guess

[@AwesomeOpenSource]

I'll see what I can find. No guarantees on when.

[@mohamedatef8424]

There anyway to make page to have like Search bar to get back value I men like " sql querry"

[@AwesomeOpenSource]

The filtering will let you narrow down results, is that what you're asking? There is a search in the upper right for the search bar.

[@mohamedatef8424]

@@AwesomeOpenSource no, i men when u make database backend like mysql U was need to make website to have input text type and make querry to collect that input to store in database, and when user wana search go to website and put value and press button to get querry to get data from database! There anyway to make something like that or all i need to do and user in web page of program right?

[@Aloysius1966]

You should compare Baserow with Saltcorn.

[@AwesomeOpenSource]

I'll see what I can do.

[@Booboo81810]

baserow or nocosdb for an e-commerce startup?

[@AwesomeOpenSource]

I haven't tried NocoDB, so not sure I could give you any advice on it, but Baserow was super easy to use, which for me is really nice. For eCommerce, definitely depends on what you're trying to build with any of these systems.

[@Booboo81810]

@@AwesomeOpenSource from what I read, if I have no IT background I should stick with baserow. What do you use Baserow for ? I am not sure now because I am still in the early stages but in the beginning, I’d probably use it for employee records. Would this app be sufficient for inventory management? I was looking into sortly for it though. And how about creating POs with this app?

[@mikewashington4188]

Can use it on a website?

[@AwesomeOpenSource]

I used it to generate a page that allowed people to take a poll, and baserow employees use it for things like that all the time. As fro embedding it in an iFrame or something, you will need to check their documentation.

[@baserow]

Yes, you can embed Database Builder views on a website. You can also bring in s into Application Builder!

[@ericbenjaminjr]

Wee correction: If I read that correctly, it’s Deutsch and not Dutch. Which means German.

[@AwesomeOpenSource]

Indeed it is Duetsch (German). My bad.

[@postermelone6761]

Pleaso do tiledesk, please

[@AwesomeOpenSource]

Let me look into it and see if I can figure out what it's about. No guarantees, but added it to my list.

[@postermelone6761]

Heaven sent you are, if id have money id be on that list, when i do its on top of the list@@AwesomeOpenSource

[@luiggiphilipi]

Sadly this tutorial doens't work anymore.

[@AwesomeOpenSource]

It doesn't, but I'm looking into how to set it up. I'll let you know if I find where it changed, and update the documentation.

[@garrysingh4484]

Make Detailed Video On - Shinobi NVR - Bluecherry DVR - Any Other NVR that also work on Macos - xRDP Access Linux From Windows or Mac Using xRDP (Detailed) - FFmpeg (How to add local usb webcam to NVR as FFmpeg - "FFmpeg because it supports Audio recording as well" ZoneMinder) Please also include installation on bare metel linux distro - not only for containera or proxmox !!!

[@AwesomeOpenSource]

I have a video on Shinobi, iSpy Agent DVR, Frigate NVR, and Zoneminder. I'm not sure Bluecherry is open source, but I'll check it out to see. Asf ro containerized vs. non-containerized, I focus on containers, because they give you so much more capability to run multiple applications, and not create a giant file system mess. But I do perform standard installs when the software calls for it. Thanks for the ideas, and for watching!

[@garrysingh4484]

@@AwesomeOpenSource I saw your ZoneMinder video, its great video - Everything working fine with Zoneminder except audio - i have a spare Logitech usb webcam, its been sitting for few years never used it - it works great if i use it as "local" camera but - After some research i found out that to get the video and audio i have to add it as ffmpeg, and i am finding it very hard to set it up - it does work with ffmpeg, and supports both audio video if i run it with ffmpeg through terminal command but Zoneminder is not accepting the ffmpeg configuration - ??? May be if you can make video specifically on ffmpeg - it can be used in a variety of softwares

[@TechySpeaking]

First

[@AwesomeOpenSource]

Nice.

[@steffikroschel3278]

👍 𝚙𝚛𝚘𝚖𝚘𝚜𝚖

[@minyoi6843]

I'm getting an error cannot mount caddy. I've looked everywhere with no solution. Has anyone faced this before? Error response from daemon: failed to create task for container: failed to create shim task: OCI runtime create failed: runc create failed: unable to start container process: error during container init: error mounting "/Caddyfile" to rootfs at "/etc/caddy/Caddyfile": mount /Caddyfile:/etc/caddy/Caddyfile (via /proc/self/fd/9), flags: 0x5000: not a directory

[@AwesomeOpenSource]

So, it may be a permissions issue. You might want to check the Baserow docs and see i they'ave added something for differing permissions needed. Also, did you already have docker / docker-compose, or did you install it for this specifically? If you installed it for this, then you may need to add your user to the docker group, and then log out, and back in in order to get the new group chnages to take effect.

[@minyoi6843]

@@AwesomeOpenSource thanks for your feedback. I'm working on an appgyver side hustle project so I'm looking forward to more videos in case I see a free or affordable self host db solution that works well.