Grist | The Evolution of Spreadsheets

[walski]

I've a version of Grist running on our Cloudron as well. It's using OIDC through oauth2-proxy (https://oauth2-proxy.github.io/oauth2-proxy/) but needs a bit more polishing. E.g. I've disabled Grist's sandboxing, which I want to fix.

Word of warning: The performance so far is not mega great in my preliminary testing. Feels quite sluggish on our little box.

[jdaviescoates]

@walski said in Grist | The Evolution of Spreadsheets:

I've a version of Grist running on our Cloudron as well.

Great stuff!

Add it to a repo to the Cloudron GitLab?

@walski said in Grist | The Evolution of Spreadsheets:

our little box.

How little?

[walski]

Ok turns out, that Grist releases after Sept. 11th come with a broken pyodide sandboxing layer (see https://github.com/gristlabs/grist-core/issues/734).

I got everything running using an earlier Grist release (1.1.4 from Sept 8th or so). Before this can be considered for the app store I need to polish the metadata, etc. But you should be able (we do) to install it to your Cloudron using the CLI.

Repo is here: https://git.cloudron.io/walski/grist-app

How little?

16GB RAM, 6 core AMD whatever virtual server. Currently running 13 apps through Cloudron.

[jdaviescoates]

@walski said in Grist | The Evolution of Spreadsheets:

16GB RAM

Yeah, that's not much RAM really (especially if you're running some RAM heavy apps), so possibly not surprising it's running slow. I wonder how it'd be if you had more resources... I guess once that issues is resolves and we get it into the Cloudron App Store we'll find out!

Thank you for your efforts, much appreciated

[walski]

Side-note: Looks like direct OIDC support just landed on Grist's main https://github.com/gristlabs/grist-core/pull/717

[plusone-nick]

@walski if its not DNS its RAM

[kymj8]

Grist is now available for YunoHost. It was announced in the Grist Community November 2023 Newsletter.

Looking for a simpler way to self-host Grist? Florent has also packaged Grist on YunoHost, a Debian-based OS designed to help democratize self-hosting. Check out Florent’s post in our forum for more information.

The post:
Self-hosting Grist made easy with Yunohost
https://community.getgrist.com/t/self-hosting-grist-made-easy-with-yunohost/3692

In the YunoHost Application Catalog:
https://apps.yunohost.org/app/grist

And on GitHub.
https://github.com/YunoHost-Apps/grist_ynh

This seems like a good sign for us here.

[walski]

Yip, they released v1.1.9 on Dec 2nd. That release includes the pyodide fix to run Grist sandboxed within Cloudron, as well as their direct OIDC support (see docs: https://support.getgrist.com/install/oidc/#openid-connect).

I'm more than happy to incorporate these onto my branch and that should then give us a decent to maybe get it into the app store? I just can't promise a timeline right now

[seeker]

New release highlights below.
I like that there is a desktop app. Has anyone been able to play with it. I assume it integrates with the cloud app? Sometimes it is nice to be able to take things offline.

Released: Grist v1.1.11
Highlights from recent releases:

Forms - design forms and surveys right within Grist and watch the data roll in live. Each field is automatically tied to a spreadsheet column so analysis is super simple. https://www.getgrist.com/forms/

New calendar widget for displaying dates. https://support.getgrist.com/widget-calendar/

Advanced Chart and JupyterLite Notebook custom widgets - very powerful for advanced dataviz and Python work.

https://support.getgrist.com/widget-custom/#advanced-charts
https://support.getgrist.com/widget-custom/#jupyterlite-notebook

Formula lookups and shortcuts for adding common formulas and lookups. https://support.getgrist.com/newsletters/2023-10/#formula-shortcuts

Record cards that make it much easier to navigate and edit referenced data (a huge part of what makes Grist useful). https://support.getgrist.com/record-cards/

GitHub repo: https://github.com/gristlabs/grist-core
Grist overview: https://www.reddit.com/r/selfhosted/comments/su6tv3/grist_free_open_source_alternative_to_airtable/ Interactive demo (no login required):
https://docs.getgrist.com/

[robi]

@walski said in Grist | The Evolution of Spreadsheets:

Repo is here: https://git.cloudron.io/walski/grist-app

How's it running these days?

Have you added the easy-install.sh script yet?

[seeker]

Just discovered grist has two pages of webinars that could be helpful for onboarding. Getting people to use tools... videos are helpful.
https://www.getgrist.com/webinars/

[jc147]

Hello, is there any progress on the integration of Grist with Cloudron? I can't wait for this to happen!

[jagan]

The addition of AI to grist to query data in natural language is a game changer - creates the python code needed and no-code developers can create all sorts of reports, graphs and charts.

Others will catch up ultimately, but for now, Grist is ahead.

[jdaviescoates]

@jc147 said in Grist | The Evolution of Spreadsheets:

I can't wait for this to happen!

Yeah, it'll be great to have Grist and to be able to integrate it with Outline!

[avatar1024]

Hello, I wonder, is anyone is working on this? Seems like grist is ahead of the others regarding what it offers in the self hosted version.

[umnz]

+1 also take my upvote for Grist. A solid alternative to Nocodb.

[SamGreenwood]

+1 also think this would be great

[jdaviescoates]

@SamGreenwood upvote the original post

[marylou]

OMG, Grist looks amazing!! It looks like it shows referenced (aka linked) data values rather than just "2 linked values" as Nocodb does. And it comes with granular access rules. And it supports most Excel functions?? I would like to hereby add ten votes.

[cstork]

Yes, definitely interesting. Maybe finally a feasible replacement for some google sheets of mine...