Show HN: The TypeScript Semantic Layer for ClickHouse https://ift.tt/MYR5Tij

Show HN: The TypeScript Semantic Layer for ClickHouse 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. https://ift.tt/0qKfCJR June 27, 2026 at 06:37AM

Show HN: Play puzzle games in a feed like TikTok https://ift.tt/e94RDk5

Show HN: Play puzzle games in a feed like TikTok Hi everyone. I spent the last year making Puzzle Express. Play and discover puzzles as if you were scrolling reels: play if you want or swipe up to skip. Made this as a healthier alternative to doomscrolling and a great, new way to discover puzzles you might love. If you don't fancy endless scrolling, try to finish the daily missions or play your favorite puzzle in the arcade. https://puzzle.express June 27, 2026 at 06:52AM

Show HN: Turn images into audio that can be decoded with a spectrogram https://ift.tt/AXlUoWs

Show HN: Turn images into audio that can be decoded with a spectrogram https://nsspot.herokuapp.com/imagetoaudio/ June 24, 2026 at 04:23PM

Show HN: Turn any X account into an RSS feed https://ift.tt/0a18jVO

Show HN: Turn any X account into an RSS feed x2rss turns any public X / Twitter account into a standard RSS feed you can follow in any reader. https://rss.gurify.com/ June 26, 2026 at 02:38AM

Show HN: Trophikos – a calm, ad-free recipe and cocktail library for iOS https://ift.tt/tU24ijg

Show HN: Trophikos – a calm, ad-free recipe and cocktail library for iOS https://ift.tt/ynJvl2N June 26, 2026 at 01:36AM

Show HN: Tree, truth, druid and tar share one Proto-Indo-European root https://ift.tt/6Z5o2sk

Show HN: Tree, truth, druid and tar share one Proto-Indo-European root Did you know that truth, druid, dryad, tar and dendrite all grew from the same root as the word tree? A single Proto-Indo-European root, *deru-. Source code: https://ift.tt/Nc8oIkG I am grateful to Miroslav Šedivý, a Czechoslovak polyglot I met at PiterPy 2018, who sparked a curiosity that Polish 'zdrowy' (healthy) is from 'drewno' (wood) or 'drzewo' (tree), which are related to the English word 'tree'. A few weeks ago I saw Odd Pride's short on the tree of life, which prompted me to make an explorable explanation ( https://ift.tt/naF4JYf... ), a medium close to my heart. https://ift.tt/N91S3bF June 25, 2026 at 06:49AM

Show HN: How to Use Unlimited Token Plan with OpenCode https://ift.tt/lLYaFWh

Show HN: How to Use Unlimited Token Plan with OpenCode https://twitter.com/CanopyWave_AI/status/2069957571184832525 June 25, 2026 at 06:54AM