My favourite part of the day: commenting LLMentalist under AI articles.
msage
joined 2 years ago
Really depends on many factors. If you have everything in RAM, almost nothing matters.
If your dataset outgrows the capacity, various things start to matter, based on your workload. Random reads need to have good indices (also writes with unique columns), OLAPs benefit from work_mem, >100M rows will need good partitioning, OLTP may even need some custom solutions if you need to keep a long history, but not for every transaction.
But even with >B of rows, Postgres can handle it with relative ease, if you know what you're doing. Usually even on a hardware you would consider absolutely inadequate (last year I migrated our company DB from MySQL to Postgres, and with even more data and more complex workflows we downsized our RAM by more than half).
Postgres is so quick if you know how to use it...
Gentoo is the only way.
Me, for instance
I mean yeah, I selfhost everything, but I hate that i have to learn and support the most useless shit ever just to earn a living.
It used to be fun being a dev, now I'm just repeating the same warning phrases about technologies.
I'm losing my will to live lately at an alarming rate.
I used to love IT, way back at the start of 00s.
Soon after the 10s started, I noticed bullshit trends replacing one another... like crypto or clouds or SaaS... but now with the AI I just feel alienated. Like we're just all going to hell, and I hate the first row seating.
So we are moving away from >1GB node_modules finally? Or is it too soon?
It's voice and video calling with chat and screensharing. I intend to use it for a language school. It's extendable, for instance you can also self-host a whiteboard, where everyone can draw. You can see the drawing in real time, which is good for asian languages, where direction of the stroke is important.
Free, open-source, packaged in Debian, runs without issues, used it with friends for multi-hour voice chats during gaming nights.
On the server you can configure things like FPS for screenshare. I have yet to adjust that and try streaming video/game through it.
Way too few mentions of Jitsi.
I use it with friends, it has good server config, and I'm pushing it on businesses.
The current drive behind AI is not progress, it's locking knowledge behind a paywall.
As soon as one company perfects their AI, it will draw everyone to use it, marketing it as 'time saver' so you don't have to do anything (including browsing the web, which is in decline even now). Just ask and you shall receive everything.
Once everyone gets hooked, and there won't be any competiton left, they will own the population. News, purchase recommendations, learning, everything we do to work on our congitive abilities will be sold through a single vendor.
Suddenly you own the minds of many people, who can't think for themselves, or search for knowledge on their own... and that's already happening.
And it's not the progress I was hoping to see in my lifetime.