Show HN: The TypeScript Semantic Layer for ClickHouse https://bit.ly/4oQE76l

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://bit.ly/43YBtly June 27, 2026 at 10:37AM

Show HN: Play puzzle games in a feed like TikTok https://bit.ly/4vEnq0w

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://bit.ly/4g9K5wO June 27, 2026 at 10:52AM

Show HN: Turn images into audio that can be decoded with a spectrogram https://bit.ly/4vE9HH2

Show HN: Turn images into audio that can be decoded with a spectrogram https://bit.ly/44xgciV June 24, 2026 at 08:23PM

Show HN: Hacker News on a Train Station Style Flip Board https://bit.ly/3QM4AW6

Show HN: Hacker News on a Train Station Style Flip Board Although the page itself is more just fun to have made and look at (I like the flip sound), the fun part is how I made it to verify the (and I hate to say it) vibe host service I've been working on. The recent flip board back and forth's on Twitter (X) are what inspired me. The idea here is that people (like me or you) can create something neat like this, and others can remix it, change it and publish their own version. This is that all in action and it worked great. I wrote a blog about it (the blog is dogfooding, it's just an app hosted on quickish that uses the built in db lib). For the HN version of this flip board I use their firebase api via the built in quickish server functions that make use of the fact that the front-end can get realtime updates (now that you mention firebase) from cloud function db updates. Of course that's over-kill but I wanted to show something fun. You can remix and host your own version for free, just need a google oauth login that's it. OG flip board I built (Portland Based - Current Weather): https://bit.ly/4vB8HU9 Blog post that dives a tiny bit deeper: https://bit.ly/4vyu48q... https://bit.ly/4anXTjG June 27, 2026 at 01:43AM

Show HN: Bikepacking Planner https://bit.ly/4oP6L7H

Show HN: Bikepacking Planner I like to go bikepacking. I have anxiety over where to put things and if I have everything. So I made a tool that helps with that and tried to make it really cool and useful and in good taste. That is all. https://bit.ly/4b9IELk June 26, 2026 at 02:44AM

Show HN: FastPlay, a fast minimal Windows video player built in Rust https://bit.ly/4vrqddi

Show HN: FastPlay, a fast minimal Windows video player built in Rust https://bit.ly/4vrqe0Q June 26, 2026 at 12:50AM

Show HN: DeepSeek Flash inverted the economics of agent products https://bit.ly/4vPuiIJ

Show HN: DeepSeek Flash inverted the economics of agent products There is an adversarial relationship between developers and big model labs. Model labs charged developers higher API prices to subsidize their own agent harness offerings. Think Anthropic charging 5x higher Claude API prices to subsidize consumer subscriptions. So Cursor in a way was subsidizing their own direct competitor. DeepSeek V4 Flash totally inverted this relationship. Now you have a model that beats even Sonnet in some benchmarks and is totally opensourced. Now inference providers are racing to the bottom to optimize and give cheaper hosting. Every player with a non-SOTA is now racing to swap over to stop paying the big model lab tax, even Microsoft is switching Copilot to use DeepSeek. On switching over to Deepseek: - we noticed over a 100x cost decrease while similar or better performance then Gemini 3 Flash - insane saving from the cached input tokens: $0.002/1 Million tokens - both DeepSeek Flash and GLM 5.2 are text-only models, so clearly multimodal training is not worth the additional cost. Language is just a much more efficient sparse representation of the world/reasoning than vision - we had a early bet on a text-only web agent harness, and now with DeepSeek this results in unique cost advantages. - we rewrote our harness as a callable DSL library that a model can generate code to execute on. DeepSeek has proven phenomenal on code generation to drive an agent harness. - I would highly recommend everyone to rewrite their harness to be text-only and callable via executable code leveraging DeepSeek V4 Flash. https://bit.ly/3QJXSzU June 25, 2026 at 11:56PM

Show HN: RealTube – Watch YouTube with filters for AI-generated content https://bit.ly/3QXoX2C

Show HN: RealTube – Watch YouTube with filters for AI-generated content https://bit.ly/4epqt6E June 24, 2026 at 11:34PM

Show HN: Built an Obsidian plugin that rephrases your writing without takin over https://bit.ly/3QBKfmm

Show HN: Built an Obsidian plugin that rephrases your writing without takin over Writing is hard, and it's tempting to just let AI do the whole thing So I built an Obsidian plugin that keeps AI in its place Highlight a sentence, get some options, pick the one you like Sharpens your writing instead of automating it https://bit.ly/4xE1W5g June 25, 2026 at 12:49AM

Show HN: GDPRedirect – Become EU compliant in one line of code (satire) https://bit.ly/4uTeF1u

Show HN: GDPRedirect – Become EU compliant in one line of code (satire) it's satire. You add one script tag and if you're in the EU it traps you in cookie banners you can't get out of. The reject button moves when you try to click it. the legitimate interest toggles turn themselves back on. the privacy policy is 47 pages. at the end you have to prove you're not american by clicking 27 buttons, one per country, in the local language. GET /v1/europeans returns a real 451. every banner is an actual EU law. the bottle caps that won't come off. the €16 tax stamp you buy from a tobacco shop in italy... next.js + sqlite, one file, self hosted. the redirect.js is plain js in a try/catch so it can't break the site it's running on. I've built it to avoid working on what I had to work on. :/ Hope you like it. ps: It shows how stupid some of the laws are. https://bit.ly/4v1n03b June 24, 2026 at 11:22PM

Show HN: Monolisa v3 – a typeface for developers and creatives https://bit.ly/4g3dGYS

Show HN: Monolisa v3 – a typeface for developers and creatives Originally we (Andrey, Marcus, Juho) built MonoLisa in 2020 as we realised there's room for a better monospaced typeface for developers. The key insight was to make the glyphs slightly wider to make more room for design to make letters like m feel less cramped. Since then we've released a variable v2 (2022) and now we're happy to expand the typeface with a new family called MonoLisa Text. The reasoning was to cover *other* use cases beyond coding with this proportional font. We hope you give Monolisa a go as there's a free trial to try. We also welcome feedback! https://bit.ly/4xBScse June 22, 2026 at 03:05PM

Show HN: I scanned every YC Spring 2026 startup for what AI crawlers see https://bit.ly/4acayGq

Show HN: I scanned every YC Spring 2026 startup for what AI crawlers see Used 'potatometer.com' to scan and analyze all All 197 YC Spring 2026 startups on their SEO / GEO / AEO technical setup. I scanned the URL each startup lists in YC's directory. Most are readable by AI crawlers. Most don't tell a crawler what they are. Read more in the blog above. https://bit.ly/4xLrtcR June 23, 2026 at 03:40AM

Show HN: Durable Agent Sessions API (Preview) https://bit.ly/4vY9CxA

Show HN: Durable Agent Sessions API (Preview) https://bit.ly/43QMm8W June 23, 2026 at 02:37AM

Show HN: Typevia live LaTeX editing with AI assistance https://bit.ly/448XYUZ

Show HN: Typevia live LaTeX editing with AI assistance https://bit.ly/3SApyYr June 22, 2026 at 03:48AM

Show HN: Wirewright, an experimental symbolic physics environment https://bit.ly/44s0oOg

Show HN: Wirewright, an experimental symbolic physics environment The idea with Wirewright is to treat programs and algorithms as physical mechanisms, as machines or societies of machines inhabiting an immutable symbolic world, and time-step the latter to see what happens. This last part in particular reminds me of cellular automata. Said differently, in Wirewright, programs are modeled as "nouns" or "societies" of interacting "nouns" (think data structures). The world is then subjected to laws of physics -- symbolic physics; which is the only "verb" here (think function). Therefore, in Wirewright, we say that, in a sense, algorithm equals structure and the evolution of structure equals computation. I tend to shorten this to "structure is computation", but this may be incorrect if viewed in isolation. Now, I guess you're wondering what Wirewright actually is . In fact, I see the rules here state that I must tell you what Wirewright is, plainly and clearly. I will try, but beware that at the end of the day, I know as little as you do :^) My hands write, my brains ponder. It's hard for me to say definitively what Wirewright is . Please see the README for several attempts of mine to answer this question. Please see the tutorial(s) if you're interested enough to try and infer that yourself. I'm still not sure the README or the tutorial(s) are answering the exact question, though; I had no feedback yet on most of my work on Wirewright, so any feedback is welcome, other than, I guess, "I don't understand what this is"; this kind of feedback I can generate myself, no offense :^) If there wasn't a public GitHub repo and if I hadn't made a few announcements here and there already, you'd think I'm developing the project in secret. This kind of stuff is not something you ordinarily talk about, you see, especially "in the wild"; or else you'd be quickly labeled eccentric or outright crazy. Anyway. Wirewright is not a framework, not a UI toolkit, not an IDE. It's not a programming language either. I think I'm trying to explore the intersection of different things here, such as cellular automata, term rewriting, symbolic computation, dataflow, etc. I'm also prone to veering off for pages and pages into a genre one could call "folk biology"; biology and especially neurobiology is a huge inspiration for me. Inspiration doesn't mean copying or formal study, of course. In fact, if there are any biologists here, please "shut down" your eyes and ears and all other sensory organs if you decide to explore the depths of the project :^) For me, when I see something interesting in biology, I think, in excitement, "Oh, I want to do that too, I don't care how!" The project has been evolving more or less organically, along with me, so to speak, subsuming a lot of my ideas (but mostly the ideas of others; e.g., Varela, Maturana, Wolfram), and mixing them. I'd say it's a playground of mine which, over the years, has become consistent enough for me not to fear trying to tell the world about it. That is, about two years ago, Wirewright was an amorphous blob I couldn't even describe with analogies. Now I can at least try analogies. All this "symbolic physics" stuff is the product of my most recent work in recognizing where the project actually appears to be heading. Now, as a final disclaimer, please note I'm an amateur in all of the things I'm talking about, from programming to biology to philosophy. So maybe all of this is well-trodden grounds, and I'm coming up with these words and ideas for nothing, and what I'm saying is stupid. Maybe it is. Regardless, I hope at least the synthesis looks interesting to some of you, even if the exact wording and my little philosophy intermissions here and there feel a bit off. Sorry for the long text. https://bit.ly/4uOUn9i June 22, 2026 at 01:15AM

Show HN: MiniPCs.zip – Charting the Pareto frontier of Mini PCs https://bit.ly/3QYWCZL

Show HN: MiniPCs.zip – Charting the Pareto frontier of Mini PCs The overall idea is to chart out the thousands of Mini PCs by benchmark and reveal the Pareto Front so you can get the most Compute per Dollar. Definitely a labor of love as I have a number of Mini PCs for my "homelab" (TrueNAS, piHole, Plex, basic stuff). It uses Gemini to extract specs from listings (since they're not often strongly categorized). Quick blog post here: https://bit.ly/3SlHgio https://bit.ly/4vnJlZA June 20, 2026 at 08:55PM

Show HN: TownSquare, a tiny presence layer for websites https://bit.ly/4uUlS1f

Show HN: TownSquare, a tiny presence layer for websites https://bit.ly/4afYDHr https://bit.ly/4v86qil https://bit.ly/3QXTu0d June 20, 2026 at 12:55PM

Show HN: Autonomy – Self-Harness/Self-Directed AI Agent Core Under Development https://bit.ly/4aZAoxo

Show HN: Autonomy – Self-Harness/Self-Directed AI Agent Core Under Development https://bit.ly/4w4oElF June 20, 2026 at 07:31AM

Show HN: Pytest-tia – run only the tests your Git diff affects, with receipts https://bit.ly/4uPo22b

Show HN: Pytest-tia – run only the tests your Git diff affects, with receipts https://bit.ly/4uTgv2l June 20, 2026 at 07:14AM

Show HN: Rundown - Niche Intelligence for YouTube Creators https://bit.ly/4vpe8FF

Show HN: Rundown - Niche Intelligence for YouTube Creators https://bit.ly/4vS8Z8E June 20, 2026 at 04:47AM