This week has been about Parquet, React grids, Datalog and calculations for latitude/longitude points.
An article showcasing the top features SQLite has to offer to support everyday data wrangling. Even more useful now with the Math functions included in version 3.35.0.
An article explaining the benefits of using Parquet instead of SQLite to distribute large datasets with a high columnar repetition. A short demonstration of why columnar formats are a better choice for certain types of datasets.
A React library to render an editable table using Canvas. Although it claims to scale to millions of rows, it says nothing about the price you pay in lack of accessibility.
A tutorial on getting started with Datalog.
A tool to inspect, query, join, import, and export data. Like jq but for relational data, whether that data is in a document or database.