Skip to content

README.md

Latest commit

 

History

History
33 lines (27 loc) · 1.81 KB

README.md

File metadata and controls

33 lines (27 loc) · 1.81 KB
Raw

Labs — course notes and exercises (2019)

These folders are the coursework record and are intentionally left as submitted; projects/project01 is the modernized, CI-verified reference. All four databases they target come up with docker compose up -d from the repo root.

Lab Database Contents
lab02 PostgreSQL table constraints and FK match types (constraints.md), psql help meta-commands (command_line.md), CREATE TABLE/ALTER exercises
lab03 PostgreSQL ILIKE queries, create/delete rules, in-class exercise
lab04 MongoDB shell queries, regex, cursors, map-reduce over a cities collection
lab05 CouchDB HTTP CRUD with curl, documents, attachments, bulk user import
lab06 CouchDB design docs, views, view parameters, reducers, conflict handling
lab07 Neo4j the built-in movie graph: create, find, query patterns, the "Bacon Path" shortest-path, recommendations

Reading the 2019 MongoDB code today

lab04 scripts use db.system.js.save() and legacy helpers like .count()/.insert(). MongoDB has since removed stored server-side JavaScript and the legacy shell — modern equivalents are countDocuments(), insertOne(), and application-side functions. projects/project01 shows the same patterns ported to mongosh and Python (jsServerSideFinal.js, place_order.py — note the map-reduce lab's pattern is now expressed with aggregation pipelines).

CouchDB and Neo4j quickstarts

  • CouchDB: curl -u admin:couchdb http://localhost:5984/_all_dbs — then follow the lab05/lab06 .txt command notes.
  • Neo4j: open http://localhost:7474 (neo4j/databasedisco) and run :play movie-graph to follow lab07's notes.