If you're looking for something like Appwrite or Supabase but with a more end-to-end typesafety approach + optimistic updates, check out Thin Backend https://thin.dev/ (https://github.com/digitallyinduced/thin-backend) It takes a bit more of a higher level approach to database operations than appwrite, supabase or firebase, which allows us to do things like optimistic updates that are hard to do in other tools.
This is your app? I feel like plugging your own competitor app in a ShowHN goes against the spirit of ShowHN. Rather than just a link to your GitHub, a deeper discussion about the difference and pros and cons of one versus the other would be more appropriate here. For example, what about Appwrite makes it hard to do optimistic updates versus your solution? "High level approach" doesn't tell me much.
Yeah, initially we didn't have this. During beta our main servers were in europe, and while I was in SF I saw what a difference this made to the overall UX of our kind of realtime apps. Everything took like 200ms more :) With the optimistic updates it's now fast everywhere on the world.
To see some code examples, here's a small example project done with thin-backend: https://github.com/digitallyinduced/thin-backend-todo-app/bl... It's running on Vercel here: https://thin-backend-todo-app.vercel.app/