{"repo":"emarsden/pg-el","free":true,"listed":false,"github":"https://github.com/emarsden/pg-el","clone":"git clone https://github.com/emarsden/pg-el.git","description":"Emacs Lisp network-level interface to the PostgreSQL database","language":"Emacs Lisp","stars":46,"topics":["postgresql","emacs","emacs-lisp","interface","database","wire-protocol"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"pg.el -- Emacs Lisp socket-level interface to the PostgreSQL RDBMS This library lets you access the PostgreSQL 🐘 database management system from Emacs, using its network-level frontend/backend “wire” protocol. The module is capable of automatic type coercions from a range of SQL types to the equivalent Emacs Lisp type. 📖 You may be interested in the user manual. This is a developer-oriented library, which won’t be useful to end users. If you’re looking for a browsing/editing interface to PostgreSQL in Emacs, you may be interested in PGmacs. This library has support for: - SCRAM-SHA-256 authentication (the default authentication method since PostgreSQL version 14), as well as MD5 and password authentication. There is currently no support for GSSAPI authentication. - Encrypted ( TLS ) connections with the PostgreSQL database, if your Emacs has been built with GnuTLS support. This includes support for authentication using client certificates. - Prepared statements using PostgreSQL’s extended query protocol, to avoid SQL injection attacks. - The PostgreSQL COPY protocol to copy preformatted data from an Emacs buffer to PostgreSQL, or to dump a PostgreSQL table or query result to an Emacs buffer in CSV or TSV format. - Asynchronous handling of LISTEN/NOTIFY notification messages from PostgreSQL, allowing the implementation of publish-subscribe architectures (PostgreSQL as an “event broker” or “message bus” and Emacs as event publisher and consumer). - Parsing various PostgreSQL ","default_branch":null,"files":null,"tree":[],"storefront":"/r/emarsden","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/emarsden/pg-el/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}