I have it and haven't used it for a long time. With sqlite I'm mostly a terminal guy.
To clean up a sqlite3 database: open with sqlite3 and type "vacuum;[return]" On Tuesday, October 25, 2022 at 4:10:00 PM UTC+2 [email protected] wrote: > 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/783cfe1c-69dc-4dbd-9738-80ecb203a237n%40googlegroups.com.
