We fixed bugs and added notifications and mentions

Site is perpetually 2 seconds away from blowing itself up and aggressively erasing all files.

How did Mark Zuckerberg make Facebook in 2 days

It's actually literally gone lol. The backups failed.
Thankfully none of that lost data is very meaningful.

Picking up good web design where it left off.
nemmy.net/dev/playground

Only on Linux, the "easiest system to develop software on".

This is not an issue on Windows. SQLite should be able to delete a row by *waiting* for the other connections to finish. That's literally a core feature of SQLite. It's in the documentation. Why is it only working on Windows?

Big Nemmy update!
- Better mobile layout
- Strict NSFW filter is stricter
- Filter and sort commissions by price (WIP)
- Adds 600+ new commission-able artists per hour
- Bump yourself in commission searches by writing nemmy.net in your bsky description to become a supporter

Happy commissioning!

WIP: The "strict" NSFW filter setting is about to get stricter.
Profiles containing "🔞" or "nsfw" will be hidden. I'll add the red text for transparency.

Also: Empty galleries will be completely hidden so they don't waste space. This includes galleries that appear empty because of NSFW filtering.

I write 90% of the backend SQL inside a 500-line file called "query.sql". SQLC turns each statement into a corresponding Go function to execute it and it's the best SQL tool ever made.

(Except the devs are neglecting an important PR so now I'm hosting a fork to compile certain SQLite3 statements)

Writing code on the go:
You guys have WEIRD spelling.

I took these samples from various accounts and I'm adding more parser rules so you can appear in searches

I write 80% of the frontend logic inside a string on a div. This is just how AlpineJS works, and it's the best JavaScript framework ever made.

Experiment: Bump yourself on the site.
- A random bumped artist appears in 33% of searches.
- Users won't get the same bumped artist for 60 seconds.
(Users won't see you 100 times and get angry)

How do artists bump? By updating their prices or writing nemmy.net in their bio? Comment your ideas:

Welcome to my software yap account. I'll be talking about how FUN it is to manage a website on a $7 Linux box with one fat SQLite database and 1.5 million rows

Wanna recommend artists for work/commission?
Or are you browsing the commission database and getting unrelated garbage?

You can now find related artists and/or share who you follow! Type anyone's bsky handle or click "Find more" on artists: nemmy.net/artstat

I wrote some fun details in comments: