Pretty sure this is directly inspired by C so I would guess Guido van Rossum (the author of Python) just used what was already common back then. As in, = is assignment operator and == is equality/comparison operator.
https://en.cppreference.com/w/c/language/operator_comparison
Numbers from my instance, running for about a 1 year and with average ~2 MAU. According to some quick db queries there is currently 580 actively subscribed communities (it was probably a lot less before I used the subscribe bot to populate the All tab).
SELECT pg_size_pretty( pg_database_size('lemmy') ): 17 GB
Backblaze B2 (S3) reports average 22.5 GB stored. With everything capped to max 1 USD, I pay cents - no idea how backblaze does it but it’s really super cheap, except for some specific transactions done on the bucket afaik, which pictrs does not seem to do.
According to my zabbix monitoring, two months ago (I don’t keep longer stats) the DB had only about 14G of data, so with this much communities I am getting about 1.5G per month (it’s probably a bit more as I was recently prunning stuff from some dead instances).
Prometheus says whole lemmy service (I use traefik) is getting within about 5 req/s (1m average) though if I go lower it does spike a lot, up to 12 requests within a second then nothing for few.
Attach it to the VM
Is this possible only with the extra, bought storage boxes ? Or is this possible even with the free 100G backup boxes offered with each dedicated machine ? (Or is this just nfs mount?)
We have a dedicated machine in a project from Hetzner with big raided hard disks but the latency is starting creep up on us, moving some of the data off to the faster ssd/san boxes would be rather helpful.
Run your ip through ip abuse databases to make sure there is nothing wrong perceived from outside.
What about edibles or drops? You could differentiate if it’s because of the smoking or weed in general.
Uv is currently only a pip replacement as a dependency resolver (and downloader), it was actually adopted by astral from a different dev afaik
Here too, found it many years ago, bought the Pro pretty soon after and now have been using it ever since. It just does everything right.
No space and time for creativity or “doing it right”, just do it fast, like yesterday also that feature we talked about three months ago? yeah, client also needs this added …
Or even better: this is what up to 20 years of technical debt does to people
Or the reply has set different language (even if it’s written in English) then what you have enabled in profile settings.
Love getting these peak behinds!
Also for someone like me who didn’t knwo what Houdini is:
Houdini is built from the ground up to be a procedural system that empowers artists to work freely, create multiple iterations and rapidly share workflows with colleagues.
On point summary.
And I was just about to write that I have confirmed SQLi is not possible to find out I have missed something that might in-turn make it possible! holy hell back to drawing board
Post edited with link to more information.
How did you fail?
VLANs (Virtual LANs) are for isolating devices from each other (while still being plugged to the “LAN” ports of the same router).
Ah, you are using pretty different deployment then, even the used postgres image is different then the usual deployment ( pgautoupgrade/pgautoupgrade:16-alpine instead of postgres:16-alpine) this might or might not cause differences.
I would try increasing POSTGRES_POOL_SIZE to 10-20, but I am guessing here, the idea being that lemmy is hammering postgres through the default 5 conns which increases CPU but that is a bit of stretch
do you also have pict-rs connected to this postgres instance? that is surprisingly low number to me, I would have expected anywhere between 20-50 active connections (I use 50 for lemmy and 20 for pict-rs, configured in their respective conf files)
extension “pg_stats_statements” is not available
According to this https://stackoverflow.com/a/72966651/5881796
The extension is not loaded: CREATE EXTENSION pg_stat_statements;
hmm, how many connections are used SELECT count(*) FROM pg_stat_activity; ?
I am not a master postgres admin but my intuition has been that the amount of connections is a big factor in how pg behaves with cpu and mem.
Do you have any tweaks of pg settings? Eg. shm mem, shared_buffers etc. ?
If not you migh want to: https://pgtune.leopard.in.ua/
This.
venv
pip-tools
Specify your primary dependencies in pyproject.toml and use pip-compile to keep stuff locked in requirements.txt to exact versions (or even hashes).
Though after working with cargo a bit, I would love to have all of this in a first-class program, hope uv can get there.