perspective VS nocodb

Try this project I work on, https://perspective.finos.org/ . It comes with a Python library (that runs the exact same engine/code as in the wasm version), and even a JupyterLab plugin. You can run the engine fully in-python, in-Javascript (via wasm), or replicated between the two.

Standalone Python virtual server example https://github.com/finos/perspective/tree/master/examples/to...

JupyterLab demo on Binder https://mybinder.org/v2/gh/finos/perspective/master?urlpath=...

The best example of WASM being used to render to canvas (it's also visualizations) I've seen is "Perspective":

https://perspective.finos.org/

  "Perspective is an interactive analytics and data visualization component, which is especially well-suited for large and/or streaming datasets. Originally developed at J.P. Morgan and open-sourced through the Fintech Open Source Foundation (FINOS), Perspective makes it simple to build user-configurable analytics entirely in the browser, or in concert with Python and/or Jupyterlab. Use it to create reports, dashboards, notebooks and applications, with static data or streaming updates via Apache Arrow."

Man the a16z marketing machine is working hard unfortunately at cost of quality.

For those interested in FS and open source today, especially with a capital markets lens check out:

https://www.finos.org

Lots of great projects, one I used recently and a favourite was this:

https://github.com/finos/perspective

As far as customizing the Perspective datagrid, the story on this is evolving :) . With the 1.0 release, we've released an NFT demo with a more current version of the plugin API, as well as new plugin API docs. Replacing innerHTML is only costly if you trigger a relayout before the replacement, which you'd want to avoid - check the pudgy-penguins demo source for examples which replaces these with without the intermediate DOM tree being rendered (though this is brower-dependent). If you can't, e.g. the replacement is async or whatever, the underlying regular-table component has an API that allows you to return the DOM elements themselves per cell, but you'd need to write a simple plugin to integrate this as Perspective's version provides its own dataListener.

By the way, the link to the blog on the project website results in a 404.

Formula are ignored as they can be complex in Excel. Instead the type is derived out of formula. Please see our release notes on how types are derived.

NocoDB is a free & open source Airtable alternative that even connects to your own MySQL/Postgres databases & transforms them to spreadsheet!

Please find the release note here: https://github.com/nocodb/nocodb/releases/tag/0.82.0

NocoDB is a Completely Free & Open Source Airtable alternative. And it turn any existing database/schema into a smart-spreadsheet. We support transforming MySQL, Postgres, SQL server & SQLite databases.

(Founder here - glad to see the post)

NocoDB[1] is a Free & Open Source Airtable alternative that transforms your own existing databases like MySQL/Postgres/MsSQL/SQLite into a smart-spreadsheet.

Happy to answer any queries and you can also join our discord[2] for any help.

[1] : https://github.com/nocodb/nocodb

[2] : https://discord.gg/5RgZmkW

nocodb dev team was very generous for me when helping me evaluate their product for my use case, including creating a test environment to understand my request.

I ended up not using them, but they created an issue for me on GitHub, saying my request was on their roadmap.

https://github.com/nocodb/nocodb/issues/580

Oh and they quickly researched a solution to an installation bug I was experiencing.

https://github.com/nocodb/nocodb/issues/579

TL;DR: great customer service from nocodb, so I'm happy to consider nocodb for future projects.

Thank you for shoutout. (Disclaimer : Founder here)

Yes, NocoDB[1] allows to transform your own databases into smart-spreadsheets like Airtable. It is easy to get started - please try it out.

[1] : https://github.com/nocodb/nocodb