Show HN: Build auto-updating dashboards in a spreadsheet

Re:Show HN: Build auto-updating dashboards in a spreadsheet by airstrike on Wednesday February 15, 2023 @01:49PM (#34808679)

Cool idea, congrats! Have you run into any performance issues with "Very Large" spreadsheets (>1M rows) given that this is running in the browser? Or can JS power something like that these days?

Separately how does the SQL querying work? Do you just pass the query along on the connection to an external database or are you running a query engine on the data that's available to the app?

[ Parent | on HN ]

Re:Show HN: Build auto-updating dashboards in a spreadsheet by benmcredmond on Wednesday February 15, 2023 @01:55PM (#34808760)

Thanks!

Today we have a cap of 200k rows per sheet – this is a level where we feel performance is acceptable. We actually just doubled the limit from 100k and we have a plan to get to 1M rows by EOY. Definitely some meaty performance work here but it's tractable.

For SQL querying, you set up a connection to your SQL database in Equals and then we pass queries to your database. Query results are copied into the spreadsheet where you can use full spreadsheet formulas, pivots, etc. against it.

[ Parent | on HN ]