@devagrawal09@wshxnv@powersync_ ah my bad then :D by usecase i thought you meant a single feature or single thing
in anycase it would be beneficial if you have somewhere a single page with architecture/features comparison between powersync and others in the same space
@devagrawal09@wshxnv@powersync_ im not debating how good of a technology a sync engine is, im merely demonstrated that its not a silver bullet as i felt you've implied in this thread
yep that's my point, you asked for a usecase that's not a static website and i just highlighted it. obviously you can opt in / out . And by many clients see different things i meant each client sees their local optimistic change before the 'winning' write is decided and synced back.
this totally proves my point,
there exists an optimistic window where many clients see different things. in a workload that requires lineaizability this shouls never be allowed
In other words, to achieve it you must give up one of the main if not the main selling point of sync engines
@devagrawal09@wshxnv@powersync_ For abac, i didn't say it doesn't work just that its a poor solution for any non-trivial case
For linearizable workloads, can you shed some light on how to achieve them without defeating the whole purpose of a sync engine?
@devagrawal09@wshxnv you're making it sound a bit like a one size fits all solution but imho it clearly shines in specific use cases and is a subpar solution for other ones, just like any other technology its no different here
@SheriefFYI@bullno1 on the other hand, if you're looking for a full identity management self hosted setup where you own user management / database, policies, roles..etc Authelia or Keycloak would make more sense.
@SheriefFYI@bullno1 yes you're correct you still need an identity provider, In this case the identity provider is directly Google/Github..etc (the SSO logins you want to support). you point it to their OAuth endpoints, and they handle all the identity management.
@SheriefFYI@bullno1 no you don't, you can use a file authentication backend,
depending on your setup and if you only care about sso and not full identity management, i recommend checking out oauth2-proxy, which is much nore trivial to setup https://t.co/yqkkhbbcmL