dennis16384

People still complain about 95mb download in 2026. It's literally 2 minutes of 1080p youtube watching.

Why bring server software to edge devices? Because its fucking awesome!

clickhouse?

"With experience and support from" is a nice landing trick!

How do you extract and relate to each other the facts from the documents that require comprehension and not simple similarity matching using common embeddings models?

This is the kind of content we all deserved in 2026, and this is still why I ask during interviews to explain how cookies are represented in HTTP protocol.

Working on https://routing24.com, free route optimization for businesses.

Recently started some agentic features for paid version, and this lead to a side project https://eatmydata.ai - a question-to-sql-to-dashboard builder, where data doesn't get exposed to AI (with bundled in-browser SQLite vector search, NER and many other features).

The latter is open-sourced under MIT: https://github.com/eatmydata-org/eatmydata

Hope they'll move eventually to consumer AI devices

Why would an LLM want to look into the contents, what for?

We have low-cardinality data and yes this is safe to share and required to build an actual query.

Then we have high-cardinality and possibly PII - there’s absolutely no reason to share that data, there’s nothing for LLM to analyse there. Also semantic index (vector search) will find relevant records much faster and more accurately that any chain-of-thoughts just with an LLM-authored search fn call.

Further there are continuous numerical values and there’s not much LLM needs to see in there either. We can say, for example, if you look at data distributions when building your analysis, it can drive your analysis logic, but another point of view here is taht it creates unnecessary bias instead.

Totally. One thing that all major AI vendors are not doing currently is merging server AI with edge devices.

For example, there is no way neither in Claude nor in ChatGPT to run your own WASM or JS or whatever AI produces directly in user's browser context as a tool/skill - there is no call site for that. The only option is remote server-side.

My whole idea was that AI can perfectly write SQL and dashboard code knowing only the shape of your data and not it's contents. With direct upload to vendor now we're forced to share the contents.

Fast response. I can upload Excel/csv and iterate under 10 seconds from question to result. Doing same thing in Claude with 10x less data takes 5 minutes.

Nice, I recently did a similar but much simpler thing and open-sourced it under MIT, maybe some bits and pieced will be useful https://github.com/eatmydata-org/eatmydata

For example, MIT-licensed sqlite vector search extension.

Overall, I have a orchestrator - sql coder - js coder - dashboards, all without backend, running locally in the browser. It's mostly tested on small analysis and question answering with Gemini Flash Lite, and the overall target was speed from question to answer, including data sharing and waiting.

I built a question-to-sql-to dashboard tool for quick data analysis, just to avoid sharing random personal or customer xlsx documents with external AI. Released it as MIT recently:

https://eatmydata.ai/

https://github.com/eatmydata-org/eatmydata

Thanks! Yep will change the UI there.

For the "show me how many people are from Dallas" in AdventureWorks, it really depends on the model.

With `gemini-3.1-flash-lite` for all agents it produces this sql from the first try for $0.0033: ``` SELECT COUNT(DISTINCT ca.CustomerID) as customer_count FROM CustomerAddress ca JOIN ( SELECT a.AddressID FROM vector_search('Address', 'City', 'Dallas', 20) vs JOIN Address a ON a.rowid = vs.rowid WHERE a.City = 'Dallas' ) addr ON ca.AddressID = addr.AddressID ```

and then formats output in Markdown.

I'll bake some default model in later, and more examples. And I guess it needs some default token quota.

I'm working on Routing24 https://routing24.com - we are building free route optimization tool for businesses to plan multi-vehicle multi-stop routes.

Multi-threaded WebAssembly in action for route optimization, all bundled with geocoding, OSM maps and routing, and provided world-wide.

We're adding driver's PWA, saving and sharing of route optimization projects, editing of optimized routes, sharing it with others either for execution or for approval, integrations and AI-assisted data imports, auth flows, support prompts, sales automation and all that boring stuff.

Thanks! I haven't figured out the commercial part yet, but plan to have forever fee tier in the future too.

I keep working on Routing24 https://routing24.com, a free route optimization tool for businesses.

It's been approx. an year since we are up and running, and we helped 100+ businesses in the US and world-wide to understand the value and savings of automated route planning, and prepared tens thousands of optimized routes for companies operating from 1 to 50 vehicles. All this keeping our operational expenses low and flat, thanks to our local-first route optimization engine working in the browser, and reliance on OpenStreetMap.

Well, trying out is better than a thousands words

Let's start it with index of whole Spain, 2.4gb download, 4gb on disk: https://gist.github.com/dkourilov/e243270684b5973f1fac005c78...

I'd say it's pretty usable to run a EU-sized country or several US states on any commodity PC. For embedded devices, it really depends what is the device. On Raspberry PI it should be fine for batch geocoding, realtime (typeahead) will definitely be lagging.

Have you measured actual memory and disk requirements of a photon OpenSearch index vs your sqlite database?

Why not package photon?

Google Cloud Armor plus Load Balancer?

You can balance traffic to external networks or clouds with it too.

But you _can_ open a bank account remotely for a DE LLC. Both Wise and Mercury supported this for years.

Even though Algorave is quite new, everyone who ever touched .mod/.s3m/.xm/.it can fell young again haha.

DJ_Dave live events are the best illustration for all of it. If you love electronic music, ever touched any generative art, and know basic coding this is for you.

Routing24 | Last Mile Logistics Expert | Remote (Worldwide) | https://routing24.com | Part-Time

Routing24 builds and provides professional route optimization tools to SMBs for free.

We are seeking a part-time consultant and advisor with extensive experience deploying commercial route optimization and TMS/DMS products in real-world business environments.

We offer hourly or per-project rates. To apply, please email: denis@routing24.com

I'm still working on Routing24 https://routing24.com - free route optimization and planning app without stops or vehicles limit.

It's been 6 month since our first appearance on Show HN [1], and I'm working with first free users on bugs, improved workflows and UX, geocoding, solver features, future mobile app etc. etc.

We officially crossed the limits of 1500 stops per optimization with some waste collection guys, all still running fully client-side in the browser.

[1] https://news.ycombinator.com/item?id=41995427

Sure, I'm aware of that one and no, not using it.

Thanks! Yes I'm designing landing at the moment to showcase ready optimization results straight away.

You're right, I must've been living in Germany long enough to have it imprinted in my subconscious :)

Thanks very much!

Hi there, and thank you for being a Photon contributor! I plan to contribute back OpenAddresses import soon.

Currently distance/duration matrix is built server-side yes. Eventually this part will be fully local too.

Working on "tiled" CH first and then CCH. I haven't even investigated patent and license situation around customizable contraction hierarchies yet.

Yes eventually.

It will be an open-core model once monetization is figured out.

With this said, the idea is to have all functionality you see at the moment (and even more in the future) as forever free.

Both sounds like proper features which are not covered yet, thanks for your input!

I already have support for >1 vehicle profiles that uses more than 1 distance/duration matrix for different vehicle types.

This is a wider subject however, that includes road closures and time-dependent access. Also truck routing attributes have questionable quality in default OSM, therefor we do not specifically advertise truck routing for now.

I'll definitely consider an option to have GPX export when will be implementing dispatching to drivers in the future.

However it is always better to dispatch to your own mobile app and call external navigation for point-to-point route, this is a more standard use case rather than opening a multi-stop route directly in navigation app.

Thanks for clarifying - yes this looks like single-vehicle TSP without any business rules/side constraints. Not usable for many vehicles either.