Going to document some approaches to produce data visualizations using ari via DuckDB.
Donโt know why it didnโt occur to me earlier, that there would be some solid community extensions for #dataviznotesfollow in DuckDB.
I was trying to use an approach that relies on community extensions, but installing them is proving finicky.
Going to consider an approach that requires less futzing.
textlog runs on a 2.5โฌ/mo vps 1 core/2gb ram, using just one instance of Bun with its embedded SQLite. Works perfect and I run a few other apps as well on that machine.
Huge refactor today, moved from sync SQLite to Worker based, touched 88 files, pre-#AInotesfollow it would have taken a week or so, finished now in ~1:30h. And I wouldnโt have the confidence I have now that it went correct. It went well, though a bug or two might surface, weโll see.
SQLite is embedded in the main thread same as the HTTP server. I noticed some requests dropping and because the queries have become more complex I figured it has to do with SQLite blocking for too much time. Moving it to a Worker makes the DB asynchronous and bypass this problem.
That's definitely the common knowledge but I'm starting to think that victory -> writing about it has it backwards in a lot of cases, esp in modern corporate life.
Iโm an insane person who built their own coding harness, in Rust. Iโve called it Rho. Please forgive this landing page: https://rho-code.dev I just wanted an easy central spot.
Not insane at all. People should build their own instead of using other people's agents. It's easy to do and the results can be great for you. I've built several; one that is effectively "stuck" in Kakoune: youtube.com/โฆ/playlistYouTubeLLMs stuck in Kakoune
Yeah. It's a very large project with lots of dependencies. <The system prompt is long and wastes tokens. If you have ideas for tools (or automations like the agents.sh "loop" I wrote) it's easier if you understand the harness.
#AInotesfollow brings so many issues. It really accelerates. Not only the good parts but also the bad parts. Combine this with a product person that doesn't even know what a refinement is. I'm 41, maybe I'll study to pivot, maybe I'll get into trading. I can't handle it anymore.
what is a refinement? honest question - I'm restructuring our refinements now. Like having group of people discussing 5 items in an hour gives little chances any one of them will be addressed properly, unless they are trivial.
Architect/lead have a pre-refinement with product to clear 80% of the obvious questions. We share an agenda, devs can ask questions async. In the refinement product presents, we design a solution draft. 15 minutes/item. This doesn't work if product is incompetent and everything is AI-slopped.