add pgmacs

6 files changed, 81 insertions, 2 deletions

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 @@
 <div class="talk-nav">
 Back to the [[talks]]  
 Previous by track: <a href="/2024/talks/org-teach">org-teach: a minor mode for writing course materials in Emacs</a>  
+Next by track: <a href="/2024/talks/pgmacs">PGmacs: browsing and editing PostgreSQL databases from Emacs</a>  
 Track: <span class="sched-track Development">Development</span>  
 </div>
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 @@
+<!-- Automatically generated by emacsconf-publish-after-page -->
+
+
+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.
+
+
+<!-- End of emacsconf-publish-after-page -->
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 @@
+<!-- Automatically generated by emacsconf-publish-before-page -->
+[[!toc  ]]
+Format: 10-min talk; Q&A: BigBlueButton conference room  
+Status: TO_CONFIRM  
+
+
+
+
+
+
+# Description
+<!-- End of emacsconf-publish-before-page -->
\ 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 @@
+
+<div class="talk-nav">
+Back to the [[talks]]  
+Previous by track: <a href="/2024/talks/literate">Literate Programming for the 21st Century</a>  
+Track: <span class="sched-track Development">Development</span>  
+</div>
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: <a href="#dev">Development</a>
 
 Jump to: <a href="#gen">General</a>
 
-<h1 id="dev" class="sched-track Development">Development (1 talk)</h1>
-[[!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
+<h1 id="dev" class="sched-track Development">Development (2 talks)</h1>
+[[!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 &copy; 2024 Eric Marsden"]]
+[[!inline pages="internal(2024/info/pgmacs-nav)" raw="yes"]]
+
+<!-- Initially generated with emacsconf-publish-talk-page and then left alone for manual editing -->
+<!-- You can manually edit this file to update the abstract, add links, etc. --->
+
+
+# PGmacs: browsing and editing PostgreSQL databases from Emacs
+Eric Marsden (he/him) - <mailto:eric.marsden@risk-engineering.org>
+
+[[!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"]]
+
+