GET https://kbin.spritesserver.nl/m/lemmy_support@lemmy.ml/t/11991/RFC-Add-custom-fields-to-local-site-and-local-user-tables/newest

Response
200 OK
IP
18.188.130.151
Profiled on
Token
2e0bdd

Security

Token

There is no security token.

Firewall

main Name
Security enabled
Stateless

Configuration

Key Value
provider security.user.provider.concrete.app_user_provider
context main
entry_point App\Security\KbinAuthenticator
user_checker App\Security\UserChecker
access_denied_handler (none)
access_denied_url (none)
authenticators 
[
  "two_factor"
  "remember_me"
  "App\Security\KbinAuthenticator"
  "App\Security\FacebookAuthenticator"
  "App\Security\GoogleAuthenticator"
  "App\Security\GithubAuthenticator"
  "App\Security\KeycloakAuthenticator"
]

Listeners

Listener Duration Response 
Symfony\Component\Security\Http\Firewall\ChannelListener {#723
  -map: Symfony\Component\Security\Http\AccessMap {#722 …}
  -logger: Monolog\Logger {#783 …}
  -httpPort: 80
  -httpsPort: 443
}
 0.00 ms (none) 
Symfony\Component\Security\Http\Firewall\ContextListener {#706
  -tokenStorage: Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage {#1017 …}
  -sessionKey: "_security_main"
  -logger: Monolog\Logger {#783 …}
  -userProviders: Symfony\Component\DependencyInjection\Argument\RewindableGenerator {#705 …}
  -dispatcher: Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher {#747 …}
  -registered: false
  -trustResolver: Scheb\TwoFactorBundle\Security\Authentication\AuthenticationTrustResolver {#780 …}
  -sessionTrackerEnabler: Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage::enableUsageTracking(): void {#703 …}
}
 0.14 ms (none) 
Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener {#584
  -authenticatorManager: Symfony\Component\Security\Http\Authentication\AuthenticatorManager {#595 …}
}
 0.00 ms (none) 
Scheb\TwoFactorBundle\Security\Http\Firewall\TwoFactorAccessListener {#582
  -twoFactorFirewallConfig: Scheb\TwoFactorBundle\Security\TwoFactor\TwoFactorFirewallConfig {#842 …}
  -tokenStorage: Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage {#1018 …}
  -twoFactorAccessDecider: Scheb\TwoFactorBundle\Security\Authorization\TwoFactorAccessDecider {#581 …}
}
 0.03 ms (none) 
Symfony\Component\Security\Http\Firewall\AccessListener {#579
  -tokenStorage: Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage {#1018 …}
  -accessDecisionManager: Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager {#937 …}
  -map: Symfony\Component\Security\Http\AccessMap {#722 …}
}
 0.00 ms (none) 
Symfony\Component\Security\Http\Firewall\LogoutListener {#786
  -tokenStorage: Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage {#1018 …}
  -options: [
    "csrf_parameter" => "_csrf_token"
    "csrf_token_id" => "logout"
    "logout_path" => "app_logout"
  ]
  -httpUtils: Symfony\Component\Security\Http\HttpUtils {#841 …}
  -csrfTokenManager: Symfony\Component\Security\Csrf\CsrfTokenManager {#1015 …}
  -eventDispatcher: Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher {#747 …}
}
 0.00 ms (none)

Authenticators

No authenticators have been recorded. Check previous profiles on your authentication endpoint.

Access Decision

affirmative Strategy
# Voter class
1 
"Symfony\Component\Security\Core\Authorization\Voter\AuthenticatedVoter"
2 
"Scheb\TwoFactorBundle\Security\Authorization\Voter\TwoFactorInProgressVoter"
3 
"Symfony\Component\Security\Core\Authorization\Voter\RoleHierarchyVoter"
4 
"Symfony\Component\Security\Core\Authorization\Voter\ExpressionVoter"
5 
"App\Security\Voter\EntryCommentVoter"
6 
"App\Security\Voter\EntryVoter"
7 
"App\Security\Voter\MagazineVoter"
8 
"App\Security\Voter\MessageThreadVoter"
9 
"App\Security\Voter\MessageVoter"
10 
"App\Security\Voter\NotificationVoter"
11 
"App\Security\Voter\OAuth2UserConsentVoter"
12 
"App\Security\Voter\PostCommentVoter"
13 
"App\Security\Voter\PostVoter"
14 
"App\Security\Voter\UserVoter"

Access decision log

# Result Attributes Object
1 DENIED ROLE_USER 
null
 
"Scheb\TwoFactorBundle\Security\Authorization\Voter\TwoFactorInProgressVoter"
 ACCESS ABSTAIN 
"Symfony\Component\Security\Core\Authorization\Voter\RoleHierarchyVoter"
 ACCESS DENIED 
"App\Security\Voter\EntryCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MagazineVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageThreadVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\NotificationVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\OAuth2UserConsentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\UserVoter"
 ACCESS ABSTAIN
Show voter details
2 DENIED moderate 
App\Entity\Entry {#1796
  +user: Proxies\__CG__\App\Entity\User {#1896 …}
  +magazine: App\Entity\Magazine {#266
    +icon: null
    +name: "lemmy_support@lemmy.ml"
    +title: "lemmy_support"
    +description: """
      Support / questions about Lemmy.\n
      \n
      [Matrix Space: #lemmy-space](https://matrix.to/#/#lemmy-space:matrix.org)
      """
    +rules: null
    +subscriptionsCount: 1
    +entryCount: 130
    +entryCommentCount: 600
    +postCount: 2
    +postCommentCount: 14
    +isAdult: false
    +customCss: null
    +lastActive: DateTime @1728910137 {#276
      date: 2024-10-14 14:48:57.0 +02:00
    }
    +markedForDeletionAt: null
    +tags: null
    +moderators: Doctrine\ORM\PersistentCollection {#254 …}
    +ownershipRequests: Doctrine\ORM\PersistentCollection {#250 …}
    +moderatorRequests: Doctrine\ORM\PersistentCollection {#239 …}
    +entries: Doctrine\ORM\PersistentCollection {#197 …}
    +posts: Doctrine\ORM\PersistentCollection {#155 …}
    +subscriptions: Doctrine\ORM\PersistentCollection {#217 …}
    +bans: Doctrine\ORM\PersistentCollection {#134 …}
    +reports: Doctrine\ORM\PersistentCollection {#120 …}
    +badges: Doctrine\ORM\PersistentCollection {#98 …}
    +logs: Doctrine\ORM\PersistentCollection {#88 …}
    +awards: Doctrine\ORM\PersistentCollection {#77 …}
    +categories: Doctrine\ORM\PersistentCollection {#64 …}
    -id: 40
    +apId: "lemmy_support@lemmy.ml"
    +apProfileId: "https://lemmy.ml/c/lemmy_support"
    +apPublicUrl: "https://lemmy.ml/c/lemmy_support"
    +apFollowersUrl: "https://lemmy.ml/c/lemmy_support/followers"
    +apInboxUrl: "https://lemmy.ml/inbox"
    +apDomain: "lemmy.ml"
    +apPreferredUsername: "lemmy_support"
    +apDiscoverable: true
    +apManuallyApprovesFollowers: null
    +privateKey: null
    +publicKey: null
    +apFetchedAt: DateTime @1729581033 {#270
      date: 2024-10-22 09:10:33.0 +02:00
    }
    +apDeletedAt: null
    +apTimeoutAt: null
    +visibility: "visible             "
    +createdAt: DateTimeImmutable @1696687715 {#272
      date: 2023-10-07 16:08:35.0 +02:00
    }
  }
  +image: null
  +domain: Proxies\__CG__\App\Entity\Domain {#1888 …}
  +slug: "RFC-Add-custom-fields-to-local-site-and-local-user-tables"
  +title: "[RFC] Add custom fields to local_site and local_user tables"
  +url: null
  +body: """
    ### Proposal\n
    \n
    Add custom database columns to the `local_site` and `local_user` tables and corresponding config keys in the `editSite` and `saveUserSettings` interfaces. Data type would be `text` and the column name could be `user_custom` or something like that.\n
    \n
    ### Rationale\n
    \n
    Many 3rd party Lemmy UIs offer more config options than are covered by the discrete config keys currently exposed via `saveUserSettings` and in the `MyUserInfo` interface. A custom field where a JSON blob could be stored would allow 3rd party Lemmy UI clients to save site-level and user-level config options to the API similar to how Lemmy-UI has its settings saved.\n
    \n
    Currently, 3PAs largely (exclusively?) utilize local storage which limits any persistence to individual devices/browsers. Adding those `text` columns and exposing them via the `getSite`, `editSite` and `saveUserSettings` interfaces would allow 3rd party apps the ability to persist settings across devices by serializing them to JSON and storing/serving from the API.\n
    \n
    ### Use Cases\n
    \n
    - Application settings and preferences\n
    - Keyword filters\n
    - Favorite community lists\n
    - Community group lists\n
    - Structured site-level data such as rules, public community groups, report and moderation templates, etc.\n
    \n
    ### Possible Cons\n
    \n
    - Would slightly increase amount of data returned in the `getSite` API call due to the extra data in the `local_site` and `my_user` keys.\n
    - 3PA developers would have to share this field. \n
        - Not really a concern for the Lemmy devs, but there would ultimately need to be some cooperation between 3PA devs to avoid contention (e.g. a container with namespaces, etc).\n
    \n
    ### Workarounds Considered\n
    \n
    Adding a backend server to each 3rd party UI is possible but may be overkill for the relatively common and simple task of persisting settings. A custom field exposed by the Lemmy API would alleviate that. For use-cases more advanced than simple settings storage, the 3PA dev may opt to build their own backend anyway.\n
    \n
    In Tesseract, the current workaround is done by allowing export and import of user settings to a JSON file which can be loaded into a new device/browser. While that’s better than nothing, it’s far from ideal.\n
    \n
    Thoughts?\n
    \n
    **Update**: To test the viability of this RFC, I’ve horribly abused the `theme` field to store about 60 KB of JSON user settings data. Aside from breaking the CSS in Lemmy-UI (as expected), everything works great. The additional payload data in the `getSite` response doesn’t seem to be causing much of an impact. I may leave this in the next release under “advanced settings” with appropriate warnings as well as adding a “restore” button to restore it to a valid theme value. Ultimately, though, a dedicated field for 3PAs to use would be ideal.
    """
  +type: "article"
  +lang: "en"
  +isOc: false
  +hasEmbed: false
  +commentCount: 0
  +favouriteCount: 4
  +score: 0
  +isAdult: false
  +sticky: false
  +lastActive: DateTime @1699709635 {#1799
    date: 2023-11-11 14:33:55.0 +01:00
  }
  +ip: null
  +adaAmount: 0
  +tags: null
  +mentions: null
  +comments: Doctrine\ORM\PersistentCollection {#1887 …}
  +votes: Doctrine\ORM\PersistentCollection {#1950 …}
  +reports: Doctrine\ORM\PersistentCollection {#2425 …}
  +favourites: Doctrine\ORM\PersistentCollection {#1903 …}
  +notifications: Doctrine\ORM\PersistentCollection {#1898 …}
  +badges: Doctrine\ORM\PersistentCollection {#1904 …}
  +children: []
  -id: 11991
  -titleTs: "'add':2 'custom':3 'field':4 'local':6,9 'rfc':1 'site':7 'tabl':11 'user':10"
  -bodyTs: "'3pa':216,242,302 '3pas':110,443 '3rd':43,80,139,261 '60':369 'abil':143 'abus':362 'across':147 'ad':123,255,425 'add':2 'addit':391 'advanc':296,417 'allevi':289 'allow':79,138,320 'amount':194 'anyway':311 'api':98,158,201,287 'app':141 'applic':161 'appropri':420 'asid':376 'avoid':245 'backend':257,310 'better':342 'blob':74 'break':378 'build':307 'button':428 'call':202 'case':160,294 'caus':403 'client':84 'column':5,31,126 'common':273 'communiti':168,170,182 'con':190 'concern':227 'config':16,49,57,94 'consid':254 'contain':249 'content':246 'cooper':240 'correspond':15 'could':33,75 'cover':53 'css':380 'current':59,109,315 'custom':3,36,69,281 'data':24,177,196,207,375,393 'databas':4 'dedic':440 'dev':231,243,303 'develop':217 'devic':148 'device/browser':338 'devices/browsers':122 'discret':56 'doesn':398 'done':318 'due':203 'e.g':247 'editsit':20,133 'etc':188,252 'everyth':387 'exclus':112 'expect':386 'export':321 'expos':60,128,283 'extra':206 'far':347 'favorit':167 'field':70,223,282,365,441 'file':330 'filter':166 'getsit':132,200,396 'great':389 'group':171,183 'horribl':361 'ideal':349,448 'impact':407 'import':323 'increas':193 'individu':121 'interfac':23,67,136 'json':73,153,329,372 'kb':370 'key':17,58,215 'keyword':165 'larg':111 'leav':410 'lemmi':45,82,103,230,286,383 'lemmy-ui':102,382 'level':89,93,176 'like':39 'limit':117 'list':169,172 'load':334 'local':8,11,114,210 'mani':42 'may':267,304,409 'moder':186 'much':404 'myuserinfo':66 'name':32 'namespac':251 'need':236 'new':337 'next':414 'noth':344 'offer':47 'opt':305 'option':50,95 'overkil':269 'parti':44,81,140,262 'payload':392 'persist':119,145,278 'possibl':189,265 'prefer':164 'propos':1 'public':181 'rational':41 'realli':225 'relat':272 'releas':415 'report':184 'respons':397 'restor':427,430 'return':197 'rfc':358 'rule':180 'save':86,108 'saveuserset':22,62,135 'seem':400 'serial':150 'server':258 'set':107,146,162,279,299,326,374,418 'share':221 'similar':99 'simpl':275,298 'site':9,88,175,211 'site-level':87,174 'slight':192 'someth':38 'storag':115,300 'store':77,367 'storing/serving':155 'structur':173 'tabl':13 'task':276 'templat':187 'tesseract':313 'test':353 'text':28,125 'theme':364,435 'though':438 'thought':350 'type':25 'ui':46,83,104,263,384 'ultim':235,437 'updat':351 'use':159,293,445 'use-cas':292 'user':12,35,92,214,325,373 'user-level':91 'util':113 'valid':434 'valu':436 've':360 'via':61,130 'viabil':355 'warn':421 'well':423 'work':388 'workaround':253,316 'would':26,78,137,191,218,234,288,446"
  +cross: false
  +upVotes: 0
  +downVotes: 0
  +ranking: 1699718635
  +visibility: "visible             "
  +apId: "https://dubvee.org/post/370736"
  +editedAt: DateTimeImmutable @1699874770 {#59
    date: 2023-11-13 12:26:10.0 +01:00
  }
  +createdAt: DateTimeImmutable @1699709635 {#1831
    date: 2023-11-11 14:33:55.0 +01:00
  }
}
 
"Scheb\TwoFactorBundle\Security\Authorization\Voter\TwoFactorInProgressVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryVoter"
 ACCESS DENIED 
"App\Security\Voter\MagazineVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageThreadVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\NotificationVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\OAuth2UserConsentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\UserVoter"
 ACCESS ABSTAIN
Show voter details
3 DENIED edit 
App\Entity\Entry {#1796
  +user: Proxies\__CG__\App\Entity\User {#1896 …}
  +magazine: App\Entity\Magazine {#266
    +icon: null
    +name: "lemmy_support@lemmy.ml"
    +title: "lemmy_support"
    +description: """
      Support / questions about Lemmy.\n
      \n
      [Matrix Space: #lemmy-space](https://matrix.to/#/#lemmy-space:matrix.org)
      """
    +rules: null
    +subscriptionsCount: 1
    +entryCount: 130
    +entryCommentCount: 600
    +postCount: 2
    +postCommentCount: 14
    +isAdult: false
    +customCss: null
    +lastActive: DateTime @1728910137 {#276
      date: 2024-10-14 14:48:57.0 +02:00
    }
    +markedForDeletionAt: null
    +tags: null
    +moderators: Doctrine\ORM\PersistentCollection {#254 …}
    +ownershipRequests: Doctrine\ORM\PersistentCollection {#250 …}
    +moderatorRequests: Doctrine\ORM\PersistentCollection {#239 …}
    +entries: Doctrine\ORM\PersistentCollection {#197 …}
    +posts: Doctrine\ORM\PersistentCollection {#155 …}
    +subscriptions: Doctrine\ORM\PersistentCollection {#217 …}
    +bans: Doctrine\ORM\PersistentCollection {#134 …}
    +reports: Doctrine\ORM\PersistentCollection {#120 …}
    +badges: Doctrine\ORM\PersistentCollection {#98 …}
    +logs: Doctrine\ORM\PersistentCollection {#88 …}
    +awards: Doctrine\ORM\PersistentCollection {#77 …}
    +categories: Doctrine\ORM\PersistentCollection {#64 …}
    -id: 40
    +apId: "lemmy_support@lemmy.ml"
    +apProfileId: "https://lemmy.ml/c/lemmy_support"
    +apPublicUrl: "https://lemmy.ml/c/lemmy_support"
    +apFollowersUrl: "https://lemmy.ml/c/lemmy_support/followers"
    +apInboxUrl: "https://lemmy.ml/inbox"
    +apDomain: "lemmy.ml"
    +apPreferredUsername: "lemmy_support"
    +apDiscoverable: true
    +apManuallyApprovesFollowers: null
    +privateKey: null
    +publicKey: null
    +apFetchedAt: DateTime @1729581033 {#270
      date: 2024-10-22 09:10:33.0 +02:00
    }
    +apDeletedAt: null
    +apTimeoutAt: null
    +visibility: "visible             "
    +createdAt: DateTimeImmutable @1696687715 {#272
      date: 2023-10-07 16:08:35.0 +02:00
    }
  }
  +image: null
  +domain: Proxies\__CG__\App\Entity\Domain {#1888 …}
  +slug: "RFC-Add-custom-fields-to-local-site-and-local-user-tables"
  +title: "[RFC] Add custom fields to local_site and local_user tables"
  +url: null
  +body: """
    ### Proposal\n
    \n
    Add custom database columns to the `local_site` and `local_user` tables and corresponding config keys in the `editSite` and `saveUserSettings` interfaces. Data type would be `text` and the column name could be `user_custom` or something like that.\n
    \n
    ### Rationale\n
    \n
    Many 3rd party Lemmy UIs offer more config options than are covered by the discrete config keys currently exposed via `saveUserSettings` and in the `MyUserInfo` interface. A custom field where a JSON blob could be stored would allow 3rd party Lemmy UI clients to save site-level and user-level config options to the API similar to how Lemmy-UI has its settings saved.\n
    \n
    Currently, 3PAs largely (exclusively?) utilize local storage which limits any persistence to individual devices/browsers. Adding those `text` columns and exposing them via the `getSite`, `editSite` and `saveUserSettings` interfaces would allow 3rd party apps the ability to persist settings across devices by serializing them to JSON and storing/serving from the API.\n
    \n
    ### Use Cases\n
    \n
    - Application settings and preferences\n
    - Keyword filters\n
    - Favorite community lists\n
    - Community group lists\n
    - Structured site-level data such as rules, public community groups, report and moderation templates, etc.\n
    \n
    ### Possible Cons\n
    \n
    - Would slightly increase amount of data returned in the `getSite` API call due to the extra data in the `local_site` and `my_user` keys.\n
    - 3PA developers would have to share this field. \n
        - Not really a concern for the Lemmy devs, but there would ultimately need to be some cooperation between 3PA devs to avoid contention (e.g. a container with namespaces, etc).\n
    \n
    ### Workarounds Considered\n
    \n
    Adding a backend server to each 3rd party UI is possible but may be overkill for the relatively common and simple task of persisting settings. A custom field exposed by the Lemmy API would alleviate that. For use-cases more advanced than simple settings storage, the 3PA dev may opt to build their own backend anyway.\n
    \n
    In Tesseract, the current workaround is done by allowing export and import of user settings to a JSON file which can be loaded into a new device/browser. While that’s better than nothing, it’s far from ideal.\n
    \n
    Thoughts?\n
    \n
    **Update**: To test the viability of this RFC, I’ve horribly abused the `theme` field to store about 60 KB of JSON user settings data. Aside from breaking the CSS in Lemmy-UI (as expected), everything works great. The additional payload data in the `getSite` response doesn’t seem to be causing much of an impact. I may leave this in the next release under “advanced settings” with appropriate warnings as well as adding a “restore” button to restore it to a valid theme value. Ultimately, though, a dedicated field for 3PAs to use would be ideal.
    """
  +type: "article"
  +lang: "en"
  +isOc: false
  +hasEmbed: false
  +commentCount: 0
  +favouriteCount: 4
  +score: 0
  +isAdult: false
  +sticky: false
  +lastActive: DateTime @1699709635 {#1799
    date: 2023-11-11 14:33:55.0 +01:00
  }
  +ip: null
  +adaAmount: 0
  +tags: null
  +mentions: null
  +comments: Doctrine\ORM\PersistentCollection {#1887 …}
  +votes: Doctrine\ORM\PersistentCollection {#1950 …}
  +reports: Doctrine\ORM\PersistentCollection {#2425 …}
  +favourites: Doctrine\ORM\PersistentCollection {#1903 …}
  +notifications: Doctrine\ORM\PersistentCollection {#1898 …}
  +badges: Doctrine\ORM\PersistentCollection {#1904 …}
  +children: []
  -id: 11991
  -titleTs: "'add':2 'custom':3 'field':4 'local':6,9 'rfc':1 'site':7 'tabl':11 'user':10"
  -bodyTs: "'3pa':216,242,302 '3pas':110,443 '3rd':43,80,139,261 '60':369 'abil':143 'abus':362 'across':147 'ad':123,255,425 'add':2 'addit':391 'advanc':296,417 'allevi':289 'allow':79,138,320 'amount':194 'anyway':311 'api':98,158,201,287 'app':141 'applic':161 'appropri':420 'asid':376 'avoid':245 'backend':257,310 'better':342 'blob':74 'break':378 'build':307 'button':428 'call':202 'case':160,294 'caus':403 'client':84 'column':5,31,126 'common':273 'communiti':168,170,182 'con':190 'concern':227 'config':16,49,57,94 'consid':254 'contain':249 'content':246 'cooper':240 'correspond':15 'could':33,75 'cover':53 'css':380 'current':59,109,315 'custom':3,36,69,281 'data':24,177,196,207,375,393 'databas':4 'dedic':440 'dev':231,243,303 'develop':217 'devic':148 'device/browser':338 'devices/browsers':122 'discret':56 'doesn':398 'done':318 'due':203 'e.g':247 'editsit':20,133 'etc':188,252 'everyth':387 'exclus':112 'expect':386 'export':321 'expos':60,128,283 'extra':206 'far':347 'favorit':167 'field':70,223,282,365,441 'file':330 'filter':166 'getsit':132,200,396 'great':389 'group':171,183 'horribl':361 'ideal':349,448 'impact':407 'import':323 'increas':193 'individu':121 'interfac':23,67,136 'json':73,153,329,372 'kb':370 'key':17,58,215 'keyword':165 'larg':111 'leav':410 'lemmi':45,82,103,230,286,383 'lemmy-ui':102,382 'level':89,93,176 'like':39 'limit':117 'list':169,172 'load':334 'local':8,11,114,210 'mani':42 'may':267,304,409 'moder':186 'much':404 'myuserinfo':66 'name':32 'namespac':251 'need':236 'new':337 'next':414 'noth':344 'offer':47 'opt':305 'option':50,95 'overkil':269 'parti':44,81,140,262 'payload':392 'persist':119,145,278 'possibl':189,265 'prefer':164 'propos':1 'public':181 'rational':41 'realli':225 'relat':272 'releas':415 'report':184 'respons':397 'restor':427,430 'return':197 'rfc':358 'rule':180 'save':86,108 'saveuserset':22,62,135 'seem':400 'serial':150 'server':258 'set':107,146,162,279,299,326,374,418 'share':221 'similar':99 'simpl':275,298 'site':9,88,175,211 'site-level':87,174 'slight':192 'someth':38 'storag':115,300 'store':77,367 'storing/serving':155 'structur':173 'tabl':13 'task':276 'templat':187 'tesseract':313 'test':353 'text':28,125 'theme':364,435 'though':438 'thought':350 'type':25 'ui':46,83,104,263,384 'ultim':235,437 'updat':351 'use':159,293,445 'use-cas':292 'user':12,35,92,214,325,373 'user-level':91 'util':113 'valid':434 'valu':436 've':360 'via':61,130 'viabil':355 'warn':421 'well':423 'work':388 'workaround':253,316 'would':26,78,137,191,218,234,288,446"
  +cross: false
  +upVotes: 0
  +downVotes: 0
  +ranking: 1699718635
  +visibility: "visible             "
  +apId: "https://dubvee.org/post/370736"
  +editedAt: DateTimeImmutable @1699874770 {#59
    date: 2023-11-13 12:26:10.0 +01:00
  }
  +createdAt: DateTimeImmutable @1699709635 {#1831
    date: 2023-11-11 14:33:55.0 +01:00
  }
}
 
"Scheb\TwoFactorBundle\Security\Authorization\Voter\TwoFactorInProgressVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryVoter"
 ACCESS DENIED 
"App\Security\Voter\MagazineVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageThreadVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\NotificationVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\OAuth2UserConsentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\UserVoter"
 ACCESS ABSTAIN
Show voter details
4 DENIED moderate 
App\Entity\Entry {#1796
  +user: Proxies\__CG__\App\Entity\User {#1896 …}
  +magazine: App\Entity\Magazine {#266
    +icon: null
    +name: "lemmy_support@lemmy.ml"
    +title: "lemmy_support"
    +description: """
      Support / questions about Lemmy.\n
      \n
      [Matrix Space: #lemmy-space](https://matrix.to/#/#lemmy-space:matrix.org)
      """
    +rules: null
    +subscriptionsCount: 1
    +entryCount: 130
    +entryCommentCount: 600
    +postCount: 2
    +postCommentCount: 14
    +isAdult: false
    +customCss: null
    +lastActive: DateTime @1728910137 {#276
      date: 2024-10-14 14:48:57.0 +02:00
    }
    +markedForDeletionAt: null
    +tags: null
    +moderators: Doctrine\ORM\PersistentCollection {#254 …}
    +ownershipRequests: Doctrine\ORM\PersistentCollection {#250 …}
    +moderatorRequests: Doctrine\ORM\PersistentCollection {#239 …}
    +entries: Doctrine\ORM\PersistentCollection {#197 …}
    +posts: Doctrine\ORM\PersistentCollection {#155 …}
    +subscriptions: Doctrine\ORM\PersistentCollection {#217 …}
    +bans: Doctrine\ORM\PersistentCollection {#134 …}
    +reports: Doctrine\ORM\PersistentCollection {#120 …}
    +badges: Doctrine\ORM\PersistentCollection {#98 …}
    +logs: Doctrine\ORM\PersistentCollection {#88 …}
    +awards: Doctrine\ORM\PersistentCollection {#77 …}
    +categories: Doctrine\ORM\PersistentCollection {#64 …}
    -id: 40
    +apId: "lemmy_support@lemmy.ml"
    +apProfileId: "https://lemmy.ml/c/lemmy_support"
    +apPublicUrl: "https://lemmy.ml/c/lemmy_support"
    +apFollowersUrl: "https://lemmy.ml/c/lemmy_support/followers"
    +apInboxUrl: "https://lemmy.ml/inbox"
    +apDomain: "lemmy.ml"
    +apPreferredUsername: "lemmy_support"
    +apDiscoverable: true
    +apManuallyApprovesFollowers: null
    +privateKey: null
    +publicKey: null
    +apFetchedAt: DateTime @1729581033 {#270
      date: 2024-10-22 09:10:33.0 +02:00
    }
    +apDeletedAt: null
    +apTimeoutAt: null
    +visibility: "visible             "
    +createdAt: DateTimeImmutable @1696687715 {#272
      date: 2023-10-07 16:08:35.0 +02:00
    }
  }
  +image: null
  +domain: Proxies\__CG__\App\Entity\Domain {#1888 …}
  +slug: "RFC-Add-custom-fields-to-local-site-and-local-user-tables"
  +title: "[RFC] Add custom fields to local_site and local_user tables"
  +url: null
  +body: """
    ### Proposal\n
    \n
    Add custom database columns to the `local_site` and `local_user` tables and corresponding config keys in the `editSite` and `saveUserSettings` interfaces. Data type would be `text` and the column name could be `user_custom` or something like that.\n
    \n
    ### Rationale\n
    \n
    Many 3rd party Lemmy UIs offer more config options than are covered by the discrete config keys currently exposed via `saveUserSettings` and in the `MyUserInfo` interface. A custom field where a JSON blob could be stored would allow 3rd party Lemmy UI clients to save site-level and user-level config options to the API similar to how Lemmy-UI has its settings saved.\n
    \n
    Currently, 3PAs largely (exclusively?) utilize local storage which limits any persistence to individual devices/browsers. Adding those `text` columns and exposing them via the `getSite`, `editSite` and `saveUserSettings` interfaces would allow 3rd party apps the ability to persist settings across devices by serializing them to JSON and storing/serving from the API.\n
    \n
    ### Use Cases\n
    \n
    - Application settings and preferences\n
    - Keyword filters\n
    - Favorite community lists\n
    - Community group lists\n
    - Structured site-level data such as rules, public community groups, report and moderation templates, etc.\n
    \n
    ### Possible Cons\n
    \n
    - Would slightly increase amount of data returned in the `getSite` API call due to the extra data in the `local_site` and `my_user` keys.\n
    - 3PA developers would have to share this field. \n
        - Not really a concern for the Lemmy devs, but there would ultimately need to be some cooperation between 3PA devs to avoid contention (e.g. a container with namespaces, etc).\n
    \n
    ### Workarounds Considered\n
    \n
    Adding a backend server to each 3rd party UI is possible but may be overkill for the relatively common and simple task of persisting settings. A custom field exposed by the Lemmy API would alleviate that. For use-cases more advanced than simple settings storage, the 3PA dev may opt to build their own backend anyway.\n
    \n
    In Tesseract, the current workaround is done by allowing export and import of user settings to a JSON file which can be loaded into a new device/browser. While that’s better than nothing, it’s far from ideal.\n
    \n
    Thoughts?\n
    \n
    **Update**: To test the viability of this RFC, I’ve horribly abused the `theme` field to store about 60 KB of JSON user settings data. Aside from breaking the CSS in Lemmy-UI (as expected), everything works great. The additional payload data in the `getSite` response doesn’t seem to be causing much of an impact. I may leave this in the next release under “advanced settings” with appropriate warnings as well as adding a “restore” button to restore it to a valid theme value. Ultimately, though, a dedicated field for 3PAs to use would be ideal.
    """
  +type: "article"
  +lang: "en"
  +isOc: false
  +hasEmbed: false
  +commentCount: 0
  +favouriteCount: 4
  +score: 0
  +isAdult: false
  +sticky: false
  +lastActive: DateTime @1699709635 {#1799
    date: 2023-11-11 14:33:55.0 +01:00
  }
  +ip: null
  +adaAmount: 0
  +tags: null
  +mentions: null
  +comments: Doctrine\ORM\PersistentCollection {#1887 …}
  +votes: Doctrine\ORM\PersistentCollection {#1950 …}
  +reports: Doctrine\ORM\PersistentCollection {#2425 …}
  +favourites: Doctrine\ORM\PersistentCollection {#1903 …}
  +notifications: Doctrine\ORM\PersistentCollection {#1898 …}
  +badges: Doctrine\ORM\PersistentCollection {#1904 …}
  +children: []
  -id: 11991
  -titleTs: "'add':2 'custom':3 'field':4 'local':6,9 'rfc':1 'site':7 'tabl':11 'user':10"
  -bodyTs: "'3pa':216,242,302 '3pas':110,443 '3rd':43,80,139,261 '60':369 'abil':143 'abus':362 'across':147 'ad':123,255,425 'add':2 'addit':391 'advanc':296,417 'allevi':289 'allow':79,138,320 'amount':194 'anyway':311 'api':98,158,201,287 'app':141 'applic':161 'appropri':420 'asid':376 'avoid':245 'backend':257,310 'better':342 'blob':74 'break':378 'build':307 'button':428 'call':202 'case':160,294 'caus':403 'client':84 'column':5,31,126 'common':273 'communiti':168,170,182 'con':190 'concern':227 'config':16,49,57,94 'consid':254 'contain':249 'content':246 'cooper':240 'correspond':15 'could':33,75 'cover':53 'css':380 'current':59,109,315 'custom':3,36,69,281 'data':24,177,196,207,375,393 'databas':4 'dedic':440 'dev':231,243,303 'develop':217 'devic':148 'device/browser':338 'devices/browsers':122 'discret':56 'doesn':398 'done':318 'due':203 'e.g':247 'editsit':20,133 'etc':188,252 'everyth':387 'exclus':112 'expect':386 'export':321 'expos':60,128,283 'extra':206 'far':347 'favorit':167 'field':70,223,282,365,441 'file':330 'filter':166 'getsit':132,200,396 'great':389 'group':171,183 'horribl':361 'ideal':349,448 'impact':407 'import':323 'increas':193 'individu':121 'interfac':23,67,136 'json':73,153,329,372 'kb':370 'key':17,58,215 'keyword':165 'larg':111 'leav':410 'lemmi':45,82,103,230,286,383 'lemmy-ui':102,382 'level':89,93,176 'like':39 'limit':117 'list':169,172 'load':334 'local':8,11,114,210 'mani':42 'may':267,304,409 'moder':186 'much':404 'myuserinfo':66 'name':32 'namespac':251 'need':236 'new':337 'next':414 'noth':344 'offer':47 'opt':305 'option':50,95 'overkil':269 'parti':44,81,140,262 'payload':392 'persist':119,145,278 'possibl':189,265 'prefer':164 'propos':1 'public':181 'rational':41 'realli':225 'relat':272 'releas':415 'report':184 'respons':397 'restor':427,430 'return':197 'rfc':358 'rule':180 'save':86,108 'saveuserset':22,62,135 'seem':400 'serial':150 'server':258 'set':107,146,162,279,299,326,374,418 'share':221 'similar':99 'simpl':275,298 'site':9,88,175,211 'site-level':87,174 'slight':192 'someth':38 'storag':115,300 'store':77,367 'storing/serving':155 'structur':173 'tabl':13 'task':276 'templat':187 'tesseract':313 'test':353 'text':28,125 'theme':364,435 'though':438 'thought':350 'type':25 'ui':46,83,104,263,384 'ultim':235,437 'updat':351 'use':159,293,445 'use-cas':292 'user':12,35,92,214,325,373 'user-level':91 'util':113 'valid':434 'valu':436 've':360 'via':61,130 'viabil':355 'warn':421 'well':423 'work':388 'workaround':253,316 'would':26,78,137,191,218,234,288,446"
  +cross: false
  +upVotes: 0
  +downVotes: 0
  +ranking: 1699718635
  +visibility: "visible             "
  +apId: "https://dubvee.org/post/370736"
  +editedAt: DateTimeImmutable @1699874770 {#59
    date: 2023-11-13 12:26:10.0 +01:00
  }
  +createdAt: DateTimeImmutable @1699709635 {#1831
    date: 2023-11-11 14:33:55.0 +01:00
  }
}
 
"Scheb\TwoFactorBundle\Security\Authorization\Voter\TwoFactorInProgressVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryVoter"
 ACCESS DENIED 
"App\Security\Voter\MagazineVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageThreadVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\NotificationVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\OAuth2UserConsentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\UserVoter"
 ACCESS ABSTAIN
Show voter details
5 DENIED edit 
App\Entity\Magazine {#266
  +icon: null
  +name: "lemmy_support@lemmy.ml"
  +title: "lemmy_support"
  +description: """
    Support / questions about Lemmy.\n
    \n
    [Matrix Space: #lemmy-space](https://matrix.to/#/#lemmy-space:matrix.org)
    """
  +rules: null
  +subscriptionsCount: 1
  +entryCount: 130
  +entryCommentCount: 600
  +postCount: 2
  +postCommentCount: 14
  +isAdult: false
  +customCss: null
  +lastActive: DateTime @1728910137 {#276
    date: 2024-10-14 14:48:57.0 +02:00
  }
  +markedForDeletionAt: null
  +tags: null
  +moderators: Doctrine\ORM\PersistentCollection {#254 …}
  +ownershipRequests: Doctrine\ORM\PersistentCollection {#250 …}
  +moderatorRequests: Doctrine\ORM\PersistentCollection {#239 …}
  +entries: Doctrine\ORM\PersistentCollection {#197 …}
  +posts: Doctrine\ORM\PersistentCollection {#155 …}
  +subscriptions: Doctrine\ORM\PersistentCollection {#217 …}
  +bans: Doctrine\ORM\PersistentCollection {#134 …}
  +reports: Doctrine\ORM\PersistentCollection {#120 …}
  +badges: Doctrine\ORM\PersistentCollection {#98 …}
  +logs: Doctrine\ORM\PersistentCollection {#88 …}
  +awards: Doctrine\ORM\PersistentCollection {#77 …}
  +categories: Doctrine\ORM\PersistentCollection {#64 …}
  -id: 40
  +apId: "lemmy_support@lemmy.ml"
  +apProfileId: "https://lemmy.ml/c/lemmy_support"
  +apPublicUrl: "https://lemmy.ml/c/lemmy_support"
  +apFollowersUrl: "https://lemmy.ml/c/lemmy_support/followers"
  +apInboxUrl: "https://lemmy.ml/inbox"
  +apDomain: "lemmy.ml"
  +apPreferredUsername: "lemmy_support"
  +apDiscoverable: true
  +apManuallyApprovesFollowers: null
  +privateKey: null
  +publicKey: null
  +apFetchedAt: DateTime @1729581033 {#270
    date: 2024-10-22 09:10:33.0 +02:00
  }
  +apDeletedAt: null
  +apTimeoutAt: null
  +visibility: "visible             "
  +createdAt: DateTimeImmutable @1696687715 {#272
    date: 2023-10-07 16:08:35.0 +02:00
  }
}
 
"Scheb\TwoFactorBundle\Security\Authorization\Voter\TwoFactorInProgressVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\EntryVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MagazineVoter"
 ACCESS DENIED 
"App\Security\Voter\MessageThreadVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\MessageVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\NotificationVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\OAuth2UserConsentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostCommentVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\PostVoter"
 ACCESS ABSTAIN 
"App\Security\Voter\UserVoter"
 ACCESS ABSTAIN
Show voter details