Craigje at 17:28, 3 September 2019

2019-09-03T17:28:49Z

← Older revision		Revision as of 17:28, 3 September 2019
Line 1:		Line 1:
	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.		We have some datasets that we use for development of various kinds - visualizations, research, presentations, webpages, and so forth. Our preferred database flavor for this is PostgreSQL, an open-source relational database system. We run an instance at the following host:

			<tt>bowie.cs.earlham.edu</tt>

			Use port 5432 (the firewall will block any attempt to connect to any other port on this server) and a PostgreSQL user account to get in and begin making queries.

			This page should help you use those databases as part of backend development.

	= Authenticating =		= Authenticating =

Craigje: 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..."

2019-09-03T17:26:13Z

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

New page

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. <tt>psycopg2</tt> 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).

Development with PostgreSQL databases - Revision history

Craigje at 17:28, 3 September 2019

Craigje: 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..."