Al Merose (he/him)
banner
al.merose.com
Al Merose (he/him)
@al.merose.com
Technical staff @OpenAthena.ai, community member @pangeo.io & @m2lines.bsky.social. Weather, Climate, Oceans Research. Programming, Politics, Postmodernism (oPinions are my own).
Fair. Though, it still has a decent chance of turning out true!
December 1, 2025 at 8:09 PM
Ye have little faith in mechanistic interpretability advancing by then, eh?
December 1, 2025 at 8:04 PM
Reposted by Al Merose (he/him)
github.com/dollspace-ga... Doll made this tool to help three cueing readers learn phonics
GitHub - dollspace-gay/Anchor-Text
Contribute to dollspace-gay/Anchor-Text development by creating an account on GitHub.
github.com
November 29, 2025 at 8:21 PM
We compromise and make pumpkin pie and pecan bars
November 28, 2025 at 4:34 AM
We made a simple config system based on Pydantic Settings. My co worker Jesse made it and it’s been killer to use.

It’s very similar to github.com/marin-commun..., which I also recommend.
GitHub - marin-community/draccus: Configuration with Dataclasses+YAML+Argparse. Fork of Pyrallis
Configuration with Dataclasses+YAML+Argparse. Fork of Pyrallis - marin-community/draccus
github.com
November 27, 2025 at 4:34 PM
I’m not so sure. A Columbia physics grad student once told me his perspective on string theory. He thought that the community was wrong to seek to build even bigger particle accelerators, and that instead, they needed to come up with new ideas.

Not my area, but never say never!
November 27, 2025 at 4:31 AM
The high level hypothesis posed by this package is that the @cloudnativegeo.org ecosystem functions as a new type of database, one whose components we get to pick and choose a la carte. If this is the case, and CNG is really a database, then I argue it ought to also have a decent SQL front-end.
Pangeo is a database
www.hytradboi.com
November 25, 2025 at 8:49 PM
Currently, this project is looking for early adopters and open source contributors. Together with tire kickers and drive by patches, I think xarray-sql could make scientific datasets way more accessible.
github.com/alxmrs/xarra...
alxmrs/xarray-sql
An experiment to query Xarray datasets with SQL. Contribute to alxmrs/xarray-sql development by creating an account on GitHub.
github.com
November 25, 2025 at 8:49 PM
Right now, this package will only work on a single node. I expect it to break at early challenges of scale, and yet – I'm hopeful this will soon rise to the complexity of geospatial or scientific datasets. It should be possible in theory to distribute on Ray clusters, and doing so is on the roadmap.
November 25, 2025 at 8:49 PM
This library was designed to address the use case of joining tabular data with weather data, such as @earthmover.io's temporal-chunked copy of ERA5. That's the dream, anyway.

docs.earthmover.io/sample-data/...
ECMWF Reanalysis 5 (ERA5) Surface | Earthmover
Data source
docs.earthmover.io
November 25, 2025 at 8:49 PM
Tuning the performance of queries requires a bit of skill with SQL, but ultimately will be a matter of data engineering (another case of the tyranny of the chunk).

element84.com/software-eng...
Chunks and Chunkability: Tyranny of the Chunk • Element 84
We discuss our attempt to understand chunks and chunking more deeply including where we are today and where we might go from here.
element84.com
November 25, 2025 at 8:49 PM
Currently, the library should “just work” with any Xarray dataset – i.e. datasets backed by @zarr.dev, IceChunk, NetCDF, Xee, TiTiler, etc. Once opened, the library lets you think of coordinates as primary keys and data_vars as columns as you filter, group by, and aggregate to your heart’s desire.
November 25, 2025 at 8:49 PM
`xarray-sql` tries to make ndarrays in Xarray queryable with SQL by imagining them as tables. The closest parallel I've found to this is XVec, which brings table-like geospatial concepts to rasters in Xarray. This project aims to do the opposite, which is to treat rasters like rows in tables.
November 25, 2025 at 8:49 PM