[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[elpa] externals/pq d4c53f6461 55/63: Update README.
From: |
ELPA Syncer |
Subject: |
[elpa] externals/pq d4c53f6461 55/63: Update README. |
Date: |
Mon, 14 Feb 2022 23:24:27 -0500 (EST) |
branch: externals/pq
commit d4c53f6461546afadb8cdd80b847bd8d7bf4e743
Author: Andreas Seltenreich <seltenreich@gmx.de>
Commit: Andreas Seltenreich <seltenreich@gmx.de>
Update README.
---
README.org | 32 +++++++++++++++++++++++++++-----
1 file changed, 27 insertions(+), 5 deletions(-)
diff --git a/README.org b/README.org
index 10f8fc0c41..cf3433bb72 100644
--- a/README.org
+++ b/README.org
@@ -1,13 +1,35 @@
-An Emacs 25 module for accessing postgres via libpq.
+An Emacs 25 module for accessing PostgreSQL via the libpq client library.
+
+Using libpq for client connections has various advantages over the
+wire-protocol speaking pure elisp implementations. For example, it
+has better performance and supports all features of the protocol like
+full TLS support and new authentication methods like scram-sha-256.
It doesn't expose many libpq features yet, but what's there should be
crash-safe no matter what you do in the lisp world. I've been using
-it half a year now for reading mail through my Gnus backend
[[https://github.com/anse1/nnpg][nnpg]]
-without incidents.
+it for two years now for reading mail through my custom Gnus backend
+without incidents. If you make it crash, please report.
-See [[./test.el]] for implemented functions and examples how to use it.
+Basic usage:
+: ELISP> (setq *pq* (pq:connectdb "dbname=andreas"))
+: #<user-ptr ptr=0x55b466c02780 finalizer=0x7f7d50112236>
+: ELISP> (pq:query *pq* "select version()")
+: ("PostgreSQL 9.6.7 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18)
6.3.0 20170516, 64-bit")
+: ELISP> (pq:query *pq* "create table local_variables(name text, value text)")
+: nil
+: ELISP> (dolist (el (buffer-local-variables))
+: (pq:query *pq* "insert into local_variables values ($1, $2)"
+: (car el) (cdr el)))
+: nil
+: ELISP> (pq:query *pq* "select name, length(value) from local_variables where
value ~ 'mode'")
+: (["major-mode" 24]
+: ["change-major-mode-hook" 86]
+: ["hi-lock-mode-major-mode" 24]
+: ["eldoc-mode-major-mode" 24]
+: ["font-lock-major-mode" 24]
+: ["font-lock-mode-major-mode" 24])
-If you make it crash, please report.
+See the testsuite [[./test.el]] for all implemented features.
Note that =pq= silently converts bigints and numerics your queries
return to lisp floats because they don't fit into a lisp integer.
- [elpa] externals/pq 83157bd41e 32/63: Cleanup session initialization., (continued)
- [elpa] externals/pq 83157bd41e 32/63: Cleanup session initialization., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 3026279578 48/63: Use pg_config with --includedir instead of --pkgincludedir., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 56fde7b255 53/63: Improve docstrings., ELPA Syncer, 2022/02/14
- [elpa] externals/pq c9df58b1ac 49/63: Always look up t and nil instead of caching them., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 04c91e8374 63/63: add pq.el and move pq.c -> pq-core.c, ELPA Syncer, 2022/02/14
- [elpa] externals/pq 8cc484c68b 62/63: README: Fix typos., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 272b18abec 43/63: Makefile: Add dependency to check target., ELPA Syncer, 2022/02/14
- [elpa] externals/pq bec131bfae 61/63: README: Elaborate on usage., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 8044537122 23/63: Add testcase that provokes a NOTIFY., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 5566645359 56/63: Fix ERROR-DATA not being a list., ELPA Syncer, 2022/02/14
- [elpa] externals/pq d4c53f6461 55/63: Update README.,
ELPA Syncer <=
- [elpa] externals/pq 0501c66e6a 51/63: Add testcase for crash reported by "717g301github"., ELPA Syncer, 2022/02/14
- [elpa] externals/pq bc939f732e 30/63: Setup emacs ert tests, ELPA Syncer, 2022/02/14
- [elpa] externals/pq 555791fef3 18/63: Add GPLv3 license., ELPA Syncer, 2022/02/14
- [elpa] externals/pq d8bca4bbd0 33/63: test: Add case that garbage-collects user-pointers., ELPA Syncer, 2022/02/14
- [elpa] externals/pq e3e74a950a 39/63: Make garbage-collection test more robust., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 8c03aeb2ec 15/63: Fix nargs compatible pointer type, ELPA Syncer, 2022/02/14
- [elpa] externals/pq cbdff81a90 47/63: Make docstring punctuation consistent., ELPA Syncer, 2022/02/14
- [elpa] externals/pq 5486071191 50/63: travis-ci: Also test with Emacs 26., ELPA Syncer, 2022/02/14
- [elpa] externals/pq ae8f1a33ac 45/63: Make PQreset available as pq:reset., ELPA Syncer, 2022/02/14
- [elpa] externals/pq fbc92e891d 59/63: README: Fix typo., ELPA Syncer, 2022/02/14