add self-hosted plan for self-hosted flavor

[darkskygit]

No description provided.

[affine-issue-bot]

Upcoming in: v0.14.0

We've got great news! 🚀 This issue's fix/feature is slated for release in AFFiNE v0.14.0.
Subscribe to this issue for a notification when the release goes live!

^{_{This is an automatic reply by the bot.}}

[affine-issue-bot]

Issue Status: 💡 Open

💡 Open

We want to implement the fix or feature in the near future. We can’t promise it will appear in the next public release, but it’s on our short list.

^{_{This is an automatic reply by the bot.}}

[darkskygit]

the original intention of this issue is to "promote the repair of the self-hosted plan" rather than "what feature should self-hosted have?" or "what license should an open source project have?"
there are already too many off-topic discussions, i am here Mark all off-topic discussions as off-topic.

if you have any questions and discussions related to self-hosted, please go to: https://github.com/toeverything/AFFiNE/discussions to discuss

[alissa-tung]

Hello, curious about is there progress on it? Is self host version can still only have three users in one workspace, and the space is limited to 10 GiB?

[Artaud]

Hello, curious about is there progress on it? Is self host version can still only have three users in one workspace, and the space is limited to 10 GiB?

You can set your users to be on the Pro plan manually in the database, which raises the limits.

[alissa-tung]

Hello, curious about is there progress on it? Is self host version can still only have three users in one workspace, and the space is limited to 10 GiB?

You can set your users to be on the Pro plan manually in the database, which raises the limits.

Thank you, I had connect to the self-host pg, would it be convenient to share which table has the field for pro? thank you

[Artaud]

It's not hard to figure out - the user_features table has a feature_id column which links the user to a specific plan, listed in the features table.
I have my users set to 6, which is the pro_plan_v1.

[alissa-tung]

It's not hard to figure out - the user_features table has a feature_id column which links the user to a specific plan, listed in the features table. I have my users set to 6, which is the pro_plan_v1.

Thank you, save my day!

[alissa-tung]

from

AFFiNE/packages/backend/server/src/core/quota/schema.ts

Line 37 in a14194c

memberLimit: 10,

seems that even with pro_plan_v1, memberLimit is set to 10, maybe I should package an image my self

NO need for a new docker image

---

The correct feature_id for user_features is in table features, which may look like

docker exec -it affine_postgres psql -U affine

affine=# select id, feature, configs from features where feature = 'pro_plan_v1';
 id |   feature   |                                                    configs                                                    
----+-------------+---------------------------------------------------------------------------------------------------------------
  6 | pro_plan_v1 | {"name":"Pro","blobLimit":104857600,"storageQuota":107374182400,"historyPeriod":2592000000,"memberLimit":100}
 11 | pro_plan_v1 | {"name":"Pro","blobLimit":104857600,"storageQuota":107374182400,"historyPeriod":2592000000,"memberLimit":100}
(2 rows)

in the configs, update JSON to one with larger memberLimit is enough.

after that, reboot the docker compose