Development with PostgreSQL databases

From Earlham CS Department
Revision as of 12:26, 3 September 2019 by Craigje (talk | contribs) (Created page with "We have some datasets that we use for development of various kinds - visualizations, research, presentations, webpages, and so forth. This helps you use them as part of your b...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

We have some datasets that we use for development of various kinds - visualizations, research, presentations, webpages, and so forth. This helps you use them as part of your backend development.

Authenticating

VERY IMPORTANT SECURITY NOTE

Do not hardcode your username and password into source code. Full stop. Instead read from an external file. Do not place this external file under version control, do not post it to any website (do not pass "Go", do not collect $200...).

How to actually do it

Most languages have a PostgreSQL library (e.g. psycopg2 in Python). Check its documentation.

If you do not already have a user account, email the admins and ask for one to be created for you (or your group).

Retrieved from "https://wiki.cs.earlham.edu/index.php?title=Development_with_PostgreSQL_databases&oldid=17431"