Questions tagged [sql-interactive-mode]
The sql-interactive-mode tag has no usage guidance.
23
questions
2
votes
1
answer
107
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 ...
- 133
0
votes
0
answers
26
views
Use comint with non-interactive CLI tools
Is it possible to run a CLI tool (via sql-* comint-based mode) that checks isatty() and immediately exits because the stdin is empty?
Maybe it is possible to force comint (or SQL mode) to run the tool ...
- 103
0
votes
0
answers
45
views
sql-interactive-mode get product name for the buffer
I have 2 connections to different servers through sql interactive mode:
(setq sql-connection-alist
'((mysql_server
(sql-product 'mysql)
(sql-server "server1")
(sql-user &...
- 1,069
2
votes
2
answers
378
views
Storing Database Authentication Details Securely
(Note: I would normally use gpg versions of these files but for debugging I've scrapped gpg until I can get it working without encrypting!)
I'd like to store my username/password credentials securely ...
- 545
1
vote
0
answers
314
views
Postgres sql prompt
I have connected to my remote postgres db via: https://stackoverflow.com/a/65310225/5065796
I am able to query and interact just fine. I cannot, however, see the prompt. It's just a blank line. It ...
- 4,547
2
votes
1
answer
874
views
How to send a string to the SQLi (sql-mode/sql-interactive-mode) buffer after processing?
How can I send a selected region in the sql-mode buffer to an external shell command and let the result be displayed in the sql-interactive-mode buffer (REPL)?
For example, normally, if I select a ...
- 1,374
2
votes
1
answer
2k
views
How to use a hyphenated user-name with postgres in sql-interactive-mode?
I have the following configuration in emacs init files to set a variable (user) to the current Unix login user:
(setq sql-postgres-login-params
`((user :default ,user-login-name)
(...
- 1,374
1
vote
1
answer
329
views
How to run sql-postgres without password?
My PostgreSQL authenticates using Unix Domain Sockets (Trust Authentication). When I run psql I do not need a password to connect to the database.
But when I run sql-postgres, I am always asked for a ...
- 1,388
3
votes
1
answer
224
views
Shortcut to restart sql-postgres process from sql-mode buffer?
Is there a shortcut key or command in Emacs (25.x under Unbuntu 18.04 LTS) to restart the sql-postgres process?
I need to quit and restart sql-postgres very often (for debugging purposes). Currently, ...
- 1,374
0
votes
0
answers
232
views
Open multiple *SQL* buffers (same product)
I connect to postgres by placing the following in a file on a remote server, opening over tramp, and executing:
(setq sql-connection-alist
'((pool-my_db
(sql-product 'postgres)
...
- 205
4
votes
1
answer
273
views
sql-connect with Ivy
I've switched from helm to Ivy and mostly everything works, but today I noticed that connecting to databases with sql-connect doesn't work anymore. I have the following in the variable sql-connection-...
- 521
3
votes
0
answers
148
views
How to abort a command executing in sqli-mode?
Whilst using a sqli buffer I accidentally ran a mahoosive query. What's the easiest way to abort it?
I used sql-postgres to start the process.
- 509
10
votes
1
answer
2k
views
Is there a company backend for completion in sql-interactive-mode?
I'm using sql-interactive-mode, and I'm in need for a Company backends that will complete SQL keywords, and preferably, also column/table names of the used database.
When looking around for any ...
- 3,920
0
votes
1
answer
118
views
The function will not pass anything to a SQL process, when called. There is no error
I liked the interactivity of Clojure/Lisp, where you can see the result in the REPL. I tried to implement the same behaviour for SQL-mode.
The idea is that when I do C-x C-e on the SQL-statemnt, I see ...
- 3,920
4
votes
2
answers
2k
views
How to change the indentation of major mode (SQL-mode)?
Configuration:
Emacs 25.0.50 on Ubuntu 15.04.
How to produce?
Do emacs -Q, then M-x sql-mode.
Paste the following in the buffer:
SELECT SUM(T01.foobar)
FROM db_foo.bar T01
WHERE T01.fooID = ...
- 3,920
2
votes
1
answer
258
views
How do I make multiple buffers use a single sql connection?
I am using sql mode. Is there a way to connect multiple buffers to a single sql connection? When I try to connect an existing buffer to a database, it always creates a new connection instead of ...
- 159
1
vote
0
answers
293
views
sql-connect: (setting-constant nil)
I am using latest Helm from MELPA on Emacs GNU Emacs 25.0.50.1 (x86_64-unknown-linux-gnu, GTK+ Version 3.16.6) of 2015-09-11
When I issue sql-connect I see this:
The only connection I have saved (in ...
- 3,340
7
votes
3
answers
2k
views
sql-send-paragraph results in mis-aligned headers
Anyone know how to fix this? I'm connecting to Postgres, and when I use a command like sql-send-paragraph to send a SQL query to the interactive *SQL* buffer, the headers are not aligned right. It's ...
- 691
0
votes
1
answer
410
views
sql-mysql console with glitches
When I run sql-mysql, it gives me an unusable console:
Note how the commands and results are misplaced. My emacs version is 24.5.1.
- 2,014
3
votes
0
answers
112
views
Send custom commands via psql interface
When interacting with postgresql via Emacs sql-postgres, is it possible to write aliases or functions, to be able to type for example, databases instead of \l, when I want to list all databases?
- 6,631
0
votes
1
answer
1k
views
Trying to connect to a MySQL database using SQLi with no luck [closed]
Been trying to follow this guide to setting up SQLi
http://truongtx.me/2014/08/23/setup-emacs-as-an-sql-database-client/
I use Customize Group SQL to set the parameters (host, username, etc.,) and ...
- 9
6
votes
1
answer
3k
views
Variables in Babel evaluation with SQL blocks
According to the org-mode manual, you can set variables in code blocks
as follows:
#+HEADERS: :var foo="blah"
#+BEGIN_SRC elisp
(message foo)
#+END_SRC
#+RESULTS:
: blah
However, when I try to do ...
- 503
4
votes
1
answer
836
views
Why do sql-mode and sql-interactive-mode not highlight strings the same way?
Here is a screenshot showing the difference between sql-interactive-mode (top) and sql-mode (bottom).
Why does the string not get highlighted properly in sql-interactive-mode? (Note - this also ...
- 2,457