phiresky

I created a draft PR which (indirectly) adds HTML output: https://github.com/typst/typst/pull/461

I created a draft PR which (indirectly) adds docx output: https://github.com/typst/typst/pull/461

I created a draft PR which (indirectly) adds latex output: https://github.com/typst/typst/pull/461

Hey everyone. Posting here since there's people that can maybe help more (@tbe @johanndt ). Here's the top 30 currently most expensive queries on lemmy.world (by total_exec_time). Note that times...

There's also [protocol handlers](https://developer.mozilla.org/en-US/docs/Web/API/Navigator/registerProtocolHandler/Web-based_protocol_handlers). On your home instance, lemmy-ui (or your favourite app would register itself as a `web+lemmy:` protocol handler. In JS this looks like `navigator.registerProtocolHandler("web+lemmy", "https://lemmy.world/resolve?url=%s", "Lemmy cross-instance...

Hey. I want to mention this: One large issue with the post hot rank queries when filtering by community_follower (so the user-specific page) is that the post_aggregate.hot_rank column is in...

Deadlocks in PG aren't really critical at all - on deadlock the code should retry the transactions until they go through. But they can also be prevented. Deadlocks only happen...

This won't affect deadlocks because deadlocks can only happen while a locking transaction or query is running, the amount of open connections isn't relevant. Still might be a good idea...

This is only kinda related but I wanted to mention that rate-limiting by full ipv6 addresses is pretty useless (except for the most honest of users) because you get assigned...

Great! But I think you have an issue with your query performance because you're filtering by a different column than you're ordering by. In order for your selects to be...