-
about 5 min
We Migrated 166 Grids to Lattice Grid. Here's What Broke.
TOCLOCO moved its own product, DemandFlow, onto Lattice Grid across 166 grids. What it took, what broke in our grid and our own code, and what got better.
-
about 1 min
Lattice Grid 1.82: a grid that survives Back and Forward
On an htmx page, Back and Forward now bring a hydrated grid back live with its sort and filters intact, server-rendered types are respected, and viewers survive a swap.
-
about 4 min
One response for the grid and every dropdown in it
An editable grid needs its rows and the option lists behind its dropdown columns. With the Data Router one response carries both, and each dropdown follows its own route live.
-
about 2 min
Lattice Grid 1.81: presets that match their system's real shape
The four design-system presets now match Material 3, Bootstrap 5, Ant Design 5 and Fluent 2 in shape as well as colour, checked against a real, installed Material UI data grid.
-
about 3 min
Lattice Grid 1.80: design-system presets and a page that pages
Restyle the grid to Material 3, Bootstrap 5, Ant Design 5 or Fluent 2 with one stylesheet, read a live MUI theme straight in, and replace a Material UI data grid in one import.
-
about 2 min
Lattice Grid 1.79: loading rows, grouping on ClickHouse
A grid over a live source now shows its own loading state, groups by any column on ClickHouse and Elasticsearch, and keeps its KPI tiles honest over paged and pivoted data.
-
about 2 min
Lattice Grid 1.78: filter menus and pivots run in the engine
A pushdown grid now opens its filter menus instantly, pivots where the data lives, and lets select-all mean every matching row, not just the ones on screen.
-
about 4 min
The Pushdown Data Grid: One Query, Any Engine
One grid, one query shape, any engine. The pushdown source sends filters, sorts, grouping, pivots and aggregates to the database, and holds only the rows on screen.
-
about 6 min
One live feed, a whole screen of views
One live feed can drive several related grids and a chart at once. A router partitions the stream by a property so each decoupled view shows only its own slice.
-
about 3 min
Private by default: the grid never phones home
The grid validates its licence in the browser and sends nothing anywhere. No licence server, no telemetry, and the only calls it makes go to your own data.
-
about 7 min
A grid over DuckDB, in the browser
Point Lattice Grid at a duckdb-wasm connection and it pushes filter, sort and paging down, and gets whole-dataset stats by pulling the set in or pushing the aggregation to DuckDB.
-
about 7 min
The column knows it holds metres
In most grids a unit is a formatter, and a formatter is a lie that shows the moment someone sorts. Lattice Grid makes a quantity a data type, so the column stays a number.
-
about 3 min
When the grid became the interface
Grids are sold to developers, so they are built for developers. Why Lattice Grid ships redaction, annotation and presentation tools to every user as standard.
-
about 3 min
Two ways to show a row's detail
A row that expands into a nested grid, or a pane beside the list where nothing moves. They solve different problems, and one config field switches between them.
-
about 3 min
Hierarchies that survive real data
Every tree demo uses data that is already a tree. Yours will not be. Here is what happens to the orphan, the cycle and the missing level.
-
about 4 min
Width is the harder problem
Everybody demos a long grid. The one that hurts is the wide one, where the row you are reading loses its name somewhere around column nineteen.
-
about 4 min
A million rows, timed on your machine
Every grid vendor has a benchmark number from a laptop you have never seen. The grid in this post times itself in your browser instead.
-
about 4 min
Types are not labels
In most grids a column type picks an alignment. Here it decides storage, comparison, parsing, formatting and the editor, from one word.
-
about 4 min
A column definition should read like a description
Forty flat properties per column is a config file nobody reads twice. Grouping them by concern, and naming the repeats, makes a column list readable.
-
about 3 min
Get going in two minutes
One script, one stylesheet, a div with a height and a list of columns. Sorting, filtering, resizing and reordering are already there.