Difference between revisions of "Development with PostgreSQL databases"
(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...") |
m |
||
| Line 1: | Line 1: | ||
| − | We have some datasets that we use for development of various kinds - visualizations, research, presentations, webpages, and so forth. This | + | 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 = | ||
Latest revision as of 13:28, 3 September 2019
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:
bowie.cs.earlham.edu
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
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).
