ELISP> (sqlite-select x/db "SELECT count(*) FROM post")ĮLISP> (benchmark-run-compiled (sqlite-select x/db "SELECT * FROM post")) I tried selecting from a post table with 100k+ rows in it. I think this is the functionality you're looking for. ELISP> (setq x/file "/my/db")ĮLISP> (sqlite-select x/db "SELECT * FROM forum") I then opened up M-x ielm to try it out as well. (declare-function sqlite-open "sqlite.c") (declare-function sqlite-select "sqlite.c") (declare-function sqlite-finalize "sqlite.c") (declare-function sqlite-columns "sqlite.c") (declare-function sqlite-next "sqlite.c") (declare-function sqlite-more-p "sqlite.c")
(declare-function sqlite-execute "sqlite.c") I just compiled it, and I took a look at sqlite-mode.el to see what kinds of functions it offered.
Starting from version 29, native SQLite support will be included in Emacs.
0 kommentar(er)
