Jspreadsheet CE VS ag-Grid

For the spreadsheet, we use the excellent Jspreadsheet library. If there are no errors, the import happens in two steps because importing a lot of locations requires a lot of calls to the Mapbox geocoding API (geocoding is converting an address to longitude and latitude), which is rate limited.

There is a presentation at FOSDEM 2021 about FDL: https://fosdem.org/2021/schedule/event/fosstaxbreak/

Title: Give open source a (tax) break

Cash that gets into FDL/LEF is then spent to sponsor existing FLOSS projects or to acquire intellectual property rights of existing works and change their license to FLOSS.

Case 1: https://bossanova.uk/jspreadsheet/v4/ got financed partly by FDL/LEF

Case 2: the radio hardware of the Open Radio Station (a 4G/5G vRAN base station based on Amarisoft stack and SlapOS) is in the process of being acquired and released as open source hardware. See https://shop.rapid.space/product_module/241/Resource_viewAsS...

The requirement for PhD is here to ensure that all projects that are financed by FDL/LEF have some kind of general interest or innovation, something which is useful to comply with Tax Law

Yeah maybe in that case you can use jspreadsheet

In this post I’ll show you how, using the AG Grid component and Ably Spaces, you can create a React application that allows users to see not only who else is currently viewing the grid, but using a Flowbite Avatar Stack component, what row each user currently has selected.

something like ag-grid? https://github.com/ag-grid/ag-grid

I personally use https://www.ag-grid.com/ for all my data grid needs. It has a free community version (that should get you covered imo) as well as a paid one with advanced features.

To be fair, in any GUI toolkit, the "table" is abolutely the most complex general purpose widget. People really under estimate the difficult of an efficient implementation. Qt spents YEARS improving their QTableWidget class. The implementation is mind-bogglingly complex. I am sure many very smart summer interns (PhDs!) have tried to tweak that class to squeeze every bit of performance possible. The table class in GTK+ and MSFT DotNet's WPF are equally, freakishly insane.

Consider this idea: Most people who use a table class in a GUI framework assume it is essentially infinitely scalable (myself included!). I am talking about millions of rows or thousands of columns with all kinds of silly widgets injected into individual cells. It is a crazy hard computer science problem to solve. I would not doubt there are many PhD thesises written on the topic of fast, scalable table widgets.

Beyond desktop GUI toolkits, people have tried to do the same in a browser (HTML/CSS/JS). Have you seen AG-Grid? Woah, it is unbelievable how much goddamn data you can squeeze into that widget. Most Wall Streets web-based trading apps use it one way or another. It's just so hard to beat. Ref: https://www.ag-grid.com/ There must be 1,000 person years of optimisation sunk into that implementation.