nostr:npub18a5a26am2vgedyzqnc4e8ymk6ryxn0m94d7z0wxe4xck06kcjurq8hteny Our app isn't on F-Droid, I'm working to get our official app on the app stores!

nostr:npub1gzf2fm303rd3jtsatw8cvcyzajsgpdh4rtzx5zd45l6dcrtk3ktsqtng9e Redis is really useful for larger instances, but for smaller ones, they can def get by with the database.

The challenges that masto/pf have are not common, and tbh would be probably better served with a graph database but that's a toot for another day

nostr:npub1kzcmvy4twrrhyv0p65q28tm6axf5ukcchd44ya0t3d4k36tsu5cqwfe83z Nope, the sqlite support is mostly for our tests, though it can be used but like you pointed out, the locking nature of sqlite would make it challenging

nostr:npub106mx9pfj32hujkk9e8k4vf0pue8cwmsj22c6vd5df7khxsyf2dasm8hdmw Yes

nostr:npub1c3wq6pexa6r4agn6m57nrl6y2klaq02w4uvfy66secfeae54h6sqtl8xn9 nostr:npub120zh308gs69j3vwgvvrzgglv58vsk3q0vef43uajyu0lc3mtldsq2p33r2 haha, I think laravel does support redis as a database driver, and mongo too!

We do use a few SQL-dialect specific queries so BOOO! And also that is really impressive, TAKE THIS LIKE AND HAVE A NICE DAY

Vacuum?? I don't know her

- fediverse server using mysql running since 2018 without any db issues

Also I should mention how 💅 it is that nostr:npub120zh308gs69j3vwgvvrzgglv58vsk3q0vef43uajyu0lc3mtldsq2p33r2 is the only fediverse project that supports both MySQL and Postgres (and soon sqlite)

You can also use your database as a queue instead of redis, which is okay for smaller instances

It's technically possible to run pixelfed with a sqlite database, though I can't guarantee that every SQL query is supported atm

I'm working to remove Redis as a dep

and

add basic sqlite support for one-click installs (meant for low use instances of 10 or fewer users)

Can you imagine, we don't require npm so this could be as easy as WordPress to install, or easier with a no-config sqlite db

pixelfed.social is running on a single 16G intel optimized droplet, with an 8G database server (and another potential replica)

we should have no problem accommodating a few thousand new users, last nov we peaked at more than double current MAU

that being said, I'm ready to scale out, and laravel supports read replicas via easy config (and horizon is scalable)!

pixelfed federation is highly optimized (inbox and async concurrent outgoing), as are most APIs except the home feed, which I'm fixing

Oh man, re-watching this has me balling, it was a great show but I can't help but think of myself as Clarke and being alone only to find myself surrounded by friends.

It's you fedi, your the friends.

I used to be reckless and was court ordered no contact with my friends was isolated, I was so alone and was desperate for something. I started learnin webdev and it was my beacon of hope

Now I'm clean, and in a much better place, and with friends again.

U mean a lot more to ppl than u realize ❤️

"I don't want to be alone"

"I suppose that choice was made easier with the realization you wouldn't be"

"you can choose to come back?"

"of course, though until now, no one ever had"

https://www.youtube.com/watch?v=do8n01R7JoM

#PubKit it's not you, it's me. I just need some time.

Maybe we can link up again soon, after my app goes out of town 😈 #activityPub

I can't wait to work on backend perf improvements and ship the new home feed logic, backend dev is my passion and dealing with scaling/perf issues is so rewarding.

Who spends their weekends wanting bursty traffic to highlight bottlenecks -> this weirdo

nostr:npub1hed264zqxsj22cuqga4v6k6m8nzfgdydn66nhf2w96dsjnp26zhshy9wt0 The server costs are about $500/month and we're overprovisioned atm but this covers all 7 servers that power pixelfed.org, pixelfed.social, fedidb.org, fediverse.info and more!

For the record, I'm incredibly proud of nostr:npub120zh308gs69j3vwgvvrzgglv58vsk3q0vef43uajyu0lc3mtldsq2p33r2 and the Wired article, but it won't change the promise I made to myself when I started this project

I will remain humble, and I want y'all to keep me humble, because nostr:npub120zh308gs69j3vwgvvrzgglv58vsk3q0vef43uajyu0lc3mtldsq2p33r2 is a community build by many people

I just wrote some code

Y'all made this relevant ❤️

Sorry #PubKit, I think it's time I drop everything and focus on the nostr:npub120zh308gs69j3vwgvvrzgglv58vsk3q0vef43uajyu0lc3mtldsq2p33r2 app and a public release.

All those long nights working on backend scalability and performance improvements are about to be put to the test

I wasn't anticipating this attention for a few more months, but I'm ready 😎

So nervous to read that Wired article, I'm lowkey at a loss for words

omg wired wrote about nostr:npub120zh308gs69j3vwgvvrzgglv58vsk3q0vef43uajyu0lc3mtldsq2p33r2

I grew up OBSESSED with Wired, my brothers had Nintendo Power subs and me, you guessed it

Lil dansup would be so proud😭

nostr:npub19gcmusfjq0w4vqpxlftclxfsd2cpmda03qcmj0mp2ef54gp3epns02tf0t nostr:npub1e02fguvg4fqenpu0222x0fhur9ts6resx5uq88du7zmp5wxl3xfqp7fmvm Can you name any other fediverse project with a chat UI that has "{username} is typing..." indicators along with real time chats?

Matrix wasn't working for the media interview I just did (unable to decrypt message), so I tried a nostr:npub1e02fguvg4fqenpu0222x0fhur9ts6resx5uq88du7zmp5wxl3xfqp7fmvm chat and WOW!

We chatted for over an hour, and even shared images and videos, I'm mind blown!