search

11cafe / Internal_Roadmap

1 stars 0 forks source link

migrate diskdb to sqlite #12

Open Weixuanf opened 6 months ago

Weixuanf commented 6 months ago

some users are complaining losing data after switching browser. we should substitute diskdb with sqlite.

Step1: find all this.saveDiskDB(); callsites, change it to a CRUD method of sqlite

Step2: once sqlite data is stabled, we can read from sqlite, and move away from indexdb

arslan2012 commented 6 months ago

Since sqlite is a SQL database, can you provide me with all the tables' schema? or I could set everythings type as string?

Weixuanf commented 6 months ago

你通过dbtypes里的type建一下schema？我也没有现成的schema😂

From: Arslan Ablikim @.> Sent: Sunday, March 17, 2024 9:25:23 AM To: 11cafe/Internal_Roadmap @.> Cc: Weixuan Fu @.>; Author @.> Subject: Re: [11cafe/Internal_Roadmap] migrate diskdb to sqlite (Issue #12)

Since sqlite is a SQL database, can you provide me with all the tables' schema? or I could set everythings type as string?

— Reply to this email directly, view it on GitHubhttps://github.com/11cafe/Internal_Roadmap/issues/12#issuecomment-2002237043, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEMEEOLFI3DEDS3HKPAOIK3YYTWIHAVCNFSM6AAAAABEPDT5ISVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMBSGIZTOMBUGM. You are receiving this because you authored the thread.Message ID: @.***>