Meeting 20231128

[zipperer]

TODO: agenda for meeting

To make an agenda for the meeting, Andrew will

• recap what we have done (see Meeting 20231121 #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 (For table mailing_list make new column to identify listener, use integer that increments automatically #6)
  • for tables with columns that refer to listenerid in mailing_list, make it so those tables refer to listenerid_new (For table mailing_list make new column to identify listener, use integer that increments automatically #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 install TablePlus #11
• make tableplus connection to postgres. See TablePlus -- connect to postgres instance, see database and tables #12
• use tableplus. See TablePlus -- use GUI to add new row to table and commit change, query contents of table #13
  • view data
  • add row
  • add listener_id_new column. See comment on For table mailing_list make new column to identify listener, use integer that increments automatically #6
  • query table
• tighten varchar to date. See comment on Import data into table in postgres for mailing_list #5 .
• experiment with pg_dump and restore. See Perform backup and restore #23
• consider how to print labels
  • a possible alternative: glabels. See Try glabels program for making labels and printing #7