If we are all honest, it seems to be the case - most of the time:
- Refactoring (Sometimes starting again.. this is rarely starting from scratch as there would have been some insights and personal design decisions garnered from the previous experience)
- Specificity (It is heavily influenced by energy which also is different depending time of day or on the individual level)
At the end of the day, it takes taste + experience of the user to make anything of notable complexity(architecture) with AI.(For now and the nearest future at least).
I find reading articles as this gives me a renewed sense of agency as a technologist and my growing list of passions.
A solid thank you to Lalit Maganti for sharing and the better HN community. I found a lot to steal reuse from the material/banter.
Beautiful presentation... @willybrauner, I would like to read your spin on a follow-up piece on `glitch-freedom`.
But in all honesty, this journal entry/post is a work of art; a testament to your journey as a technologist!.
Writing technical articles without adding a graphic and playful touch would indeed interest me less. I find that it's the intersection of these two worlds that makes reading enjoyable. Thanks for your kind words!
This is math, beauty, art, creativity, ... unique. My mind is all over the place.
Still wrapping my head around it but, I'd really like to see where this leads.
Think of egoism like a single-threaded algorithm assuming all actions optimize for self. Altruism suggests a multi-threaded model where some processes prioritize others’ well-being. Data from user behavior (empathy-driven actions) and system design (evolutionary efficiency) supports a hybrid model—humans aren’t just “selfish” codebases.
Debated since Hobbes, it’s challenged by:
- Butler’s Stone: Pleasure is a byproduct, not the goal.
- Science: Biology (altruism aids survival), neuroscience (motivation ≠ pleasure), and psychology (empathy drives genuine care) suggest mixed motives.
- Analogy: Egoism is a single-threaded “selfish” algorithm; altruism adds threads for others’ benefit. Data leans toward a hybrid model.
Whenever I dive into a creative project, whether it’s freelancing for a client or tinkering on my own stuff, I know exactly what’s coming. The dopamine hit from shipping code is unreal, like a high from solving a puzzle that’s been nagging me for days. The rep boost, the financial payoff (or potential for my own projects).
But deep down, it’s not just about me. Crafting something that users love or that makes their lives easier? That’s the real magic. It’s a mix of selfish thrill and selfless impact, like a perfectly balanced commit.
I use a linux distro as my driver; I'm a linux bro and also phone's still awaiting repairs). I opened my Firefox Developer Edition and tried opening Youtube and found I had been logged out. Tried gmail, same thing - My other gmail accounts too.
Gmail redirected me to url[0] to re-authenticate.
> Also, could you consider making each fourth (or first) column a very slightly lighter grey
This could be a component logic; a row of drop downs for customizing the UI and a good examples are color and grid count. This could even be a toml/json config file that can be imported/exported.
My own addition is ability to import samples from my own device.
"Usually"? I'm not saying there are literally no computers in existence that might have this much space on a single filesystem, but...has there ever been a known case of someone hitting this limit with a single SQLite file?
That's just 10 30TB HDDs. Throw in two more for redundancy and mount them in a single zfs raidz2 (a fancy RAID6). At about $600 per drive that's just $7200. Half that if you go with 28TB refurbished drives (throw in another drive to make up for lost capacity). That is in the realm of lots of people's hobby projects (mostly people who end up on /r/datahoarder). If you aren't into home-built NAS hardware you can even do this with stock Synology or QNAP devices
The limit is more about how much data you want to keep in sqlite before switching to a "proper" DBMS.
Also the limit above is for someone with the foresight that their database will be huge. In practice most sqlite files use the default page size of 4096, or 1024 if you created the file before the 2016 version. That limits your file to 17.6TB or 4.4TB respectively.
Never underestimate the ability of an organization to throw money at hardware and use things _far_ past their engineered scale as long as the performance is still good enough to not make critical infrastructure changes that, while necessary, might take real engineering.
Though to be fair to those organizations. It's amazing the performance someone can get out of a quarter million dollars of off the shelf server gear. Just imagine how much RAM and enterprise grade flash that can get someone off of AMD or Intel's highest bin CPU even at that budget!
The largest filesystems I could find are ~1EB and 700PB at Oak Ridge.
FWIW, I took the ‘usually’ to mean usually the theoretical file size limit on a machine is smaller than theoretical SQLite limit. It doesn’t necessarily imply that anyone’s hit the limit.
Wondered the same thing. That's a lot of data for just one file!
Did a full-day deep dive into SQLite a while back; funny how one tiny database runs the whole world—phones, AI, your fridge, your face... and like, five people keep it alive.
If we are all honest, it seems to be the case - most of the time:
- Refactoring (Sometimes starting again.. this is rarely starting from scratch as there would have been some insights and personal design decisions garnered from the previous experience) - Specificity (It is heavily influenced by energy which also is different depending time of day or on the individual level)
At the end of the day, it takes taste + experience of the user to make anything of notable complexity(architecture) with AI.(For now and the nearest future at least).
I find reading articles as this gives me a renewed sense of agency as a technologist and my growing list of passions.
A solid thank you to Lalit Maganti for sharing and the better HN community. I found a lot to steal reuse from the material/banter.
reply