I want to manage simple personal databases, like mp3 collections.
I am not aware of any updated lisp object database project working in Emacs (correct me if I am wrong).
So I would turn to Sqlite, because it seems the only viable serverless database (right?). Have you experience with some library to create or query tables?
I am not particularly interested to Emacs SQL modes, but to libraries sending commands to DBs.
The most popular package on MELPA is esqlite. Here's a simple example of its usage:
(require 'esqlite)
(esqlite-read "database.sqlite" "SELECT * FROM hoge")
Your other option is the sqlite package, also from MELPA. An example snippet with that packages API is:
(require 'sqlite)
(let ((descriptor (sqlite-init "~/mydb.sqlite")))
(setq res (sqlite-query descriptor "SELECT * FROM persona"))
(sqlite-bye descriptor)
res)
abo-abo also pointed out the more powerful emacsql package which is more can interface with other RDBMS (including MySQL, and SQLite). Of the packages described here, emacsql has the most abstract API (where queries are represented as objects instead of raw strings). Here's an example of its usage:
(require 'emacsql)
(defvar db (emacsql-connect "~/company.db"))
;; Query the database for results:
(emacsql db [:select [name id]
:from people
:where (> salary 62000)])
There are probably even more solutions. The question, then, comes down to which package supports the methods you need, and which API you like the most.
