Skip to main content
Emacs

Questions tagged [sql]

Ask Question

The tag has no summary.

38 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
24 views

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 ...
Jason Hunter's user avatar
  • 1,236
0 votes
1 answer
87 views

I am trying to set up emacs as a database client for a MS SQL Server database with the sql-ms command. I've come across a few different tutorials and questions related to this. However, I am running ...
IsAdisplayName's user avatar
  • 113
0 votes
1 answer
55 views

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....
Jeffrey Benjamin Brown's user avatar
  • 147
0 votes
1 answer
56 views

The Postgres documentation contains this code ;; check for files with a path containing "postgres" or "pgsql" (setq auto-mode-alist (cons '("\\(postgres\\|pgsql\\).*\\.[ch]\\...
J. Mini's user avatar
  • 265
2 votes
1 answer
369 views

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 ...
J. Mini's user avatar
  • 265
0 votes
1 answer
162 views

Having a PostgreSQL DB model defined in SQL, i would like to generate an org-mode file with a bunch of org mode tables to document it. So for each CREATE TABLE, it creates an org-mode table with its ...
nephewtom's user avatar
  • 2,401
0 votes
2 answers
343 views

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 ...
Michel Lecomte's user avatar
  • 179
2 votes
4 answers
1k views

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 ...
Betta George's user avatar
  • 157
0 votes
0 answers
116 views

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 ...
Zain Jabbar's user avatar
  • 21
2 votes
0 answers
246 views

I am setting up an org-mode document to connect to a postgreSQL database and execute+show the results of some queries. I don't want the database password visible in the org document (regardless of ...
dlid's user avatar
  • 121
0 votes
0 answers
773 views

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 ...
a_subscriber's user avatar
  • 4,386
2 votes
2 answers
594 views

(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 ...
Phil's user avatar
  • 545
0 votes
1 answer
1k views

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 ...
gburnett's user avatar
  • 175
2 votes
2 answers
301 views

I am trying to enhance SQL mode such that editing of files of SQL code becomes more convenient, especially as far as jumping around is concerned (e.g. things like sql-goto-end-of-string etc.). I have ...
fsavigny's user avatar
  • 33
0 votes
1 answer
92 views

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 ...
javierecf's user avatar
  • 3
6 votes
2 answers
911 views

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 | |------+...
kai-dj's user avatar
  • 449
3 votes
1 answer
1k views

I have a question regarding connecting to a sql database programmatically. Ideally I would like to have a function with similar functionality to the sql-postgres but instead of interactively prompting ...
Zac Romero's user avatar
  • 185
2 votes
1 answer
1k views

windows 10, emacs 26.1 I know that in org mode I can insert source code and execute them. Nice. But what about sql: Here in my.org file: #+name: some_query #+BEGIN_SRC sql SELECT * FROM ...
a_subscriber's user avatar
  • 4,386
1 vote
1 answer
599 views

#+name: Part 1 Task 1 #+header: :engine mysql #+header: :dbhost localhost #+header: :dbuser subject #+header: :dbpassword 1234 #+header: :database hmsec #+begin_src sql SELECT sensorId, type, ...
Meltinglava's user avatar
  • 113
4 votes
1 answer
931 views

In emacs (in whatever mode you recommend for accessing a Postgres database) is it possible to type select * from foo_<tab> and somehow get autocomplete/help as to what tables are available in ...
american-ninja-warrior's user avatar
  • 4,081
3 votes
1 answer
690 views

I want an emacs SQL indentation function with the following properties: Upcase { select, from, as, where, group by, order by, asc, desc, and, or }. - EDIT: there are sqlup-mode.el and sql-upcase.el ...
Realraptor's user avatar
  • 1,353
2 votes
0 answers
61 views

I cannot repeat solution mentioned in 27610 for SQL. Seems there is no org-babel-variable-assignments:sql function in org.el.
Dima Fomin's user avatar
  • 183
0 votes
0 answers
249 views

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) ...
EoghanM's user avatar
  • 205
2 votes
0 answers
416 views

Can anyone explain why this does not work, i want to set the parameters global to the current document using PROPERTY but this does not work and results in this error. (wrong-type-argument stringp ...
Oly's user avatar
  • 603
9 votes
3 answers
4k views

I was listening to this song today - https://www.youtube.com/watch?v=ajy71xw351E Don't Wanna Leave You Now 🎵 🎶 and I realized how much I don't want to leave emacs. I often do this after ...
american-ninja-warrior's user avatar
  • 4,081
2 votes
1 answer
829 views

I am building a database application to index org-mode files (http://kitchingroup.cheme.cmu.edu/blog/2017/01/03/Find-stuff-in-org-mode-anywhere/). The first iteration used emacsql, which worked well ...
John Kitchin's user avatar
  • 12.2k
3 votes
1 answer
448 views

I guess I've been out of the loop for a while. I used to have this at the end of my org-mode SQL files: #+PROPERTY: engine mysql #+PROPERTY: dbhost xx.xx.xx.xx #+PROPERTY: dbuser xxxxxx #+PROPERTY: ...
GaryO's user avatar
  • 516
2 votes
0 answers
91 views

company-transform seems can be used to apply function on candidates. How to uppercase all SQL keywords which are in company complete candidates? only apply this transform function in SQL/NoSQL buffers,...
stardiviner's user avatar
  • 1,998
1 vote
2 answers
265 views

I use a monitor and a laptop screen as my multimonitor setup. Unfortunately the monitor and the laptop differs in resolution. So I use 2 frames, one frame on the monitor and one frame on the laptop ...
ReneFroger's user avatar
  • 3,752
4 votes
2 answers
2k views

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 = ...
ReneFroger's user avatar
  • 3,752
1 vote
0 answers
62 views

Editing Joomla articles in the web interface is the most pain the world. The articles in Joomla are stored in a mysql database. I'd like to figure out how I can connect a buffer to a "value" in ...
Jason Hunter's user avatar
  • 1,236
2 votes
1 answer
276 views

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 ...
mandark's user avatar
  • 159
1 vote
0 answers
321 views

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 ...
Manuel Uberti's user avatar
  • 3,400
0 votes
1 answer
209 views

we use web-mode (freemarker engine) to edit source files that contain freemarker directives and a lot of SQL. Editing in web-mode (freemarker engine) works fine. It would be very helpful if we could ...
mbisping's user avatar
  • 21
10 votes
2 answers
3k views

I'm using org-babel to do litterate programming and I find it very convenient. I am able to execute shell commands on remote hosts, and local database commands with the postgres client. To open a file ...
KookieMonster's user avatar
  • 387
5 votes
2 answers
1k views

SQL mode has some cool stuff set up for indenting with aligned keywords and such. Normally, I'd think it was cool. The problem is that at my new job, the people who wrote our mountains of sql did not ...
user3113723's user avatar
  • 181
0 votes
1 answer
577 views

I am looking into sql.el, and I can't find a way to bypass creating comint buffer and setting some global variables in order to connect to the database. This is less than ideal because I know the ...
wvxvw's user avatar
  • 11.6k
19 votes
4 answers
8k views

There are some general well-known coding standards and styles for SQL (e.g. capitalizing reserved words, placing main keywords in different lines, etc.). Does Emacs come with any modes for this, or ...
Amelio Vazquez-Reina's user avatar
  • 5,297