an interesting approach, how about doing the heavy lifting in an api backend and pushing/pulling data to the sheet using a custom formula? that way you would be able to leverage the full power of a db backend
A Relational Spreadsheet
11–20 of 77 posts
Re: A Relational Spreadsheet
#12Excel has get and transform that makes this easy + an odbc provider (you can query excel as an sql database).
A reminder for everyone excel web is actually entirely free and you can create stuff with https://excel.new
We spent a lot of time making it faster and rewrote a bunch of it ^^
(I'm just an engineer, I don't speak for my corporate overlords)
Re: A Relational Spreadsheet
#13What about MS Access. I used to use it years ago. It was amazing how simple it was to create and deploy an application based on relational data.
Northwind gives me shivers
Re: A Relational Spreadsheet
#14Excel has get and transform that makes this easy + an odbc provider (you can query excel as an sql database). A reminder for everyone excel web is actually entirely free and you can create stuff with https://excel.new We spent a lot of time making it faster and rewrote a bunch of it ^^ (I'm just an engineer, I don't speak for my corporate overlords)
How's Excel web's feature parity?
Re: A Relational Spreadsheet
#15Grist?
Yeah I was going to say the same. For the unfamiliar it's an open-source collaborative spreadsheet program that can be self-hosted and shared within your org. The sheets themselves are actually sqlite tables, which brings some constraints you might not get with traditional spreadsheet software.
I believe it also allows you to run python code for data processing and jobs
Re: A Relational Spreadsheet
#16What about MS Access. I used to use it years ago. It was amazing how simple it was to create and deploy an application based on relational data.
Also using Access as a front end on top of MSSQL server.
Re: A Relational Spreadsheet
#17I want the same, I want it so much that I have been working on gasp gui code to do such, an activity I have found I am profoundly bad at. But the theory is, I love the relational database, they are a sort of rigorous superset of the spreadsheet, and I have replaced all my spreadsheets with database tables, however while it is very hard to beat sql for rich comprehensive data transforms and analysis, ad-hoc data entry…
I wonder if you drag Notebooks a bit back toward spreadsheets if there’s a product there.
Re: A Relational Spreadsheet
#18Excel has get and transform that makes this easy + an odbc provider (you can query excel as an sql database). A reminder for everyone excel web is actually entirely free and you can create stuff with https://excel.new We spent a lot of time making it faster and rewrote a bunch of it ^^ (I'm just an engineer, I don't speak for my corporate overlords)
excel.new has a "weird" TLD, no mention of Microsoft in the domain and asks me to auth with my Microsoft account before I can even see the site. If I came across this in the wild, I'd for sure think this is some phishing or generally bad website.
Re: A Relational Spreadsheet
#19The UI is kinda nice. I'd love something like that for plain old SQLite.
Re: A Relational Spreadsheet
#20Excel has get and transform that makes this easy + an odbc provider (you can query excel as an sql database). A reminder for everyone excel web is actually entirely free and you can create stuff with https://excel.new We spent a lot of time making it faster and rewrote a bunch of it ^^ (I'm just an engineer, I don't speak for my corporate overlords)
That link took me through 6 redirects, at least 2 rendered flashes of various colors in the browser.
I love Excel, BTW :) just wanted to let you know in case you want to make it even faster (and easier to onboard presumably based on the domain).