Closed walseb closed 3 months ago
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.
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.
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!
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).
Hello!
After I install this library on my Nixos laptop and run ekg-capture, I get an IO error.
Upon investigation, the error is with the
ekg-add-schema
function. When I run it, emacs gives with the following error:When entering the function and executing each step manually, the call to
suceeds always unless I execute it too quickly. When it fails, it fails with the IO error above. Running the more complex calls to triples-
add-schema
fails more reliably.Running it twice in a row makes it almost always fail:
Running the function triples calls under the hood many times also causes the same IO error consistently:
I haven't done much work with Sqlite in the past. Have you encountered something like this before in regard to the emacs sqlite library? Do you know what the issue could be?
I tried running hundereds of SQL write commands from the console as fast as possible and got no error.
Is there a way to make this library use the CLI version?
I have tried this in both Emacs 30 and Emacs 29.3 with the same results.
Thanks for any help!