diff options
| -rw-r--r-- | 2024/info/literate-nav.md | 1 | ||||
| -rw-r--r-- | 2024/info/pgmacs-after.md | 10 | ||||
| -rw-r--r-- | 2024/info/pgmacs-before.md | 12 | ||||
| -rw-r--r-- | 2024/info/pgmacs-nav.md | 6 | ||||
| -rw-r--r-- | 2024/schedule-details.md | 5 | ||||
| -rw-r--r-- | 2024/talks/pgmacs.md | 49 |
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 © 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"]] + + |