“Grist is a relational spreadsheet-database app that I can host on my own server. When I first tried it, it felt familiar because the basic idea is still the same: I get rows, columns, cells, and tables that I can use to organise information. I came across Grist while looking for something that could replace the spreadsheets I use for everyday work. I mainly wanted a simple way to create tables, organise information, and keep track of things without dealing with a complicated interface. The first thing I noticed was that Grist doesn’t try to make spreadsheets feel completely different. I can start with a blank document, add columns, enter information, and use formulas just like I would in a regular spreadsheet.”
I remember way back when the first spreadsheets appeared, many would try to make them work like databases. But the fact is if you have a lot of data, and it needs to reference other data (relational) and be updated, an actual database was usually more robust. Sorting partial columns by mistake in a spreadsheet can completely mess up your data (versus using proper indexes).
So this looks like a pretty good idea. Apart from the database aspect, this can always be available as it does not depend on access to some else’s cloud, and it stays private. It is also accessed via a browser so you need not install anything on your devices, and can work on it from anywhere.
See https://www.xda-developers.com/i-ditched-google-sheets-for-a-self-hosted-spreadsheet or https://www.getgrist.com/product/self-hosted
