frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

Show HN: The TypeScript Semantic Layer for ClickHouse

https://github.com/hypequery/hypequery
3•lureilly1•6h ago
I've built a type-safe semantic layer in code, for ClickHouse. If you're building analytics off ClickHouse in TypeScript, I would love your feedback.

With hypequery there is no platform to adopt, no YAML sprawl. It runs where your app runs.

Key features:

- Define metrics once, reuse them everywhere: Declare dimensions and measures in one place and then pull from the same source of truth.

- Compiles to ClickHouse SQL: No service, no proxy, no extra runtime to deploy. It's a library that generates SQL and runs where your app runs.

- Multi-tenancy & Authentication ready: Cross-tenant queries are blocked at the query layer, helpers to plug into your existing auth.

- Agent-native: A dataset is a declared set of dimensions and measures, so it doubles as an allowlist. Includes an MCP server to hand an LLM a typed catalog to query.

- Runtime HTTP entry point: serve() exposes any dataset as an endpoint, so the same type-safe definitions back your dashboards and your API.

Comments

Abushan•4h ago
hardest part getting teams to trust it in production. What is the biggest adoption hurdle for early users?
lureilly1•3h ago
The biggest hurdle is that it’s still a young library sitting in the core read path for production analytics. That naturally requires early adopters who believe in the direction, are willing to use in real systems, and can be patient whilst gaps are closed.

The base is solid though: the underlying query builder has 10k+ weekly downloads and production usage. The newer surface is the semantic layer itself.

Show HN: Hacker News on a train station-style flip board

https://popflame.quickish.space/hn-flipboard/
93•PaybackTony•14h ago•19 comments

Show HN: Smart model routing directly in Claude, Codex and Cursor

https://github.com/workweave/router
187•adchurch•23h ago•100 comments

Show HN: DBOSify – Drop-in Temporal replacement built on Postgres

https://github.com/dbos-inc/dbosify-py
71•KraftyOne•2d ago•18 comments

Show HN: Aerial-autonomy-stack – open-source perception-based drone swarms

https://github.com/JacopoPan/aerial-autonomy-stack
3•SufficientFix42•2h ago•0 comments

Show HN: Open Tag, the open source Claude Tag

https://github.com/CopilotKit/OpenTag
2•nathan_tarbert•3h ago•0 comments

Show HN: WebBase-III – dBASE III rebuilt in the browser with its own interpreter

https://github.com/DDecoene/WebBaseIII
93•ddecoene•3d ago•27 comments

Show HN: Autofit2 – End-to-end pipeline for multilingual text classification

https://github.com/neospe/autofit2
26•leschak•2d ago•2 comments

Show HN: Turn images into audio that can be decoded with a spectrogram

https://nsspot.herokuapp.com/imagetoaudio/
8•jupr•2d ago•4 comments

Show HN: Play puzzle games in a feed like TikTok

https://puzzle.express
5•trancence•5h ago•2 comments

Show HN: The TypeScript Semantic Layer for ClickHouse

https://github.com/hypequery/hypequery
3•lureilly1•6h ago•2 comments

Show HN: I made Google Trends for Hacker News by indexing 18 years of comments

https://hackernewstrends.com
789•ytkimirti•2d ago•153 comments

Show HN: Overfitted a 900KB Transformer to Compress a 100MB CSV into 7MB

105•spidy__•4d ago•65 comments

Show HN: Turn native language audio into flashcards and shadowing practice

https://lingochunk.com/try
90•alder•2d ago•36 comments

Show HN: OpenKnowledge – open source AI-first alternative to Obsidian/Notion

https://github.com/inkeep/open-knowledge
371•engomez•1d ago•170 comments

Show HN: Bible as RAG Database

https://www.crosscanon.com/
156•jacksonastone•2d ago•91 comments

Show HN: Nub – A Bun-like all-in-one toolkit for Node.js

https://github.com/nubjs/nub
273•colinmcd•3d ago•80 comments

Show HN: Wordit – Change One Letter, Keep the Chain Going

https://victorribeiro.com/wordit/
43•atum47•3d ago•29 comments

Show HN: peerd – AI agent harness that runs entirely in your browser

https://github.com/NotASithLord/peerd
73•NotASithLord•4d ago•23 comments

Show HN: Nimic – Pure Python as a systems language with AOT compilation

https://github.com/dima-quant/nimic
42•dima-quant•4d ago•28 comments

Show HN: LookAway, a Mac break reminder that knows when not to interrupt

https://lookaway.com
72•_kush•3d ago•25 comments

Show HN: TikZ Editor – WYSIWYG editor for figures in LaTeX

https://tikz.dev/editor/
448•DominikPeters•4d ago•74 comments

Show HN: Secs-man, a secrets manager you can (not) rely on

https://github.com/Fran314/secrets-manager-rs
30•Fran314•2d ago•19 comments

Show HN: I Derived a Steak

https://www.absurdlyoptimized.com/recipes/grilled-meats/
7•bkazez•18h ago•0 comments

Show HN: Jargo – a Golang port of Pipecat for conversational-AI apps

https://github.com/gojargo/jargo
5•fallais•1d ago•0 comments

Show HN: Mantis, A self-hosted LLM gateway

https://github.com/mantis-llm-gateway
5•rizsyed1•20h ago•0 comments

Show HN: Closing the public-key authenticity gap in our E2EE social network

https://mosslet.com/blog/articles/19
3•mosspigletdev•21h ago•1 comments

Show HN: AgentBrush – Your coding agent's missing tool: image generation

https://agentbrush.dev/
4•Yan4300•21h ago•0 comments

Show HN: I built a hardware quantum RNG and wired it into a Magic 8-Ball

https://dnhkng.github.io/posts/building-the-beam-universe-splitter/
10•dnhkng•21h ago•1 comments

Show HN: Neural Particle Automata

https://selforg-npa.github.io/
88•esychology•4d ago•19 comments

Show HN: A map of every UK railway, including stations that no longer exist

https://trainmap.co.uk/map.html
2•optionalltd•21h ago•0 comments