Prompting with documentation and examples works. In an agentic tool having an MCP server for the db helps assuming it is a straightforward schema with explicitly defined relationships. Also helps if the tables correspond to entities in a natural way.

Agreed with that. As with writing SQL by hand you have to be very specific with instructing an LLM. There are many ways to get to a solution in SQL all present different tradeoffs and corner cases. I found that people that don't understand SQL and the basic of a given schema produce garbage both by hand and with LLMs

Good point. Think of the device as a lock pick for Aldi carts you can remove it and don't need to leave your keychain.

It's not a lock pick for the carts, you need to leave it in.

There are some that you don't have to leave in the slot - they got quite widespread a few years back https://www.printables.com/model/430247-shopping-cart-coin-s...

I remember looking at palm webos devices in 2010 and thinking this is cool. The docs on how things worked were really good for the time. The hardware was sleek palm pre if I remember correctly.

I was not keeping track of who bought whom at the time an why. But was surprised when webos got shut down. Android was gaining traction windows mobile on the way out. I bought an old Nokia e63 around the time because I was short on money and I loved the keyboard. The article gave me some nice nostalgic memories.

Yes you can e.g. with the replit app. Quite powerful if you don't have a preferred editor and can stand the haptics of a phone to edit stuff

Same experience. For a while I had to do chrome again because it became unusable on my aging phone and then they turned the ship around.

I am always stunned when I have to use anything else at how unusable some pages are without my extensions.

Just to add another perspective:

Native apps are sticky. As an example a Webshop has no reason to have a native app (likely it is a browser wrapper anyway).

However, being installed puts you right in front of the users noses everytime the unlock the phone. Just look at the discounts that are offered for installing Native apps or shops that are app only to begin with.

Awesome. I recently had similar thoughts and then I was considering all the variations in the android eco system. Lots of times when I am helping I have to just rely ony intuition because I am not familiar with the specific flavour of android used by Samsung or whatever else sonone might have.

I will have a look at your material. Maybe I can localize it to my needs.

Thank you so much, I would really appreciate any feedback about that!

I also did something similar for my spring project. The idea was to buy a used car and I was frustrated with the BS the listing sites claimed as fair price etc..

I went the browser extension route and used grease monkey to inject custom JavaScript. I patched the window.fetch and because it was a react page it did most of the work for me providing me with a slightly convolute JSON doc everytime I scrolled. Getting the data extracted was only a question of getting a flask API with correct CORS settings running.

Thanks for posting using a local proxy for even more control could be helpful in the future.

Apparently there is no web extension API to inspect the body of a fetch response and you have to override window.fetch

Seems like an omission in the spec.

If we're talking about chrome extension, yes.

But firefox extension expose API to inspect the response stream.

Can you link the MDN page for this?

Yep:" casual and dial up the puns" It is funny though ;)