What does HackerNews think of grist-core?
Grist is the evolution of spreadsheets.
Language:
TypeScript
#12
in
Awesome Lists
#30
in
Database
You can try Grist. Spreadsheet with Python formula support, and open source. https://www.getgrist.com/
https://github.com/gristlabs/grist-core/
Check out Grist in the ‘Access with sane backend’ space. SQLite, open source and fantastic UX https://www.getgrist.com/ and https://github.com/gristlabs/grist-core
I use and love both Datasette and Grist - they’re complementary.
Sounds like you're describing Grist! And it's open source. https://github.com/gristlabs/grist-core
if you don't need the .xlsx format specifically then something like grist might be something that interest you
https://github.com/gristlabs/grist-core
there's a self hosted option that i tested in docker and it was fairly simple to get set up, but im mainly using the free version at the moment that is hosted by gristlabs themselves.
the thing i love about it is being able to use python to write formulas, and also being able to have multiple views on one page such as a table view and then a card view that shows information from whatever item is selected in the table view.
ive been using it for about a year now and i couldn't see myself ever going back to regular spreadsheets
Another one for the No-code database category. My new favorite, heard about it on HN a few weeks ago - grist!
Ah, we do have a general purpose importer from sqlite lurking but not published, I'll bump its priority. In the meantime, you can use the hosted or local rest api from python or javascript to generate a grist spreadsheet https://support.getgrist.com/rest-api/. On the backend, for serving individual user spreadsheets, we use node/express workers connecting to a pool of sqlite files, persisted via the sqlite backup api https://sqlite.org/backup.html https://github.com/mapbox/node-sqlite3/pull/1116. If you want to dig in, you could poke around at https://github.com/gristlabs/grist-core