Nasty, a cross-warehouse, type-checked, unit-testable analytics library
Hey HN - our team wants to open source a project called NASTY (NASTY Abstract Syntax Tree thingY) that we built for ourselves. NASTY was built to maintain testable/composable data pipelines. Our team was ripping our hair out trying to maintain dbt/SQL scripts across different data warehouses (Redshift, BigQuery, Postgres, Snowflake) on top of ever shifting data foundations maintained by our customer's internal data teams. NASTY is the result of our learnings from field experience. We wanted to write abstractions so that we could reuse code. We wanted to bundle those abstractions…
Nasty, a cross-warehouse, type-checked, unit-testable analytics library launched on March 8, 2024 with 47 votes, #1,025 of 4,270 launches that month and more than 90% of that year's launches.
In plain words
Nasty is a cross-warehouse analytics library that enables testable and composable data pipelines across multiple databases including Redshift, BigQuery, Postgres, and Snowflake. It provides type checking and static analysis to catch errors before production, allows unit testing locally without warehouse connections, and supports code reuse through composable abstractions. Built by engineers managing complex dbt and SQL scripts across multiple data warehouses, Nasty applies standard software development practices to data pipeline development.
written from the facts on this page · September 2026
From the sources
In the maker’s words, at launch
Hey HN - our team wants to open source a project called NASTY (NASTY Abstract Syntax Tree thingY) that we built for ourselves. NASTY was built to maintain testable/composable data pipelines. Our team was ripping our hair out trying to maintain dbt/SQL scripts across different data warehouses (Redshift…
Does a similar job
all alternatives →
Rocky – Rust SQL engine with branches, replay, column lineageApr 2026 · github.com · ▲122Hi HN, I'm Hugo. I've been building Rocky over the past month, shipping fast in the open. The binary is on GitHub Releases, `dagster-rocky` on PyPI, and the VS Code extension on the Marketplace. I held off on a broader announcement until the trust-system surface was coherent enough to talk about as one thing. The governance waveplan — column classification, per-env masking, 8-field audit trail on every run, `rocky compliance` rollup, role-graph reconciliation, retention policies — landed end-to-end last week in engine-v1.16.0 and rounded out in v1.17.4 (tagged 2026-04-26). That's the…
DrawDB – open-source online database diagram editor (a retro)2025 · drawdb.app · ▲263One year ago I open-sourced my very first 'real' project and shared it here. I was a college student in my senior year and desperately looking for a job. At the time of sharing it i couldn't even afford a domain and naively let someone buy the one i had my eyes on lol. It's been a hell of a year with this blowing up, me moving to another country, and switching 2 jobs. In a year we somehow managed to hit 26k stars, grow a 1000+ person discord community, and support 37 languages. I couldn't be more grateful for the community that helped this grow, but now i don't know what direction to take…
- HAHashquery, a Python library for defining reusable analysis2024 · hashquery.dev · ▲67
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
WhatTheDuck – open-source, in-browser SQL on CSV files2024 · github.com · ▲119WhatTheDuck is an in-browser sql tool to analyze csv files that uses duckdb-wasm under the hood. Please provide feedback/issues/pull requests.
- CDCodestat.dev – Stats from 2M open-source repositories2022 · codestat.dev · ▲63
Hi HN! This is a little site I put together while learning the Elm language as part of a hackathon at my work, I thought you might enjoy it. Be sure to click the `(source)` buttons next to the graphs: you can edit them interactively & write your own queries against the entire data set. The syntax isn't well documented yet, but you can probably get the general idea pretty quickly based on the examples there. If you like it, have questions, etc. let me know! If folks think this is cool, maybe I can get it turned into a legit project. :)
Bun-sqlgen – Type-safe raw SQL for Bun, no ORMJun 2026 · github.com · ▲55Types generator for your Bun.sql queries. Contribute to ilbertt/bun-sqlgen development by creating an account on GitHub.
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 27d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 25d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 22d ago · openbot.run
Talanoa▲341Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 20d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 28d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, March 2024
the whole month →
🌐 The Internet Computer! Free, Open-Source, and Self-Hostable. - HeyPuter/puter
Dev tools · 2024 · github.com
Microlaunch▲1,115Launch and get feedback on both the idea and product
Dev tools · 2024 · microlaunch.net
