Spring 2020 Online SQL Tester Note: This runs pgweb on a postgres - - PowerPoint PPT Presentation

spring 2020
SMART_READER_LITE
LIVE PREVIEW

Spring 2020 Online SQL Tester Note: This runs pgweb on a postgres - - PowerPoint PPT Presentation

CompSci 316 Spring 2020 Online SQL Tester Note: This runs pgweb on a postgres server in the read-only mode for simple testing in class. You will receive instructions for installing your own Postgres server and load databases on the VM that you


slide-1
SLIDE 1

CompSci 316 Spring 2020 Online SQL Tester

Note: This runs pgweb on a postgres server in the read-only mode for simple testing in class. You will receive instructions for installing your own Postgres server and load databases on the VM that you will be able to edit!

slide-2
SLIDE 2

Just click the link!

  • http://compsci316-db-server.cs.duke.edu:8081/#
  • User name: test
  • Password: test
slide-3
SLIDE 3
  • Enter everything as

shown

  • Host: compsci316-

db- server.cs.duke.edu

  • Username:

student316

  • Password:

compsci316

  • Database: beers
  • In case the

connection does not work, try leave the host name blank

slide-4
SLIDE 4
  • List of tables is on the right (circled in red)
  • Click on any of the tables and then choose the info

you want on top (line in blue)

slide-5
SLIDE 5

<- write queries here

  • Select Query on top to start writing sql.

<- click to run <- results