perspective
ag-Grid
Our great sponsors
perspective | ag-Grid | |
---|---|---|
45 | 48 | |
7,503 | 11,738 | |
3.9% | 2.1% | |
9.4 | 10.0 | |
5 days ago | 6 days ago | |
C++ | TypeScript | |
Apache License 2.0 | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
perspective
- Ask HN: How Can I Make My Front End React to Database Changes in Real-Time?
-
The Design Philosophy of Great Tables (Software Package)
Why do you want to render to canvas?
Perspective seems to be the most performant html table. It is more focused on extremely fast updates than styling, although it looks good.
Glide is a newcomer that also renders to canvas.
https://github.com/finos/perspective
https://github.com/glideapps/glide-data-grid
-
Show HN: WhatTheDuck – open-source, in-browser SQL on CSV files
SQL workbench also uses https://perspective.finos.org/ for tables. It's a WASM table library which pairs nicely with duckdb and works well with large tables.
-
React Spreadsheet 2 – Your Own Google Sheets
Yes. We are working on adding support for aggregation and pivoting using https://github.com/finos/perspective
-
Show HN: DataSheetGrid, an Airtable-like React component
I haven't looked extensively at react-datasheet. It looks like it is trying to build more of a full product than the other data tables.
I have used ag-grid extensively, its an impressive product. Some pieces are a little awkward to use, particularly auto-sizing. But generally ag-grid has thought of most functionality and has a solution. The creator of ag-grid had a great interview on Javascript Jabber [1].
The other serious data table component that I have seen is FinOS Perspective [2]. This is extremely high performance, also more specialized and probably harder to customize. I think Perspective renders to a canvas element from Rust/C++ compiled to WASM (not 100% sure). It is also made for streaming updates.
AG-Grid supports streaming updates... but only in the commercial version.
Eventually the data model for these types of tables becomes tricky. I will be investigating parquet-wasm for my use case. Hit me up if you want to collaborate.
[1] https://blog.ag-grid.com/javascript-jabber-podcast/
[2] https://perspective.finos.org/
- Perspective Market Simulation
-
ChDB: Embedded OLAP SQL Engine Powered by ClickHouse
Something like https://github.com/finos/perspective ? We use an OLAP(-y) WASM engine to provide query-ability to our data visualization tool, and doing the calculations in the browser is cheaper and simpler than a server-side database for datasets that fit in browser memory.
- Show HN: Udsv.js – A faster CSV parser in 5KB (min)
- Perspective 2.0, Open Source WebAssembly-Powered BI
ag-Grid
-
How To Enhance AG Grid with Avatars: Building a Collaborative Grid with React and Ably
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.
-
MUI X VS ag-Grid - a user suggested alternative
2 projects | 18 Jan 2024
-
ag-Grid VS infinite-react - a user suggested alternative
2 projects | 1 Jan 2024
- AG Grid: A fully-featured and highly customizable JavaScript data grid
-
suggestions for a free spreadsheet library (like excel or google spreadsheets)
something like ag-grid? https://github.com/ag-grid/ag-grid
-
Frontend app that pulls api data and displays it in tables that can be sorted, filtered etc
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.
-
Show HN: Halloy – A GUI Application in Rust for IRC
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.
- What react library do you use for data grids / data tables?
- Does anyone know about a primitive, easily customizable, functional data table
- Table drag and drop
What are some alternatives?
arquero - Query processing and transformation of array-backed data tables.
HANDSONTABLE - JavaScript data grid with a spreadsheet look & feel. Works with React, Angular, and Vue. Supported by the Handsontable team ⚡
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
React Data Grid - Feature-rich and customizable data grid React component
datapane - Build and share data reports in 100% Python
Material UI - Ready-to-use foundational React components, free forever. It includes Material UI, which implements Google's Material Design.
ClickHouse - ClickHouse® is a free analytics DBMS for big data
SheetJS js-xlsx - 📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
SandDance - Visually explore, understand, and present your data.
mui-datatables - Datatables for React using Material-UI
arrow-julia - Official Julia implementation of Apache Arrow
FancyGrid - FancyGrid - JavaScript grid library with charts integration and server communication.