sync

[heywinit]

we're dealing with somewhat (maybe an overstatement) t3chat levels of sync, if not right now, maybe letter, but for sure.

• the app is supposed to be offline first so we'll heavily use indexeddb for local storage
• the app is supposed to be collaborative so we'll be using supabase realtime along with a postgres database

we need to figure out how the both get synced.

i'm borrowing a lot of ideas from theo's video about the sync solution in t3chat. @byedeep get up to date with this too.

i'm heavily inclined towards using legendstate with the indexeddb for the frontend and then a custom sync solution for realtime sync.

[heywinit]

after watching the vid, these are the viable options i can think of

• dexie
• tinybase
• electricsql - what i love the most right now

so i'm gonna dig deeper and update here

also, maybe im spending too much time thinking. if i feel like it, which i will i know for sure, i will just impulsively start designing the db schema in postgres along with electricsql

[heywinit]

deep's afk for a while so it doesn't help but we at it

[heywinit]

im just talking to myself wow

[heywinit]

there goes another hour of my life