Matt Baer

Photos, words, privacy, and the open web. Dreaming of another future. 📍 Brooklyn

Founder https://musing.studio / @write_as :writeas:
Lead dev @writefreely :writefreely:
Co-organizer @nycphotostroll
Admin @ https://Writing.Exchange

Toots are searchable. #fedi22 #writing #stories #poetry #software #fediverse #web #photography

Public Key

npub1eh33dlkkp8kgj6w8jffsn5wqpte8wwfavxl90xq0huu8h7qvdh5sk6ysfx

NIP-05 Address

[email protected]

Profile Code

nprofile1qqsvmccklmtqnmyfd8rey5cf68qq4unh8y7kr0jhnq8m7wrmlqxxm6gpp4mhxue69uhkummn9ekx7mqzp7qjv

Publishing to

nos.lol

Author Public Key

npub1eh33dlkkp8kgj6w8jffsn5wqpte8wwfavxl90xq0huu8h7qvdh5sk6ysfx

Show more details

Last Notes

2024-04-17 20:20:32

- reply

Ah, and replies-to-replies.
Right now there's no way to directly reply to a comment on Remark.as, so I'll have to add that in the UI. Then I have to figure out how to handle replies from the fediverse to other fediverse replies.
They're ignored for now, but I'm keeping the `replies` info on the original replies so ideally we can do something there.

2023-08-11 22:45:26

- reply

@npub1u8s…cwxn Yep it's MySQL. Put some more information here: https://github.com/writefreely/writefreely/issues/741

2023-08-11 16:28:06

I'm looking for a little help working through some database scaling issues with #WriteFreely.
On our Write.as instance, we're up to 4.25 million rows in our `posts` table, and it's causing problems for some individual blogs with 9,000+ posts.
I have an idea of what some bottleneck queries are. But wondering if there are easy db optimizations we might make (indexes, etc.), and if anyone can help identify what they might be.
Boosts appreciated!