this post was submitted on 10 Mar 2026
77 points (96.4% liked)

Selfhosted

56957 readers
444 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

  7. No low-effort posts. This is subjective and will largely be determined by the community member reports.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 2 years ago
MODERATORS
 

I'm building a new activitypub/threadiverse software focused on the needs of self hosters who want a single user instance.

I've been posting with it semi-regularly for the last month, and I think it's ready for an open demo.

One of my objectives is to have the lightest resource usage for memory and CPU constrained hardware, as well as the fastest loading web interface for older phones and limited data plans. I ran out of data on my phone last week and having a 41kb front page came in very handy.

You can try the web UI at https://scrapetacular.ydns.eu/latest You can also POST AS A GUEST TO THE FEDIVERSE without signing up. I'm not sure you can do this anywhere else, I'm manually approving posts on the backend because .. well you know. If it asks for a user and pass, use guest and guest, your post will appear with a username like guest4269.

Ideally, open this post https://scrapetacular.ydns.eu/post/10127 and reply to it.

My other plan for mobile is to target the Sync for Lemmy app, as it's dead, meaning it's no longer a moving target.

I've made a few technical choices aimed at keeping things fast

These include:

No ORMs

  • They are convenient but make performance tuning difficult when things get complex as you don't write the queries directly

No Javascript

  • I may have to go back on this if I keep the guest posting function, it might need a captcha or anubis.

No nested comments in the web UI

  • Nested comments are super slow, you are essentially querying the database for the OP, then querying for the N immediate children, then doing N queries for all of their children, then keep going recursively until you reach your depth limit, or all comments are found, you then need to render this structure with html/css

No front page images

  • This is more of a personal preference that happened to make things load faster, the front page displays the text of the OP and last few comments IN FULL, giving a good preview of the conversation, and allocating more space to people who write rather than post memes. Inline images in posts are also replaced with links.

No upvotes/downvotes

  • DID YOU KNOW that most threadiverse traffic is upvotes, downvotes adn emojis? You get an instant speedup by simply not processing them. Also, since this is a single user instance, all my comments are by definition awesome

ROADMAP

  • Massive refactor
  • Make the project public
  • unit tests (this is basically my only requirement for v1)
  • sync for lemmy API
  • admin UI
  • "AI" to "My Butt" wordfilter (mandatory and hardcoded)
  • default subscription to /c/fuck_AI
  • Solve channel discoverablity once and for all
  • SUPERBLOCK (i.e. block everyone who liked this comment)
  • dockerfile? I don't use docker tbh
  • Read Mastodon posts? Do they even have good content?

Tech Stack

  • Go
  • SQLite

I'm using the pure Go sqlite library, Bluemonday for html sanitisation, Blackfriday for Markdown and Migrate for auto db migrations.

End

Thanks to Snoopy and the Cool Froges at jlai.lu for allowing me to test on their channel.

Is this project of interest to you? Have I missed anything obvious? Is there anything else you would like to know?

you are viewing a single comment's thread
view the rest of the comments
[–] pienz@feddit.org 2 points 19 hours ago (1 children)

You might enjoy sqlc

Its like a reverse ORM

SQL -> Go

[–] admin@scrapetacular.ydns.eu 2 points 17 hours ago

Thanks, I think some of the nightmare front page queries will be a problem for this tool, but I can use some of the idioms for the rest