• (eepitch-shell)
• (eepitch-kill)
• (eepitch-shell)
sudo apt-get install postgresql
sudo apt-get install libpq-dev
sudo apt-get install postgresql-contrib
sudo apt-get install postgresql-plperl
sudo apt-get install postgis

# (find-status   "libpq-dev")
# (find-vldifile "libpq-dev.list")
# (find-vldifile "libpq-dev.list" "libpq-fe.h")
# (find-udfile   "libpq-dev/")

• (eepitch-shell)
• (eepitch-kill)
• (eepitch-shell)
                       dropdb     -e rcdnotes
                       dropdb     -e smith
sudo sudo -u postgres  dropuser   -e            $USER
sudo sudo -u postgres  createuser -e --createdb $USER
                       createdb   -e smith
                       createdb   -e rcdnotes

psql rcdnotes

•• Based on: (find-es "postgres" "emacs-libpq")
•• See: https://github.com/anse1/emacs-libpq
••      https://github.com/anse1/emacs-libpq/blob/master/Makefile
•• (find-git-links "https://github.com/anse1/emacs-libpq" "emacslibpq")
•• (find-gitk  "~/usrc/emacs-libpq/")
•• (code-c-d "emacslibpq" "~/usrc/emacs-libpq/")
•• (find-emacslibpqfile "")
•• (find-emacslibpqfile "README.org")
•• (find-emacslibpqfile "Makefile")
•• (find-emacslibpqfile "pq-core.c")
•• (find-emacslibpqfile "pq-core.c" "#include <libpq-fe.h>")
•• (find-emacslibpqfile "pq-core.c" "#include \"pg_type.h\"")
•• (find-emacslibpqfile "pq-test.el" "dbname=smith")
••
•• Choose one, or configure yourself:
•  (setenv "THISEMACSDIR" "/home/edrx/bigsrc/emacs25/src")
•  (setenv "THISEMACSDIR" "/home/edrx/bigsrc/emacs26/src")
•  (setenv "THISEMACSDIR" "/home/edrx/bigsrc/emacs27/src")
•  (setenv "THISEMACSDIR" "/home/edrx/bigsrc/emacs28/src")
•  (setenv "THISEMACSDIR" "/home/edrx/bigsrc/emacs29/src")
•  (setenv "THISEMACSDIR" "/home/edrx/bigsrc/emacs30/src")
•• Test: (find-fline "$THISEMACSDIR/")
••       (find-fline "$THISEMACSDIR/" "emacs-module.h")

• (eepitch-shell)
• (eepitch-kill)
• (eepitch-shell)
mkdir -p ~/usrc/emacs-libpq/
rm -Rfv  ~/usrc/emacs-libpq/
cd       ~/usrc/
git clone https://github.com/anse1/emacs-libpq
cd       ~/usrc/emacs-libpq/

make -f Makefile \
  EMACS=$THISEMACSDIR/emacs \
  EMACS_SRC_DIR=$THISEMACSDIR \
  EMACS_INCLUDE_DIR=$THISEMACSDIR \
  all                      2>&1 | tee oma

make -f Makefile \
  EMACS=$THISEMACSDIR/emacs \
  EMACS_SRC_DIR=$THISEMACSDIR \
  EMACS_INCLUDE_DIR=$THISEMACSDIR \
  check                    2>&1 | tee omc

# (find-emacslibpqfile "oma")
# (find-emacslibpqfile "omc")

•  (add-to-list 'load-path "~/usrc/emacs-libpq/")
•• (find-elinks-elisp (mapcar 'ee-S load-path))
•• (find-evardescr 'load-path)

• (require 'pq)

• (eepitch-shell)
• (eepitch-kill)
• (eepitch-shell)
rm -Rv /tmp/rcd/
mkdir  /tmp/rcd/
cd     /tmp/rcd/
wget https://gnu.support/files/emacs/packages/rcd-utilities.el
wget https://gnu.support/files/emacs/packages/rcd-notes/rcd-db-basics.el
wget https://gnu.support/files/emacs/packages/rcd-notes/rcd-pg-basics.el
wget https://gnu.support/files/sources/rcd-template.el

•  (add-to-list 'load-path "/tmp/rcd/")
•  (require 'rcd-utilities)
•  (require 'rcd-db-basics)
•  (require 'rcd-pg-basics)
•  (require 'rcd-template)
(setq my-db (rcd-db-connect "admin" nil "localhost" "maddox" "rosario"))

•  (code-c-d "rcd" "/tmp/rcd/")
•• (find-rcdfile "")
•• (find-rcdgrep "rcd-sql")
•• (find-rcdfile "rcd-db-basics.el")
•• (find-rcdfile "rcd-template.el")
•• (find-rcdfile "rcd-utilities.el")

•• Tests:
•  (rcd-sql "CREATE TABLE test (name TEXT)" my-db)
•  (rcd-sql "INSERT INTO test (name) VALUES ('John')" my-db)
•  (rcd-sql-first "SELECT * FROM test" my-db)
•  (rcd-sql-rollback my-db)
•  (rcd-sql-first "SELECT * FROM test" my-db)