Meeting 20231219

[zipperer]

GitHub

Add GitHub users for Michael to GitHub repository and project

psql help

Explore psql commands, e.g.

psql> help
psql> \?
psql> \! pwd
psql> \! ls

table with column that postgres updates on edit

Create database and add table with columns that (a) have default values and that (b) postgres cluster updates on edit to row. For columns with default values, see #25 . For column with value that postgres cluster updates on edit, see #26 .

[zipperer]

Notes for future:

• may run postgres on virtual machine served by proxmox

  • may use same virtual machine that runs web server

• look up database replication

  • 'read replica' and other
    • on https://ubuntu.com/server/docs/databases-postgresql , see 'Streaming Replication'
    • to do this locally, I could use home network and two servers.
    • may be able to do it with one server with postgres running and also a container running postgres
    • may be able to do it with one server with two separate containers running postgres
    • need to be able to specify ip address to get to other server/container
      • so, may need docker-compose with a shared network
  • see #32 . I record there what I have done for this.

• collect and share resources on postgres and python

[zipperer]

collect and share resources on postgres and python

See #33

[zipperer]

Aside from

may run postgres on virtual machine served by proxmox may use same virtual machine that runs web server

we have completed the tasks here.