From 9ede1059f5db7050de8fecf291ec7963c4357083 Mon Sep 17 00:00:00 2001 From: Sacha Chua Date: Thu, 29 Aug 2024 08:17:56 -0400 Subject: add pgmacs --- 2024/info/literate-nav.md | 1 + 2024/info/pgmacs-after.md | 10 ++++++++++ 2024/info/pgmacs-before.md | 12 ++++++++++++ 2024/info/pgmacs-nav.md | 6 ++++++ 2024/schedule-details.md | 5 +++-- 2024/talks/pgmacs.md | 49 ++++++++++++++++++++++++++++++++++++++++++++++ 6 files changed, 81 insertions(+), 2 deletions(-) create mode 100644 2024/info/pgmacs-after.md create mode 100644 2024/info/pgmacs-before.md create mode 100644 2024/info/pgmacs-nav.md create mode 100644 2024/talks/pgmacs.md diff --git a/2024/info/literate-nav.md b/2024/info/literate-nav.md index 80c4b632..77df1ef0 100644 --- a/2024/info/literate-nav.md +++ b/2024/info/literate-nav.md @@ -2,5 +2,6 @@
Back to the [[talks]] Previous by track: org-teach: a minor mode for writing course materials in Emacs +Next by track: PGmacs: browsing and editing PostgreSQL databases from Emacs Track: Development
diff --git a/2024/info/pgmacs-after.md b/2024/info/pgmacs-after.md new file mode 100644 index 00000000..bd63ed38 --- /dev/null +++ b/2024/info/pgmacs-after.md @@ -0,0 +1,10 @@ + + + +Questions or comments? Please e-mail [eric.marsden@risk-engineering.org](mailto:eric.marsden@risk-engineering.org?subject=Comment%20for%20EmacsConf%202023%20pgmacs%3A%20PGmacs%3A%20browsing%20and%20editing%20PostgreSQL%20databases%20from%20Emacs) + +---- +Got an idea for an EmacsConf talk or session? We'd love to hear from you! Check out the [[Call for Participation|/2024/cfp]] for details. + + + diff --git a/2024/info/pgmacs-before.md b/2024/info/pgmacs-before.md new file mode 100644 index 00000000..bbac2748 --- /dev/null +++ b/2024/info/pgmacs-before.md @@ -0,0 +1,12 @@ + +[[!toc ]] +Format: 10-min talk; Q&A: BigBlueButton conference room +Status: TO_CONFIRM + + + + + + +# Description + \ No newline at end of file diff --git a/2024/info/pgmacs-nav.md b/2024/info/pgmacs-nav.md new file mode 100644 index 00000000..9203ac05 --- /dev/null +++ b/2024/info/pgmacs-nav.md @@ -0,0 +1,6 @@ + +
+Back to the [[talks]] +Previous by track: Literate Programming for the 21st Century +Track: Development +
diff --git a/2024/schedule-details.md b/2024/schedule-details.md index af6e9666..428d8b5a 100644 --- a/2024/schedule-details.md +++ b/2024/schedule-details.md @@ -9,5 +9,6 @@ Jump to: Development Jump to: General -

Development (1 talk)

-[[!template id=sched title="""Literate Programming for the 21st Century""" url="""/2024/talks/literate""" speakers="""Howard Abrams""" watch="""https://emacsconf.org/2024/watch/dev""" slug="""literate""" note=""""""]] \ No newline at end of file +

Development (2 talks)

+[[!template id=sched title="""Literate Programming for the 21st Century""" url="""/2024/talks/literate""" speakers="""Howard Abrams""" watch="""https://emacsconf.org/2024/watch/dev""" slug="""literate""" note=""""""]] +[[!template id=sched title="""PGmacs: browsing and editing PostgreSQL databases from Emacs""" url="""/2024/talks/pgmacs""" speakers="""Eric Marsden""" watch="""https://emacsconf.org/2024/watch/dev""" slug="""pgmacs""" note=""""""]] \ No newline at end of file diff --git a/2024/talks/pgmacs.md b/2024/talks/pgmacs.md new file mode 100644 index 00000000..232294ac --- /dev/null +++ b/2024/talks/pgmacs.md @@ -0,0 +1,49 @@ +[[!meta title="PGmacs: browsing and editing PostgreSQL databases from Emacs"]] +[[!meta copyright="Copyright © 2024 Eric Marsden"]] +[[!inline pages="internal(2024/info/pgmacs-nav)" raw="yes"]] + + + + + +# PGmacs: browsing and editing PostgreSQL databases from Emacs +Eric Marsden (he/him) - + +[[!inline pages="internal(2024/info/pgmacs-before)" raw="yes"]] + +PGmacs provides an Emacs-based browsing and +editing interface for the PostgreSQL DBMS. It +allows you to browse the contents of database +tables, in paginated mode for large tables, to +edit column values in the minibuffer or using a +widget-based interface, to delete, copy and insert +new rows, and to save the contents of a table in +CSV or JSON format. You can run shell commands on +column values. You can also rename tables and +columns, add SQL comments, and generate SchemaSpy +diagrams. + +PGmacs works both in the terminal and in GUI mode. +It uses the pg-el library, which implements the +PostgreSQL wire protocol, to connect to PostgreSQL +over the network or over a Unix socket. + +The talk will provide an overview of the functionality of PGmacs, then show how it can be easily +extended to display images stored as database BLOBs inlined in a row-list buffer. + +About the speaker: + +Eric Marsden developed his first Emacs packages +pg-el, coffee.el (an implementation of the +essential Hyper Text Coffee Pot Control Protocol) +and ipp.el as a procrastination exercise to avoid +working on his PhD. He continues to use Emacs Lisp +in his spare time. + + + +[[!inline pages="internal(2024/info/pgmacs-after)" raw="yes"]] + +[[!inline pages="internal(2024/info/pgmacs-nav)" raw="yes"]] + + -- cgit v1.2.3