Grist | The Evolution of Spreadsheets

[Aizat]

@timconsidine Thanks for the enthusiasm! Happy to share.

[marcusquinn]

Just seen this - looks very nice!

• https://templates.getgrist.com/doc/afterschool-program
• https://templates.getgrist.com/doc/lightweight-crm
• https://templates.getgrist.com/doc/investment-research

[Aizat]

@girish hey! What do you think about this app? Not sure how it will be packaged or the amount of work required in order to have it here, yet how feasible is it for packaging this app for Cloudron in your opinion?

[ApplegateR]

@Aizat +1 this is amazing and clean on webgui!

[robi]

This looks pretty straight forward to package as a TS node app with a Python 3.9 component.

There is a nice list of files to copy for each in the Dockerfile as well as a set of configurable paths and environment variables for tuning to Cloudron app needs.

If you care to give it a stab, it will help @staff get a head start to get a package to the app store for testing.

[timka]

So is this like baserrow alternative with additional diagrams?

[kymj8]

This week I noticed this new feature in Outline which has been here in the App Wishist category:

• Added support self hosted Grist

I have been running Outline for 3 months (on a service similar to, but not as refined as Cloudron). I did do a quick test of embedding a Grist table -- not selfhosted -- into an Outline wiki post.

I am not capable of testing the selfhosted version not sure if either of these apps is the way I want to go long term. (If it is not on Cloudron, under a domain I have, getting safely backed up in a way I can recover or extract my data, it might as well not exist.)

I see above where @Aizat said in Grist | The Evolution of Spreadsheets:

Also REST API support makes it easy to integrates with other apps.

This part does sound promising. My goal for years has been to embed some simple table data with sorting/filtering in a blog post, web page, wiki/PKM tool, etc., and update that data elsewhere.

Baserow and NocoDB are already here on Cloudron. This is an exciting category.
As seen with the OIDC supported apps here, integration can bring a lot of value.

[timconsidine]

Thank you to @kymj8 for 'reviving' this topic.
Definitely would be a good addition to Cloudron.

And for those who can't wait or want to try it, I notice there is an Electron desktop app : https://github.com/gristlabs/grist-electron

[Sam_uk]

I gave up on Baserow when I realised any user could delete all the data (by design) https://community.baserow.io/t/protect-users-from-deleting-table-and-or-database/1282/10?u=sam_uk

Been playing with Nocodb which is OK, but I don't love it.

Someone mentioned this too me today, so here I am bumping it.

[jdaviescoates]

@Sam_uk said in Grist | The Evolution of Spreadsheets:

I gave up on Baserow when I realised any user could delete all the data (by design) https://community.baserow.io/t/protect-users-from-deleting-table-and-or-database/1282/10?u=sam_uk

Until, of course, you're on their Advanced plan which is $20/user/mo https://baserow.io/pricing (that's more for one user than the cost of Cloudron when paying annually!)

[ianhyzy]

I've been using their cloud version and it's great - much nicer than baserow or nocodb.

[jdaviescoates]

Now we've got Outline which integrates with Grist, I really want Grist too!

Screenshot from Outline:

[jdaviescoates]

This post is deleted!

[avatar1024]

I agree, I also think this is looking much more user friendly than both Baserow and NocoDB so it could be really useful to have (+ as @jdaviescoates pointed the Outline integration which would be fantastic to have). Looks like the future to me

[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