Solved Baserow - Airtable Alternative
-
Baserow
https://baserow.io/blog/open-source-release-of-baserow
"Create your own database without technical experience. Our user friendly no-code tool gives you the powers of a developer without leaving your browser"
They have a road map through Nov on their site too: https://baserow.io/
This was also mentioned in: https://forum.cloudron.io/topic/2517/seatable-speadsheet-meets-database
Looks very promising +1
-
@plusone-nick certainly when they get through their 2020 roadmap. Basically looks like what most people want to use GSheets for, without the fluff.
-
@marcusquinn Yeah at least the end of Aug when they implement the REST api.
Besides regular GSheets stuff most of the value is in the API for no/low-code dev imo -
@plusone-nick For no/low-code RAD, checkout Directus since it works on any MySQL DB, has GraphQL, all the standard User, Roles & Perms stuff, and ultimately the underlying DB can be used in any way directly or via API with their GraphQL
It's the best of the bunch for that purpose from my testing at least. I admit it doesn't do multi-user editing of the same thing at the same time al la GSheets - but I've never developed a schema live with other devs that way TBH.
Hopefully coming to a Cloudron near you soon too:
-
@marcusquinn Yeah I am looking forward to Directus, ive dabbled with it and have up-voted the thread. Always good to have a second one in mind & encourage "competition" though lol
-
Following closely. I've offered to package this and seatable as soon as they get ready!
-
@doodlemania2
Not all heroes wear capes +1
-
Been playing with Directus this weekend. It looks quite polished. The main challenge I see right now would be using it against a non-provided DB, which may not be an issue, but something to think about.
Will keep at it! -
@doodlemania2 I think the way to do it would be take an default Directus instance. Export SQL from another App and Import to the Directus DB as I don't think other Cloudron DBs are available outside of their container?
Then as you navigate, it recognises and work with whatever tables there are in the DB. The Directus User, Permissions, Audit Trail tables remain separate.
Personally, I think it would be interesting to take the SQL from another interesting FOSS App that has a dated interface, like GNU Cash or Front Accounting to give it a modern framework.
-
I took the Baserow demo for a spin. It's very basic as of today.
-
@yusf worth further packaging as is or hold off until their road-map is complete and or 1.0?
-
@plusone-nick I donβt see the point of packaging it in the current state, no. Letβs see which one of Baserow, Seatable or other wins the feature race.
-
Seatable is very unstable atm. Hoping directus is better.
-
@doodlemania2 I took Directus for a spin. It's a completely different type of tool, it has very little in common with what Airtable/Notion/Baserow/Seatable does.
-
@yusf yeah, it's more a headless crm as opposed to a shiny simple grid, but they sort of fall into the same category. Definitely still need an airtable alternative!
-
End of the Year Update: https://baserow.io/blog/december-release-of-baserow
All the changes of Baserow version 0.7.0 listed.
- Increased the number size that be used within a number field (by Keith).
- Fixed bug where the row state is never matching if the filter type was set to OR in combination with only one filter.
- Fixed the keyboard navigation of the dropdown items when a search query was provided.
- Added filtering by GET parameter support to the rows listing endpoint.
- Fixed drifting context menu when you scroll or resize the window.
- Create and update timestamps are now stored when the groups, applications, tables, views, fields and rows are created or modified.
- It's now possible to change a file name.
- Added the possibility to insert a new row above or below an existing row.
- Made it possible to include or exclude specific fields when listing rows via the API.
- Implemented the single select field.
Real time collaboration Coming In Jan!
-
Hello everyone, my name is Bram Wiepjes and I am the founder of Baserow. I have created a Baserow Cloudron app. More information can be found here: https://forum.cloudron.io/topic/4389/baserow-cloudron-app.
-
@bram
+1
-
@bram Hey Bram - welcome and thank you! Cloudron's a great place to get more feedback and win some fans and promoters for what you do!
-
@Staff by the sounds of it this should perhaps be marked as a WIP?
-
There are docs at https://baserow.io/docs/guides/installation/install-on-cloudron if someone wants to try.
-
@girish Will Baserow be available as an official app on the appstore?
-
@ctrl I guess the idea here is that early adopters help test first, find any issues and give feedback to confirm when ready for general release.
-
@ctrl I don't see why not.
Has anyone here played with the app (you can sign up on baserow.io as well) and had any thoughts/comments?
-
-
@doodlemania2 said in Baserow - Airtable Alternative:
working with @robi on finishing up BBB and Nextcloud HPBE (standalone)
Awesome!
I only just spotted that BBB 2.3-beta-1 is out https://github.com/bigbluebutton/bigbluebutton/releases
This is off-topic, but I assume that's work you're working with that version?
-
@jdaviescoates yep
-
@bram Baserow looks really promising! I just took it for a spin using Cloudron. I am would like to connect to the postgres database, but I really can't seem to find it. When I connect to the app by the terminal, there is no Postgres process running. Similarly, in the supervisor file I see no mention of postgres. Yet in all evidence, baserow is running smoothly so surely the database is running somewhere, I just can't seem to find where. Some help would be greatly appreciated.
-
@nikosgpet The Baserow I'm using looks okay:
I haven't figured out the default username and password yet haha, so if you have that laying around, that'd help me out too!
-
@nikosgpet Hi @nikosgpet, thanks! I am glad that you like Baserow. The PostgreSQL server is not installed in the Cloudron app. We use the Cloudron PostgreSQL addon, which runs in a different kubernetes pod. In the terminal, you should be able to execute
PGPASSWORD=${CLOUDRON_POSTGRESQL_PASSWORD} psql -h ${CLOUDRON_POSTGRESQL_HOST} -p ${CLOUDRON_POSTGRESQL_PORT} -U ${CLOUDRON_POSTGRESQL_USERNAME} -d ${CLOUDRON_POSTGRESQL_DATABASE}
to access the PostgreSQL database. -
@doodlemania2 Are you looking for a default username and password of Baserow?
-
@bram correct, once i install from the baserow docs, i guess i need a default u/p in the case baserow isn't set up with cloudron ldap auth access.
-
I realize folks are looking at how this space devlops, but I thought I would share this baserow release info I just stumbled upon
https://baserow.io/blog/april-2021-release-of-baserow -
@doodlemania2 A default user is not created after installation. One could be created via the command line
/app/code/env/bin/python /app/code/baserow/backend/src/baserow/manage.py createsuperuser
or via the signup page. The first user that signs up via the signup page is automatically getting staff/admin rights. -
@bram One for the App's first-use instructions I guess?
Until you get all LDAPy happy with us
-
Im unfortunately not able to install. Ideas?
App installation error: Installation failed: Unable to pull image registry.gitlab.com/bramw/baserow/cloudron:1.3.0. Please check the network or if the image needs authentication. statusCode: 500
I tried the last two Version- same Answer.
Update
I builded the Image locally und pushed to Private Registry Docker. Everything fine and working. -
I have now published Baserow in our app library. Currently still of course marked as unstable, but now everyone interested may install it directly and please provide feedback.
We have a new forum section for this at https://forum.cloudron.io/category/136/baserow
I will close this topic then.
Thanks a lot to @bram for both the stellar initial packaging and of course also the app itself! Very well done
-
nebulon