Benefits of using SQLite:
> user reports bug
> i download the site database to my PC
> run the site in a debugger
> log into user's account
> set breakpoint
> find the error

We fixed bugs and added notifications and mentions

Come try out my indie website
There's a link and a Discord. Let's invent a bunch of random features!

nemmy.net
discord.gg/5AVP5tXKXt

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

How did Mark Zuckerberg make Facebook in 2 days

Nemmy is up and running again!

Soon I will re-index 1.5 million Bsky accounts for the commission browser.

Nemmy update: All our harddrives gone..

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

Occasionally I ask myself: Should I program a SPA website?

But every time I use a SPA website, loading pages takes a long time and it forgets lots of state.

When I refresh my own pages, it's so smooth that it looks like nothing happens at all. The back button is instant. No flickers.

So, no SPA.

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: