this post was submitted on 12 Jul 2025
233 points (97.9% liked)

Selfhosted

59861 readers
649 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.

  3. Posts here are to be centered around self-hosting. Please ensure it is clear in your post how it relates to self-hosting.

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

  5. Submission headline should match the article title.

  6. No trolling.

Resources:

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

Questions? DM the mods!

founded 3 years ago
MODERATORS
 

A new open-source Single Sign-On (SSO) provider designed to simplify user and access management.

Features:

  • ๐Ÿ™‹โ€โ™‚๏ธ User Management
  • ๐ŸŒ OpenID Connect (OIDC) Provider
  • ๐Ÿ”€ Proxy ForwardAuth Domains
  • ๐Ÿ“ง User Registration and Invitations
  • ๐Ÿ”‘ Passkey Support
  • ๐Ÿ” Secure Password Reset with Email Verification
  • ๐ŸŽจ Custom Branding Options

Screenshot of the login portal:

you are viewing a single comment's thread
view the rest of the comments
[โ€“] illusionist@lemmy.zip -1 points 11 months ago* (last edited 11 months ago) (2 children)

How does it lock you in? You, the admin, has full control over postgres. Sqlite has no security features. Does it store passwords? Sqlite also locks the database which is usually OK if there are no concurrent jobs. But for such services it sounds like a bad idea to use sqlite. (I am no server/app dev)

[โ€“] lime_red@lemmy.world 2 points 11 months ago

Sqlite shouldn't lock for read, so unless you are writing something at each access, you can have thousands of concurrent reads. The Sqlite website spells this out, and lists its own self as the proof.

This would mean you could not write logs to the database, you'd have to do it the unixy way and put logs in a text file.

[โ€“] lambalicious 1 points 11 months ago

It locks you to postgres. You don't necessarily have full control over postgres unless you are using your own instance / service, but oftentimes you might need to connect to an external one. SQLite gives you a local option.

Also what do you even mean with "does it store passwords?" A password is just a TEXT or a BLOB if you are feeling charitable and SQLite does support those since forever. If you can store "hello world" you can store a password (just.. don't do it in plaintext, but storage is different from encryption).