How to run a sqlite script from Emacs

Question

I'd like to edit a sqlite script in an emacs buffer. I wonder how to run this script(or buffer) from emacs. Any good idea for this? Thanks.

Alex Ott · Accepted Answer · 2021-05-12 08:32:18Z

2

sqlite is supported out of box in the built-in sql-mode that is automatically enabled for files with .sql extension. You can press M-x sql-sqlite to get access to your sqlite database.

After that you can use commands like C-c C-r to send the region to interpreter and see the results (there are also other commands like send paragraph, send buffer, etc. - see them in the SQL menu.

EmacsWiki has a page about this mode where you can find more recipes, etc.

answered May 12, 2021 at 8:32

Alex Ott

88.1k10 gold badges110 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

lyl Over a year ago

Thank you for your solution. And I set up a file with .sql extention. Then I tried your way, but find that all send... commands in the SQL menu are in grey which means unaccessible. How to deal with that?

Alex Ott Over a year ago

You need to execute M-x command first to open a session

Collectives™ on Stack Overflow

How to run a sqlite script from Emacs

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related