disk I/O error about ekg HOT 4 CLOSED

We don't have the kind of search you are thinking of, although it'd be a good idea to add. What we do have is, llm-embedding, where you can do a semantic search after you hook up your notes to a provider of embeddings (Open AI, etc).

from ekg.

I get the same error when running
emacs -Q -l /home/admin/nixos/deps/emacs/sql-test.el
where the contents of that file is:

(let ((con (sqlite-open "/home/admin/nixos/deps/emacs/triples.db")))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))
    (sqlite-execute con "REPLACE INTO triples VALUES (?, ?, ?, ?)" '("text/mode" "base/unique" "t" "()"))))

Probably it's a bug relating to emac's implementation of sqlite.

from ekg.

Thanks for the investigation! You should probably open an emacs bug (M-x report-emacs-bug) with a small test-case that you can verify in a plain emacs (emacs -Q).

For using ekg if sqlite-execute doesn't work, you can try using emacsql. Install the emacs package separately, and then (setq triples-sqlite-interface 'emacsql). This should work for you, let me know if you have issues.

from ekg.

Yes although my issue probably doesn't happen on anyone else's machine because it affects all complex or rapid calls to sqlite. I think this is related to my system configuration. I will try to test this issue on my other machines to see which parts of my configuration might be causing the issue.

Thanks so much for the tip! When using emacsql it works fine, although I'm getting an error after saving changes to an imported org-roam note. I will look into it more later.

I'm wondering, is there a simple way to interactively search across all note contents with a live preview of results? Like grep with consult? I didn't find any functions for that, and it was useful in org-roam when quickly searching for some note I remembered a part of that wasn't the tag.

Thanks so much for this package and the help!

from ekg.