Show HN: Strata – an expressive semantic layer that can say no to your LLM https://ift.tt/3IGrdJb

Show HN: Strata – an expressive semantic layer that can say no to your LLM Hello HN, I'm Ajo and I built Strata. I spent 4 years at Netflix solving self service for non-technical business users. I think I cracked it with my unique approach to semantic layer design. The key challenge is balancing expressiveness with ease of use for our non technical colleagues. It just so happens that focus made it work pretty well with LLMs too. Strata is a full stack solution. It includes a semantic layer, dashboards, subscriptions, and google sheets exports. All of it can be done view agent conversation or via MCP. Some key concepts and features: - Names are strict. Only one thing called Revenue can exist in a project. If revenue is mapped to multiple tables, the query grain plus speed will decide table. - Strict naming conventions lends itself to enabling Automatic data blending acrros fact domains. - Partition and Aggregate aware semantic routing. This allows you to load a portion of your data into a faster compute engine like Druid or ClickHose, while keeping full history in trino or something cheaper. The query engine will choose the faster tier if the query can be resolved there. - Complex measures: out of the box support for snapshot, LOD (include/exclude), Compound, and Auto leveling compound measures. - On top of the semantic layer users can create custom calculations that span fact domains. - Another interesting feature is the ability to create cohorts and apply as filter to an entire query or single measure within a query. We are deliberately not building a semantic layer that your BI tools connect to. I think that is a dead end. We have apis, and mcp for anything custom you want to build on top. Try it free on docker: https://strata.do/try/ Docs here to get you going: https://strata.do/docs/ This is an early beta version. It is NOT open source. However, the free tier includes up to 25 users. You should be able to run it entirely on your machine with docker. I would love to hear your feedback. Especially, those working with Looker and Cube. Thanks for reading! https://strata.do/try/ September 30, 2026 at 08:29PM

Show HN: The whole Solar System and every tracked satellite, live in the browser https://ift.tt/E18CGmJ

Show HN: The whole Solar System and every tracked satellite, live in the browser https://space.bl2.net/ September 30, 2026 at 12:38AM

Show HN: A working 3D model of an Enigma machine https://ift.tt/D4teKfr

Show HN: A working 3D model of an Enigma machine I watched the excellent Veritasium video [1] on the Enigma machine, and watched the full animation by Jared Owen [2], but was still a bit confused on how the inner mechanics of an Enigma machine work. I used Astra to build out the inner components through a combination of reference images, writing out hundreds of extremely detailed prompts, and building my own inspection tools to ensure that every part is sized and positioned in a historically accurate way. It's still a work in progress, but would love any feedback on the experience so far! 1. https://www.youtube.com/watch?v=JsBZOcqZerk 2. https://www.youtube.com/watch?v=ybkkiGtJmkM https://enigma.design September 29, 2026 at 10:45PM

Show HN https://ift.tt/oJMnZxD

Show HN This is origintracer a low level observability tool of the modern web stack. It observes nginx, Gunicorn, asynchronous Python, Uvicorn and Django and Langchain. Studies their codebases into great depth and write probes and rules libraries in Python to be used with the open source software: its link GitHub: https://ift.tt/Zx1yCEh September 29, 2026 at 05:28AM

Show HN: A never-ending chess match between Claude and Codex https://ift.tt/Wruw0em

Show HN: A never-ending chess match between Claude and Codex https://ift.tt/jLD7P65 September 29, 2026 at 02:32AM

Show HN: Personal Manga / Story Recaps https://ift.tt/pFtDkIz

Show HN: Personal Manga / Story Recaps I'm working towards manga to anime generation in a cheap way. The entertainment harness is the first step towards that. You can do your own manga recaps using local models or openrouter. And it's very extensible. If you generate a recap and post it online, please attribute it to the entertainment harness and terragohan :). https://terragohan.github.io/entertainment-harness/ September 29, 2026 at 01:05AM

Show HN: PHNTM ONE: Self healing AI assistant running on a Raspberry Pi5 https://ift.tt/nk0V3jJ

Show HN: PHNTM ONE: Self healing AI assistant running on a Raspberry Pi5 https://ift.tt/9klxI7p September 28, 2026 at 11:56PM