PG-Farm

Research Requires Access to Data

Many of the data management research projects require public access to their data. Additionally the projects often hire web developers to create GUI user query tools. These requirements come with the additional challenges of providing database access to either the webapp and/or the public in a secure manner. Often campus IT departments security rules will not allow access outside their VPN or campus network; or if the database is hosted in the cloud, researchers are not versed in potential threats of opening up the database.

A possible solution benefiting both research projects and the library’s mission to the public would have the library hosting the database and providing a public API via hosted PostgREST as well as a public TCP Socket level connection to the database. This would provide web developers and the public with multiple access mechanisms allowing them to focus on their applications or studies. The library would play a central role in the discovery and distribution of the data while not in charge of the primary database data administration or system hosting/administration. Further the library provides access to the data for some agreed upon set time after the project/grant has stopped. If a set time limit for database hosting is set, the database could still be snapshotted and stored after this time expires, allowing public access via snapshot download.

A preview version of PG Farm is available online at https://pgfarm.library.ucdavis.edu