How dwyl/learn-postgresql works
This repository is both a PostgreSQL learning tutorial and a small GitHub-data collection example. The documented learning path introduces PostgreSQL, getting started, SQL queries, writing queries, and deployment; the sampled runtime separately serves a client page and includes a scraper that stores GitHub data. Runtime links are limited to relationships visible in the excerpts or source index. The schema, query examples, and guide files are present in the tree, but their contents were not sampled.
Main entry points: README.md Postgres tutorial · bot.js GitHub scraper · server.js HTTP server · db.js Database access
Components 18
Learning materials
- Postgres tutorial
README.md - Getting started
install.md - SQL guides
tutorial.md - SQL commands
commands.md - FAQ
FAQ.md - Query examples
query.sql
Example application
- HTTP server
server/server.js - Page handler
server/request_handlers.js - Client page
client/index.html - LAN address
server/lanip.js
GitHub data collection
- GitHub scraper
server/bot.js - Runtime utilities
server/utils.js
Persistence
- Database schema
schema.sql - Database access
server/db.js - PostgreSQL
Other components
- Learner
- Browser user
- GitHub service
Connections 18
- Learner → Postgres tutorial: learns from
README.md - Postgres tutorial → Getting started: covers setup
README.md - Postgres tutorial → SQL guides: covers SQL
README.md - Postgres tutorial → Query examples: shows examples
README.md - Postgres tutorial → SQL commands: query guidance
- Postgres tutorial → FAQ: answers questions
- Postgres tutorial → Database schema: explains storage
- Postgres tutorial → Getting started: covers deployment
README.md - Browser user → HTTP server: requests page
- HTTP server → Page handler: routes requests
server/server.js - Page handler → Client page: reads and serves
server/request_handlers.js - HTTP server → LAN address: gets LAN address
server/server.js - GitHub scraper → GitHub service: fetches data
server/bot.js - GitHub scraper → Database access: stores records
server/bot.js - GitHub scraper → Runtime utilities: logs errors
server/bot.js - Database access → Runtime utilities: uses callbacks and logging
server/db.js - Database access → PostgreSQL: queries
server/db.js - Database schema → PostgreSQL: defines tables