{"ok":true,"repo":{"id":318536,"full_name":"xqlsystems/xarray-sql","url":"https://github.com/xqlsystems/xarray-sql","description":"An experiment to query Xarray datasets with SQL","language":"Python","topics":[],"stars":149,"stars_delta":6,"forks":21,"first_seen":"2026-10-30T20:35:40.110853Z","last_seen":"2026-10-31T12:32:43.442779Z","mentions":1,"platforms":["hn"],"score":0.0,"summary":"xarray-sql lets you query Xarray datasets with SQL by pivoting multidimensional array data into table form. It registers datasets with query engines like DuckDB or Polars, ingests them into databases via ADBC, or serves them over Arrow Flight SQL, then converts query results back to Xarray datasets for analysis or plotting.","why":"It appeared on Hacker News with a demo claiming a FlashAttention kernel can be automatically deduced from ~25 lines of SQL, generating attention for the project.","audience":"Data scientists and climate/weather researchers working with Xarray who prefer writing SQL over Xarray's Python API.","tags":["python","sql","xarray","duckdb","data-science","arrow"],"summarized_at":"2026-10-30T20:35:46.047897Z","summary_model":"glm-5.3-flash","fetched_at":"2026-10-30T23:21:37.593757Z","meta":{"license":"Apache-2.0","archived":false,"homepage":"https://xql.systems/xarray-sql/","first_stars":143},"pushed_at":"2026-10-30T03:29:07Z","created_at":"2023-11-26T06:20:56Z","watchers":6,"open_issues":102,"mentions_list":[{"platform":"hn","url":"https://news.ycombinator.com/item?id=50309479","title":"Show HN: Automatic deduction of FlashAttention kernel from ~25 lines of SQL","seen_at":"2026-10-31T12:32:43.443888Z"}],"snapshots":[{"captured_at":"2026-10-30T20:35:42.299504Z","stars":143,"forks":20},{"captured_at":"2026-10-30T20:51:39.072105Z","stars":143,"forks":20},{"captured_at":"2026-10-30T21:06:37.971828Z","stars":143,"forks":20},{"captured_at":"2026-10-30T21:21:40.543245Z","stars":143,"forks":20},{"captured_at":"2026-10-30T21:36:51.841000Z","stars":143,"forks":20},{"captured_at":"2026-10-30T21:51:38.878488Z","stars":144,"forks":20},{"captured_at":"2026-10-30T22:06:37.939994Z","stars":145,"forks":20},{"captured_at":"2026-10-30T22:21:37.289222Z","stars":146,"forks":20},{"captured_at":"2026-10-30T22:36:39.040944Z","stars":147,"forks":20},{"captured_at":"2026-10-30T22:52:01.144369Z","stars":149,"forks":20},{"captured_at":"2026-10-30T23:06:37.741743Z","stars":149,"forks":20},{"captured_at":"2026-10-30T23:21:37.641227Z","stars":149,"forks":21}]}}