Meeting 20231128

[zipperer]

TODO: agenda for meeting

To make an agenda for the meeting, Andrew will

• recap what we have done (see #2 and milestones in this project)
• make issues for some of what we need to do (see milestones in this project)
• ask Michael what Michael wants to do during meeting, e.g.
  • set up postgres on device we will use in production
  • export CSV for each table in Lotus Approach
  • make CREATE TABLE statement for each table
  • import data from CSV into table in postgres for each table in Lotus Approach
  • for table mailing_list make listenerid_new column and make it PRIMARY KEY (#6)
  • for tables with columns that refer to listenerid in mailing_list, make it so those tables refer to listenerid_new (#6)
  • configure postgres cluster on device to permit connections from external IP addresses
  • install TablePlus or pgAdmin or another graphical tool for users that will access+edit database
  • and use the tool

[zipperer]

TODO: for

configure postgres cluster on device to permit connections from external IP addresses make an issue and put instructions on the issue

Same for

install TablePlus or pgAdmin or another graphical tool for users that will access+edit database

[zipperer]

TODO: for

configure postgres cluster on device to permit connections from external IP addresses make an issue and put instructions on the issue

Same for

install TablePlus or pgAdmin or another graphical tool for users that will access+edit database

See #10 and #11, #12, #13

[zipperer]

Recap of what we did during meeting

• debug tableplus install. See #11
• make tableplus connection to postgres. See #12
• use tableplus. See #13
  • view data
  • add row
  • add listener_id_new column. See comment on #6
  • query table
• tighten varchar to date. See comment on #5 .
• experiment with pg_dump and restore. See #23
• consider how to print labels
  • a possible alternative: glabels. See #7