/Books-by-Genre

Primary LanguageJavaScript

Node to Postgres Lecture

Takeaways

  • You can connect to your Postgres database using the pg module
  • You need to know the URI for the database (see connectionString in server/routes/books.js)
  • Use pg.connect(...) to connect to the database
  • Use client.query(...) to query the database with SQL
  • When creating queries with client-submitted data, always use the prepared statement pattern (see router.post in server/routes/books.js)