🛠️ Hacker News Tools

Lessons Learned from CISA's Recent GitHub Leak

Show HN: YouTube Guitar Tab Parser I created a simple CLI that turns a YouTube guitar-lesson video into a PDF of the guitar tab.<p>There are services that transcribe music from Youtube videos into tabs, but they never work well enough for me. Instead I&#x27;m taking a simpler approach. It downloads the video, samples frames, uses Claude vision to locate the tab region, crops every frame to that region, de-duplicates the crops by the bar number printed on each line of the score, and stitches the distinct tab lines vertically into a PDF.<p>I didn&#x27;t test it on a lot of different Youtube videos yet, so problem will arise for sure.

Show HN: I implemented a neural network in SQL Two weeks ago I was on my babymoon in Corfu, Greece. While in transit, I was overseeing a GSoC intern submit an important feature to my array database library, Xarray-SQL. He added `to_dataset()`, which completed the roundtrip between thinking of array data in a tabular model simultaneously as gridded rasters (the premise of the project is that every Nd array can be mapped to 2d, where orthogonal dims of the Nd array are just primary keys of a tabular representation). We discussed in chat, now that this feature existed, what demos could we make that would prove this data model works?<p>With down time on a warm beach during a heatwave, cool salty water giving me fresh ideas, I had an idea: what if we used Coiled&#x27;s Geospatial benchmark discussion as a comprehensive overview of geo and climate queries. Are all of these common operations secretly relational, just with the wrong data model? Using Claude Code on the beach, I can confirm that this seemed to be the case: Claude and I publish a benchmark that illustrated how every common operation in geo and climate sciences (at the 100 TB range) were actually secretly relational operations: <a href="https:&#x2F;&#x2F;github.com&#x2F;xqlsystems&#x2F;xarray-sql&#x2F;blob&#x2F;main&#x2F;docs&#x2F;geospatial.md" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;xqlsystems&#x2F;xarray-sql&#x2F;blob&#x2F;main&#x2F;docs&#x2F;geos...</a>.<p>Most surprisingly of all, from these examples was that a core operation, regridding, was just a sparse matrix-vector product. Claude had pointed out to me that in this data model, matmul was just a `SUM(val * val) ... JOIN .. GROUP BY`. This has a direct parallel to einsum notation, but can be expressed in (arguably) elegant SQL syntax! This capability seemed to be greater than the sum of it&#x27;s parts.<p>Back in the cool water of the Ionian, I thought about the implications of this more deeply. I reflected that, all of the Coiled benchmarks did, deep down, was _post process_ simulations that happen in numerical&#x2F;array code. Why couldn&#x27;t these physics calculations be push down into the database also, if we could so matmul in SQL? Then it hit me: maybe they could, if in addition to linear algebra, if SQL could do calculus! <a href="https:&#x2F;&#x2F;bsky.app&#x2F;profile&#x2F;al.merose.com&#x2F;post&#x2F;3mpbods7wts2y" rel="nofollow">https:&#x2F;&#x2F;bsky.app&#x2F;profile&#x2F;al.merose.com&#x2F;post&#x2F;3mpbods7wts2y</a><p>Later on, I implemented autograd on top of DataFusion&#x27;s visitor pattern based on JAX&#x27;s implementation. In my simplified array model, it turns out that we only care about partial differentiation on the diagonal of the Jacobian, meaning that `grad()`, `jvp` and `vjp` are just row-wise operations! I then implemented a common physics calculation from the coiled benchmark that required gradients. From here, I realized if I can autograd in the database, why can&#x27;t I create a neural network?<p>As I came back home, I created some slides, and presented this work to DataFusion&#x27;s inaugural showcase: <a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?t=1511&amp;v=5o-4hL8vGPw&amp;feature=youtu.be" rel="nofollow">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?t=1511&amp;v=5o-4hL8vGPw&amp;feature=y...</a> I realized in this synthesis that SQL is not necessarily a toy language for writing neural networks, but in fact, may be highly desirable in the future due to the fundamental principles of relational databases: the logical layer should be independent from the physical layer. If that property holds, and a neural network is a series of relations, could we create a SOTA distributed system for training more easily? For example, if we had one global logical plan of dataflow, could we better distribute work on 1000+ GPUs?<p>Several scientists and engineers and I are working together to explore this weird world of relational arrays at <a href="https:&#x2F;&#x2F;xql.systems" rel="nofollow">https:&#x2F;&#x2F;xql.systems</a> (discord link at the bottom if you want to get involved).

Climate.gov was destroyed. Open data saved it

Former NOAA employees built Climate.us to preserve climate data and resources

Show HN: kassette – Durable agent workflows backed by object storage Agent runs often fail after expensive model calls and executing tools that have real-world side effects. This problem is made even worse by how common it is to deploy agents to serverless environments. When your agent dies, it needs to be restarted, but doing so safely isn&#x27;t easy and everyone building agents has to solve this same problem of durability.<p>The stack you&#x27;re running probably already has half of what you need for durable execution already though, ie, a queue or job runner that can invoke work at least once. kassette gives you the other half by journaling completed steps to object storage (or a filesystem) so that it can replay them when you retry the same run again. This means you can have durability without having to add a workflow service or even a SQL database.<p>kassette is a tiny, zero-dependency TypeScript library that you can use to build agentic workflows that are just ordinary async functions. Each object storage backed run is a single object that serializes appends via CAS while session numbers fence zombies. Agentic workloads are usually dominated by (relatively) small number of slow llm&#x2F;tool calls or waiting on approval so this simple design (writes grow large, full journal in a single read) has worked well (more here: <a href="https:&#x2F;&#x2F;lostinpatterns.github.io&#x2F;kassette&#x2F;docs&#x2F;object-storage-design" rel="nofollow">https:&#x2F;&#x2F;lostinpatterns.github.io&#x2F;kassette&#x2F;docs&#x2F;object-storag...</a>).<p>repo: <a href="https:&#x2F;&#x2F;github.com&#x2F;lostinpatterns&#x2F;kassette" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;lostinpatterns&#x2F;kassette</a><p>docs: <a href="https:&#x2F;&#x2F;lostinpatterns.github.io&#x2F;kassette&#x2F;" rel="nofollow">https:&#x2F;&#x2F;lostinpatterns.github.io&#x2F;kassette&#x2F;</a>

Building and Shipping Mac and iOS Apps Without Ever Opening Xcode

Logseq 2.0 Beta (DB version) is here

[API/SDK] Designing APIs for Agents

Apple's new SpeechAnalyzer API, benchmarked against Whisper and its predecessor

Show HN: Jacquard, a programming language for AI-written, human-reviewed code I&#x27;m fascinated by the generative AI wave rolling over us, and wondered if AI could create a language that it might prefer using over the ones created by and for humans.<p>To create the design, I had AI analyze the ASTs of several mainstream languages plus a few of the conceptually groundbreaking but esoteric ones (listed in the README) and then create a new structure and new syntax. It was named after the Jacquard machine (<a href="https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Jacquard_machine" rel="nofollow">https:&#x2F;&#x2F;en.wikipedia.org&#x2F;wiki&#x2F;Jacquard_machine</a>), a precursor to Babbage&#x27;s Analytical Engine (and punch cards).<p>The result reused a lot of existing ideas but combined them in what I found to be an interesting way. External&#x2F;world effects are visible in function signatures, and the runtime requires explicit permission to touch the filesystem, network, etc. Effect interactions can be recorded and replayed to see what happens under different conditions or code. And since code is given a content-addressed semantic identity internally, renames and formatting changes don&#x27;t require recompile or retesting.<p>Another piece that fell out of this was a testing framework called Warp, which combines replay, results caching, handler substitution, and a few other tools that I frankly wish I had when writing Python. There are a few examples available in the demos directory.<p>There&#x27;s more to do, but it&#x27;s installable and usable. I&#x27;m hoping people will have their agents digest the docs&#x2F;SKILL.md file and maybe write a few programs or see where it might fit in their projects. It should be particularly useful in agent systems. If an agent says something is painful or you as a human find the code tough to understand, I&#x27;d like to hear about it so I can address it.<p>More detail here:<p>Repository: <a href="https:&#x2F;&#x2F;github.com&#x2F;jbwinters&#x2F;jacquard-lang" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;jbwinters&#x2F;jacquard-lang</a><p>Further intro&#x2F;human-oriented write-up here: <a href="https:&#x2F;&#x2F;research.friendmachine.co&#x2F;jacquard&#x2F;" rel="nofollow">https:&#x2F;&#x2F;research.friendmachine.co&#x2F;jacquard&#x2F;</a>

The art and engineering of Sega CD Silpheed

Show HN: Hackney – Compare Uber, Lyft, Waymo, and Robotaxi Prices I created an app that compares real-time prices and wait times across Uber, Lyft, Waymo, Tesla Robotaxi, Curb, and Empower. It shows you all ride options in one list, then once you’re ready to book, it deeplinks you to the provider’s app with the route pre-filled.<p>I reverse-engineered ride-hailing mobile apps to understand how they fetch prices from their servers. You sign in to my app with your ride-hailing accounts, and then my app requests live prices from the same APIs that ride-hailing apps use. Importantly, my app is built using an on-device approach: the app on your phone stores authentication tokens locally and sends network requests directly to each ride-hailing company’s servers. This keeps your accounts private. I wrote a blog post showing network requests sent by my app, which you can verify yourself: <a href="https:&#x2F;&#x2F;blog.hackney.app&#x2F;p&#x2F;how-hackney-works" rel="nofollow">https:&#x2F;&#x2F;blog.hackney.app&#x2F;p&#x2F;how-hackney-works</a><p>This seems like an obvious app. Why doesn’t it already exist? That’s because most ride-hailing companies don’t offer public APIs for prices and wait times. Uber does offer one, but they prohibit using it for price comparison. When someone built a comparison app using the official API, Uber terminated their API access (<a href="https:&#x2F;&#x2F;www.benedelman.org&#x2F;news-053116" rel="nofollow">https:&#x2F;&#x2F;www.benedelman.org&#x2F;news-053116</a>). There are apps today that don’t use official APIs, but they run your account tokens through their servers and send price requests server-side.<p>To integrate a ride-hailing provider, my app sends network requests for sign-in, token refresh, ride prices, and ride history (to power a feature that shows you unified ride history across apps and how much you’ve saved on each ride). Some ride-hailing apps implement certificate pinning to prevent you from viewing their network requests, and some communicate with their server using Protobuf, a data format that doesn’t include the original field names. Building an app using this approach is technically complex, but it makes possible all sorts of useful products that couldn’t otherwise exist.<p>The app is completely free. In the future, I may monetize through a subscription or partnerships with ride-hailing companies. I’d love to hear your feedback. You can download it today.<p>iOS: <a href="https:&#x2F;&#x2F;apps.apple.com&#x2F;us&#x2F;app&#x2F;hackney-compare-rideshares&#x2F;id6754620049">https:&#x2F;&#x2F;apps.apple.com&#x2F;us&#x2F;app&#x2F;hackney-compare-rideshares&#x2F;id6...</a><p>Android: <a href="https:&#x2F;&#x2F;play.google.com&#x2F;store&#x2F;apps&#x2F;details?id=app.hackney">https:&#x2F;&#x2F;play.google.com&#x2F;store&#x2F;apps&#x2F;details?id=app.hackney</a>

[Other] From Muon to Gradient Clipping: Some Thoughts on QK Stability

Show HN: Clawk – Give coding agents a disposable Linux VM, not your laptop

Grok CLI uploaded the whole home directory to GCS

Show HN: A Sims-style house builder in the browser (Three.js, no back end)

Control the Ideas, Not the Code

A voxel Tokyo in real Japan time – ride the Yamanote line and study Japanese

Show HN: Pentaton LP – a music streamer with an LP sleeve sized display Hey HN! I always liked to see and touch the cover artwork of the CDs and LPs I bought in the past, but in the end the convenience of digital streaming won me over and I accepted no (or stamp-sized) artwork. Lately I’ve been missing this more and more and ultimately decided to try to do something about it. So I built a streamer from the ground up.<p>Happy to answer any questions, this is my first PCB design and 3D model all in one project.