Back to the talks Previous by time: HyWiki: Fast, hyperlinked note-taking with no markup required Next by time: About Blee: enveloping our own autonomy directed digital ecosystem with Emacs Track: General - Watch

PGmacs: browsing and editing PostgreSQL databases from Emacs

Eric Marsden (he/him) - eric.marsden@risk-engineering.org

The following image shows where the talk is in the schedule for Sun 2024-12-08. Solid lines show talks with Q&A via BigBlueButton. Dashed lines show talks with Q&A via IRC or Etherpad.

Schedule for SundaySunday 9:00- 9:10 Sunday opening remarkssun-open 9:10- 9:20 Unlocking linked data: replacing specialized apps with an Org-based semantic wikilinks 9:30- 9:50 Emacs regex compilation and future directions for expressive pattern matchingregex10:00-10:20 Survival of the skillest: Thriving in the learning junglelearning10:30-10:50 org-teach: a minor mode for writing course materials in Emacsorg-teach11:05-11:20 Fun things with GNU Hyperbolehyperbole 1:00- 1:20 HyWiki: Fast, hyperlinked note-taking with no markup requiredhywiki 1:35- 1:50 PGmacs: browsing and editing PostgreSQL databases from Emacspgmacs 2:05- 2:50 About Blee: enveloping our own autonomy directed digital ecosystem with Emacsblee 3:00- 3:20 Literate programming for the 21st Centuryliterate 3:35- 3:45 An example of a cohesive student workflow in Emacsstudents 3:55- 4:15 So you want to be an Emacs-fluencer?sharing 4:25- 4:55 Transducers: finally, ergonomic data processing for Emacs!transducers 5:00- 5:10 Sunday closing remarkssun-close9 AM10 AM11 AM12 PM1 PM2 PM3 PM4 PM5 PM

Format: 14-min talk; Q&A: BigBlueButton conference room https://media.emacsconf.org/2024/current/bbb-pgmacs.html
Discuss on IRC: #emacsconf
Status: Ready to stream

Times in different time zones:
Sunday, Dec 8 2024, ~1:35 PM - 1:50 PM EST (US/Eastern)
which is the same as:
Sunday, Dec 8 2024, ~12:35 PM - 12:50 PM CST (US/Central)
Sunday, Dec 8 2024, ~11:35 AM - 11:50 AM MST (US/Mountain)
Sunday, Dec 8 2024, ~10:35 AM - 10:50 AM PST (US/Pacific)
Sunday, Dec 8 2024, ~6:35 PM - 6:50 PM UTC
Sunday, Dec 8 2024, ~7:35 PM - 7:50 PM CET (Europe/Paris)
Sunday, Dec 8 2024, ~8:35 PM - 8:50 PM EET (Europe/Athens)
Monday, Dec 9 2024, ~12:05 AM - 12:20 AM IST (Asia/Kolkata)
Monday, Dec 9 2024, ~2:35 AM - 2:50 AM +08 (Asia/Singapore)
Monday, Dec 9 2024, ~3:35 AM - 3:50 AM JST (Asia/Tokyo)
Find out how to watch and participate

Description

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.

Questions or comments? Please e-mail eric.marsden@risk-engineering.org

Back to the talks Previous by time: HyWiki: Fast, hyperlinked note-taking with no markup required Next by time: About Blee: enveloping our own autonomy directed digital ecosystem with Emacs Track: General - Watch