Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

datagridxl.com

Post reply on HN
Print view View original

131–136 of 136 posts

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#131

Post by robbiejs »

mkl wrote: post #8
robbiejs wrote: post #2

Hello HN, I’m Robbert, the creator of DataGridXL.js. DataGridXL is a free (and commercial) editable data table library written in ES6. My goal is to develop the most performant & user-friendly spreadsheet-like data table out there: - It has zero dependencies. You don’t need any framework to use DataGridXL. - It is lightweight (~200kb) and easy to use. It does not even require messing with CSS. - It has its own Virtua…

That title flashing "1 new message" nonsense is incredibly distracting. Is there a UI way to quickly sort by a column?

Hi mki,

I've just released a new version that adds a Sort Feature to the grid: https://www.datagridxl.com/demos/sorting-columns.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#132

Post by robbiejs »

amanzi wrote: post #127
robbiejs wrote: post #62

Earlier quoted context omitted.

Hi, you're right. At this time it's not supported, but we're working on it. Probably next week. The other features are still a definite "no" for now :-)

Thanks for the update!

You're welcome! Did you see the demo? It has sorting now: https://www.datagridxl.com/demos/sorting-columns

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#133

Post by nurettin »

robbiejs wrote: post #128
nurettin wrote: post #126

Earlier quoted context omitted.

The grid itself doesn't proactively try to equalize frontend and backend data, but I utilize backend orm signals to generate websocket events which are then captured by a javascript callback in the frontend and sent to the grid. The grid then updates immediately reflecting the changes. There is no need to send the entire dataset, though, just the changes.

Is that what "dataSource" does? ( https://js.devexpress.com/Documentation/ApiReference/UI_Widg... ) I don't know DevExtreme and I have to admit that I find the API Reference a little overwhelming. If I can introduce more ways to communicate between back-end and front-end, I am all for it of course. Do you think the websocket approach for grid/tables is a common one among web devs? A link to a specific code example wo…

The data source is an observable which triggers changes in the widgets that listen to it. A nice way of avoiding slow widget updates is to disable animations while making big changes to the data source. It also helps decouple UI code from business code. It even gives you the opportunity to react to widget changes such as adding a row or changing a cell without reading code directly from the widget's internal data structures or DOM.

This is a common theme among many widget providers. If you work a little bit with lazarus or delphi, you will understand throughly what I mean.

Now how common is streaming backend changes to frontend using websockets? I would say it is pretty common among the financial industry, streaming trades and quotes directly to the UI. Bloomberg, investing.com and many in-house systems that require live updates probably use this.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#134

Post by amanzi »

robbiejs wrote: post #132
amanzi wrote: post #127

Earlier quoted context omitted.

Thanks for the update!

You're welcome! Did you see the demo? It has sorting now: https://www.datagridxl.com/demos/sorting-columns

Yes - that's perfect. So fast and smooth. I have a small side project on the cards that could use this, but unfortunately wouldn't be a paying customer though.

Cheers.

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#135

Post by robbiejs »

amanzi wrote: post #134
robbiejs wrote: post #132

Earlier quoted context omitted.

You're welcome! Did you see the demo? It has sorting now: https://www.datagridxl.com/demos/sorting-columns

Yes - that's perfect. So fast and smooth. I have a small side project on the cards that could use this, but unfortunately wouldn't be a paying customer though. Cheers.

That's alright, no worries :-) Curious to know what you'll be making. Feel free to send me us an update at contact@datagridxl.com

Re: Show HN: Datagridxl.js – No-nonsense fast Excel-like data table library

#136

Post by robbiejs »

nurettin wrote: post #133
robbiejs wrote: post #128

Earlier quoted context omitted.

Is that what "dataSource" does? ( https://js.devexpress.com/Documentation/ApiReference/UI_Widg... ) I don't know DevExtreme and I have to admit that I find the API Reference a little overwhelming. If I can introduce more ways to communicate between back-end and front-end, I am all for it of course. Do you think the websocket approach for grid/tables is a common one among web devs? A link to a specific code example wo…

The data source is an observable which triggers changes in the widgets that listen to it. A nice way of avoiding slow widget updates is to disable animations while making big changes to the data source. It also helps decouple UI code from business code. It even gives you the opportunity to react to widget changes such as adding a row or changing a cell without reading code directly from the widget's internal data str…

I see. I did spend a few months on a crypto trading platform and they had this frequent-updating table to display latest prices for each currency. DGXL really is an input-first component, so I haven't thought of this websocket approach.

Still, DGXL has methods like setCellValues, among others, that let's you update a part of the grid, not the entire grid. And it's super fast because of DGXL's virtual DOM.

Thanks again!

Post reply on HN