361
Demystifying Apache Arrow (2020)
Demystifying Apache Arrow - some observations from a data scientist. Learning more about a tool that can filter and aggregate two billion rows on a laptop in two seconds
New
The latest blog posts to take off on Hacker News. 371 posts.
362
Modern Polars: A comparison of the Polars and Pandas dataframe libraries
A side-by-side comparison of the Polars and Pandas libraries.
363
I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS
Why and how I migrated from distributed postgres to distributed sqlite on kentcdodds.com
364
365
Faster MySQL with HTTP/3
In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.
366
WAL Mode in LiteFS
LiteFS v0.3.0 now supports SQLite's write-ahead log journal mode.
367
Databases in 2022: A Year in Review
Andy Pavlo - Carnegie Mellon University,
368
SQLite 2022 Recap
There have been many improvements to SQLite during 2022. Listed below or just a few of the bigger changes. See the change logs or the trunk timeline for a more complete list of enhancements and improvements.
369
Understanding the N + 1 queries problem
In this post, I am going to talk about the N + 1 queries problem. While trying to solve this problem myself recently, I noticed most of the blog posts only talk about the very simple version of the problem and the proposed solutions would break down when the use cases get complex. I will try to get into more depth and…
370
Querying the GitHub archive with the ClickHouse playground
Via this comment on Hacker News I started exploring the ClickHouse Playground . It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
371
Easy, alternative soft deletion: `deleted_record_insert`
An alternate to traditional <code>deleted_at</code> soft deletion that stays out of the way and minimizes bugs.