I've just found a GUI sqlite browser that looks very decent: DB Browser for SQLite <https://sqlitebrowser.org>. It may not be very useful for Leo's sqlite data since it's all stored as blobs, but it's probably worth checking out if you use sqlite.
On Tuesday, October 25, 2022 at 9:47:05 AM UTC-4 Thomas Passin wrote: > More than likely it was deleting the "db" directory inside ".leo" that did > the job. I recently had an infuriating period where I was working with > LeoPyRef a lot. Each time I saved the outline, after the save succeeded > Leo would block for 5 to 10 seconds, or even more. Nothing I thought of > did any good. Finally I deleted the "db" directory and now Leo no longer > blocks after saving LeoPyRef. > > I have no idea how Leo uses its sqlite database, but I notice that in the > old version - I "deleted" it by renaming it to "dbx" so it's not truly gone > - the file *g_app_db/cache.sqlite* has a size of 120 kb. The same file > in the new "db" directory is only 12 kb. The other cache.sqlite file in > both old and new "db" directories are only 12 kb in size. This makes me > wonder if Leo sometimes makes a query that takes a very long time to > execute if the database has been used a lot. Maybe there needs to be an > index on some of the fields (if sqlite supports indexes; I've never used it > and don't know any details about it). An index can make a dramatic > difference for queries that need to scan the entire database over and over. > > Or maybe that database file needs to be defraged/compacted from time to > time. The Thunderbird email client has a command to compact its database, > and running it can reduce the database size quite a lot. > > On Sunday, October 23, 2022 at 5:18:26 PM UTC-4 Thomas Passin wrote: > >> Wow, that's a lot of strangeness cleared up by deleting the .leo >> directory! Well done! >> >> On Sunday, October 23, 2022 at 2:27:00 PM UTC-4 [email protected] >> wrote: >> >>> On Sunday, October 23, 2022 at 2:37:15 PM UTC+2 Karsten Wolf wrote: >>> >>>> Again all this applies to Leo 6.7.0 on macos 10.13.6 >>>> >>>> The annoyances just for today; trying to do some work. >>>> >>>> >>>> *indent inserts TABs *Even if there is no TAB character in the file, >>>> using TAB to indent a selection inserts TAB characters. This goes to the >>>> point that Leo refuses to save the file because of mixed TABs and SPACEs >>>> >>> >>> Gone with killing the .leo directory >>> >>> >>> >>>> >>>> >>>> *indent need a selection*I have to select a single line to indent it? >>>> Usually I position the cursor at the beginning of a line and press tab. >>>> >>> >>> Gone with killing the .leo directory >>> >>> >>>> >>>> >>>> *find always switches "search Headline" back on*I need this in about >>>> 5% of my searches. Press command-F and it's back on. >>>> >>>> >>>> *find does not honor the "Suboutline only" flag*searches go beyond the >>>> selected node at start. >>>> >>> >>> Gone with killing the .leo directory >>> >>> >>>> >>>> *find does not always select the found string* >>>> Doing repeatedly find-next the found string is not always selected; >>>> sometimes selected, sometimes blinking cursor. >>>> >>> >>> Gone with killing the .leo directory >>> >>> Now I need my mac keyboard shortcuts working. >>> >>> >>> >> -- You received this message because you are subscribed to the Google Groups "leo-editor" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/leo-editor/3a9a2118-d90b-4b92-b2fc-61de03d2b963n%40googlegroups.com.
