Differences

This shows you the differences between two versions of the page.

--- services:database [2024/02/06 15:55] – jas
+++ services:database [2024/02/07 11:00] (current) – jas
@@ Line 1: / Line 1: @@
 ====== Database Access ======
-A Postgres database is available for EECS courses requiring database use.  Faculty who want to use the database in their course can send a request to tech including the respective course and section numbers. The tech team will create a database for each student in each course.  Faculty should also request access for their course TAs.
+A Postgres database is available for EECS courses requiring database use.  Faculty who want to use the database in their course can send a request to tech including the respective session, term, course and section numbers. The tech team will create a database for each student in each course.  Faculty should also request access to the database for their course TAs.
+At the end of the term, all user databases will be removed.
 ===== Access Database By CLI =====
-In order to access the database by command line, students can issue the "psql" command from any EECS tech-supported Linux system.  Students must be enrolled in a course that has requested database access.  The student will be logged into Postgres, and connected to a database that has the same name as their EECS username.
+In order to access the database by command line, students use the "psql" command from any EECS tech-supported Linux system.  Students must be enrolled in a course that has requested database access.  Students will be automatically logged into the database, and connected to their own database which has the same name as their EECS username.
 ===== Access Database By GUI =====
-An enterprise database management tool called [[https://dbeaver.com/dbeaver-enterprise/|DBeaver Enterprise]] is available for students to access the database in a GUI.  Students will need to complete the steps below one time:
+An enterprise database management tool called [[https://dbeaver.com/dbeaver-enterprise/|DBeaver Enterprise]] is available for students to access the database via a GUI.  Students will need to complete the steps below one time:
-  * From the Linux terminal, type "id -u".  You will get back a number.  Record that number.
+  * From the Linux terminal, type "id -u".  You will get back a number.  Record that number as it will be used in a later step.
-  * Start DBeaver with the "dbeaver" command.
+  * Start DBeaver either from the command line with the "dbeaver" command, or via GNOME (Click on "Activities", then type "dbeaver" in the search).
   * When DBeaver starts, you will be prompted: "Do you want to create sample database? It can be used as an example to explore basic DBeaver Enterprise features".  You can select Yes/No.
   * From the "File" menu, choose "New", then open "DBeaver" folder, then select "Database Connection".
@@ Line 33: / Line 36: @@
   * Click on the down arrow, and you will be connected to your personal database.
+When you start dbeaver in the future, these settings will already be saved.