Questions tagged [sql]
The sql tag has no summary.
38 questions
0 votes
0 answers
24 views
Why is the register being cleared after ejc-sql initialization?
I've encountered an issue where one of my Emacs registers (specifically register 'e') is being cleared shortly after ejc-sql initializes. I've narrowed down the timing to about 7 seconds after Emacs ...
- 1,234
0 votes
1 answer
55 views
How to qualify a column name in a SQL query passed to emacsql?
Some context I'm querying my org-roam database, which is using the default sqlite3 format. The code I expected to work When I pass the following query to emacsql: [:select [source title nodes....
2 votes
1 answer
366 views
How can I make SQL output readable?
I'm trying to find an Emacs replacement for SQL Server Management Studio (SSMS). I have managed to query my Microsoft SQL Server from Emacs – and what a task that was! – through SQL Mode. However, the ...
- 265
0 votes
2 answers
343 views
lsp mode with mysql
Can lsp mode be used with a mysql server. I've setup lsp for some languages but cannot succeed with mysql. So far to connect I use emacsql package with a sql-connection-alist defined. This is what I ...
- 179
0 votes
0 answers
116 views
How to use Emacs Pinentry with Org-mode Bash source Blocks?
Main Problem I wanted to be more secure and convenient with my passwords and encryption so I have been trying to make GPG with Emacs work for my password store and SSH agent. I have Emacs-Pinentry ...
- 21
0 votes
0 answers
773 views
Emacs as database client?
Linux Mint 20.2 Emacs 27.2 In my work I use the next DBs: PostgreSQL SQLite MySQL Oracle MS SQlServer So I need different database client to work with it. It's not very convenient. So, the question ...
- 4,386
0 votes
1 answer
1k views
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 ...
- 175
0 votes
1 answer
92 views
Mode to edit SQL code inside XML tags [duplicate]
I'm new to emacs, does anybody know is there a way to combine xml-mode and sql-mode so SQL code inside tags can be highlighted and proper indent? example <FnTable ID="MyCode"> declare @ID ...
