Remote SQLite integration

thanhnguyen2187 / crypta

An offline-first code snippet manager

https://thanhnguyen2187.github.io/crypta/

MIT License

7 stars 0 forks source link

Remote SQLite integration #38

Open thanhnguyen2187 opened 9 months ago

thanhnguyen2187 commented 9 months ago

Should resolve the remaining part of #26.

thanhnguyen2187 commented 9 months ago

To do items:

[x] Implement UI for remote server settings
[x] Implement UI for conflicted snippet
[x] Implement UI for snippet synchronization state
[x] Integrate sqliterg and Drizzle
[x] Implement remote snippets store
[x] Implement remote store and local store combination
[x] Integrate combined store and UI
[x] Implement UI for merging

thanhnguyen2187 commented 9 months ago

I pondered a bit on how should I indicate the current status, and then came up with the "Log Viewer". However, the logging aspect also troubled me: I also wanted it to handle "more general" logs, but then I'll also have to handle "log rotation". In the end, I decided to limit the scope to "server settings change" only, and also let the displayed logs be in-memory.

thanhnguyen2187 commented 9 months ago

Another note: the input settings should be "persistent" (exists after reloading). Previously, we are handling that with OPFS (other application states like opened folder are within OPFS as well). One down side of OPFS: the developer tooling is not great! Maybe we should consider moving to IndexedDB or Local Storage.

thanhnguyen2187 commented 8 months ago

~~Some "final" things to do before releasing:~~

[ ] ~~Write documentation~~
[ ] ~~Improve configuration file (one for testing; one for deploying)~~
[ ] ~~Clean up redundant logging~~

After really considering it for a while, I decided to replace sqliterg/ws4sqlite with Turso to further simplifying the deployment experience.