Homepage: https://gitlab.com/cnngimenez/sqlite.el
Author: cnngimenez
Updated:
Use sqlite via ELisp
For usage and explanations see https://www.emacswiki.org/emacs/SQLite-el.
1 sqlite.el
═══════════
SQLite Interface through Elisp programming.
2 From EmacsWiki
════════════════
This code was retrieved from the EmacsWiki at december 26, 2013.
Contributors:
⁃ @mariotomo (Mario Frasca)
⁃ @cnngimenez
⁃ @kidd (Raimon Grau)
3 Features
══════════
This interface has the following features:
• Can connect to several database files.
• No output buffer shown. The output buffer is hidden when using the
interface.
• SQLite errors match.
• Files does not need to be in absolute path. It is expanded using
`expand-file-name' command.
• Timeout sub-process output retrieving for each result row. See
`sqlite-response-timeout' variable.
4 Usage
═══════
See usage and more information at the [SQLite EmacsWiki page].
Here is an example to query the database:
┌────
│ (require 'sqlite)
│
│ typical usage involves three functions
│ (let ((db (sqlite-init "~/mydb.sqlite"))) open connection
│ (unwind-protect perform body, return value, then clean up
│ (let ((res (sqlite-query db "SELECT * FROM my_table")))
│ Make more queries... more calculations ...
│ ...
│ res) the return value
│ (sqlite-bye db))) close connection
└────
[SQLite EmacsWiki page]
5 Licence
═════════
This work is under the GNU GPLv3 licence.
6 Happy Coding!
═══════════════