Emacs Stack Exchange
Emacs Stack Exchange

Questions tagged [sqlite]

11 questions
6
votes
2 answers

How to copy org-table to postgresql database?

With sqlite one can easily populate a table in a database via a org-table like so: [EDIT](using only one sqlite-scr-block with org-table variable parameter)[/EDIT] #+NAME: A | val1 | val2 | |------+------| | 2 | 16 | | 4 | 25 | | 10 | …
kai-dj
  • 427
  • 2
  • 15
4
votes
3 answers

Cannot enable org-roam mode - No EmacSQL SQLite binary avaiable

I've installed org-roam (Windows 10, 26.3 x86_64-w64-mingw32) but when I try to call org-roam... then Emacs show: Loading d:/MEGAsync/Emacs/config/init.el (source)...done Could not find C compiler, skipping SQLite build Org-roam initialization:…
laplace
  • 43
  • 1
  • 3
3
votes
1 answer

What's this `slot-missing: Invalid slot name: "#", :file`

I somehow messed up my magit/forge db, and now emacs won't forgive me. Now I can't open magit's status buffer, and sometimes not even a file buffer opens. This is all I can gather from the Messages buffer: Cannot insert ("'" "Forge" forge-dispatch)…
philsf
  • 215
  • 1
  • 8
2
votes
3 answers

How can I query an existing SQLite database from elisp, that is, non-interactively?

There are multiple questions with "sqlite" in the title, but they all want to run SQL queries interactively, which sql-mode does. What I want is the following: I have a pre-existing SQLite database whose format I know. This database is maintained…
Betta George
  • 57
  • 4
1
vote
0 answers

Emacs will not compile sqlite binary and will not run compiled sqlite binary

I am running emacs 28.2 on windows 10, trying to start using the org-roam package which requires emacsql-sqlite. I have installed msys2 and used it to install gcc following the instructions here as well as adding the folder containing the gcc…
Lore
  • 183
  • 9
1
vote
1 answer

"No EmacSQL SQLite binary available" while running Org-Roam on GUIX

I'm struggling to set up Org-Roam on a minimal GUIX set-up. There is an attempt to compile Compiling EmacSQL SQL binary which throws an error No EmacSQL SQLite binary available. I have installed both gcc and clang and the correct path (ie. the same…
krozruch
  • 13
  • 5
1
vote
0 answers

Other Emacs profile unable to load directory path

I used to use vanilla emacs and am trying out Doom emacs in a separate chemacs profile where my config files are under ~/.doom.d/ and my doom files are under ~/.emacs.doom.d/ I am trying to use the org-roam package but unfortunately my Doom Emacs…
sab hoque
  • 135
  • 4
1
vote
0 answers

Debugger breaks with Args out of range: "", 0

When forge is installed on a system with no compiler, I sometimes get this error which breaks magit. I'd like to figure out the traceback for this error so I can add some proper error handling, however, when I call (toggle-debug-on-error) every time…
reish
  • 111
  • 2
1
vote
2 answers

How execute sqlite query?

windows 10, emacs 26.1 I has file my_test.sql. This file content SQLite query. Is it possible to execute this sql query and get results? I has sqlite db file test.db It has table notification_invoice I create file my_test.sql with one sql…
a_subscriber
  • 3,854
  • 1
  • 17
  • 47
0
votes
0 answers

Unable to use org-roam on Windows 10

The problem is quite simple : I want to use org-roam on my Emacs on my Windows 10 laptop, and for a mysterious reason, it just won't work. What I have done : I have installed org-roam by adding those lines in my .emacs.d/init.el file…
Thibault Cimic
  • 113
  • 3
0
votes
1 answer

How do I open an sqlite database from elisp?

I have a filepath for a sqlite database. I want to open an sql client buffer. I would like to know the best way to open that database from elisp. So far I can see that sql-sqlite will open it but it requires an interaction. I'm calling (sql-sqlite…
gburnett
  • 165
  • 7