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 KZread
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

Пікірлер: 81

  • @petertlatlaa6492
    @petertlatlaa64922 жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

    Glad you think so!

  • @john_turner
    @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

    @AwesomeOpenSource

    Жыл бұрын

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

  • @john_turner

    @john_turner

    Жыл бұрын

    @@AwesomeOpenSource yeah keep up the good work buddy.

  • @baserow

    @baserow

    20 күн бұрын

    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
    @lukeo4435 Жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

    Glad it was helpful!

  • @alexanderfriedrich3700
    @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

    @AwesomeOpenSource

    Жыл бұрын

    Love it!

  • @ArsalanAli-ge3uz
    @ArsalanAli-ge3uz2 жыл бұрын

    Love your work man!

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

    Glad you enjoy it!

  • @markattila9835
    @markattila9835 Жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

    100%

  • @baserow
    @baserow20 күн бұрын

    Nice video, thanks making it!

  • @AwesomeOpenSource

    @AwesomeOpenSource

    14 күн бұрын

    You bet!

  • @MrGarfield
    @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

    @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!

  • @jayvl09
    @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

    @AwesomeOpenSource

    Жыл бұрын

    Very cool. This may just work for you.

  • @chianasgeek6730
    @chianasgeek6730 Жыл бұрын

    Hehe. Nederlands is Dutch. Deutsch is German 🙂x

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

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

  • @HERALDHERALD
    @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

    @AwesomeOpenSource

    Жыл бұрын

    That's a heck of a great idea.

  • @Michael201078
    @Michael2010782 жыл бұрын

    Big like for this video

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

    Thanks for liking, glad you enjoy it.

  • @imoldovan
    @imoldovan2 жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

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

  • @FaisalAbdin-pc4hb
    @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

    @AwesomeOpenSource

    Жыл бұрын

    Let me see what I can find on it.

  • @wizdude
    @wizdude2 жыл бұрын

    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

    @AwesomeOpenSource

    2 жыл бұрын

    Yes, absolutely

  • @baserow

    @baserow

    20 күн бұрын

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

  • @RobH8210
    @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

    @AwesomeOpenSource

    Жыл бұрын

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

  • @RobH8210

    @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.

  • @scintillarebd8596
    @scintillarebd8596 Жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

    I'll take a look at it.

  • @k36242
    @k362422 жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

    Indeed. Love it.

  • @postermelone6761
    @postermelone67614 ай бұрын

    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

    @AwesomeOpenSource

    4 ай бұрын

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

  • @rollycervantes1326
    @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

    @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.

  • @TareqSojol
    @TareqSojol9 ай бұрын

    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

    @AwesomeOpenSource

    9 ай бұрын

    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

    @TareqSojol

    9 ай бұрын

    @@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

    @AwesomeOpenSource

    9 ай бұрын

    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
    @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

    @AwesomeOpenSource

    Жыл бұрын

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

  • @Aloysius1966
    @Aloysius1966 Жыл бұрын

    You should compare Baserow with Saltcorn.

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

    I'll see what I can do.

  • @silnitesh
    @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

    @AwesomeOpenSource

    Жыл бұрын

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

  • @DuncanCunningham
    @DuncanCunningham7 ай бұрын

    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

    @AwesomeOpenSource

    7 ай бұрын

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

  • @baserow

    @baserow

    20 күн бұрын

    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.

  • @jasonharper6765
    @jasonharper6765 Жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

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

  • @ericbenjaminjr
    @ericbenjaminjr Жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    Жыл бұрын

    Indeed it is Duetsch (German). My bad.

  • @mohammadalhamad1809
    @mohammadalhamad18092 ай бұрын

    what version of ubuntu you used please

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 ай бұрын

    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
    @postermelone67615 ай бұрын

    Pleaso do tiledesk, please

  • @AwesomeOpenSource

    @AwesomeOpenSource

    4 ай бұрын

    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

    @postermelone6761

    4 ай бұрын

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

  • @mohamedatef8424
    @mohamedatef84242 жыл бұрын

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

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

    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

    @mohamedatef8424

    2 жыл бұрын

    @@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?

  • @mikewashington4188
    @mikewashington4188 Жыл бұрын

    Can use it on a website?

  • @AwesomeOpenSource

    @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

    @baserow

    20 күн бұрын

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

  • @TechySpeaking
    @TechySpeaking2 жыл бұрын

    First

  • @AwesomeOpenSource

    @AwesomeOpenSource

    2 жыл бұрын

    Nice.

  • @garrysingh4484
    @garrysingh44842 жыл бұрын

    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

    @AwesomeOpenSource

    2 жыл бұрын

    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

    @garrysingh4484

    2 жыл бұрын

    @@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

  • @steffikroschel3278
    @steffikroschel3278 Жыл бұрын

    👍 𝚙𝚛𝚘𝚖𝚘𝚜𝚖

  • @minyoi6843
    @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

    @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

    @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.

Келесі