Difference between revisions of "Development with PostgreSQL databases"

From Earlham CS Department
Jump to navigation Jump to search
(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...")
(No difference)

Revision as of 13:26, 3 September 2019

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).