PostgreSQL

project: Sudamih (Supporting Data Management Infrastructure for the Humanities)

The Supporting Data Management Infrastructure for the Humanities (Sudamih) Project aims to address a coherent range of requirements for the more effective management of data (broadly defined) within the Humanities at an institutional level. Whilst the project is fully embedded within the institutional context of Oxford University, the methodologies, outputs and outcomes will be of relevance to other research-led universities, especially but not only, in their support of research within the humanities. [read more]

tool: PostgreSQL

Purpose: 

PostgreSQL is a powerful, open source object-relational database system.

Features: 

• fully ACID compliant
• full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages)
• includes most SQL 2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP
• supports storage of binary large objects, including pictures, sounds, or video
• multi-Version Concurrency Control (MVCC)
• Highly customisable

A&H use case 1 description: 
The “Great Britain Historical Geographical Information System (GBHGIS)” has used PostgreSQL to store the geographically-located historical statistics for Great Britain.
Creator: 
Michael Stonebraker
Publisher: 
PostgreSQL Global Development Group
Suite: 
Software/programming languages used: 
Alternate tool(s): 

FileMaker, MySQL, SQLite, Firebird

lifecycleStage: 

project: A Vision of Britain through Time

This website presents the history of Great Britain through places between 1801 and 2001. It includes maps, statistical trends, a gazetteer of British administrative units, on-line versions of a selection of tables and early printed text from some of the published Census Reports as well as historical descriptions of places and journeys. The site is free to use and does not require any registration. [read more]

project: Great Britain Historical GIS project

The Great Britain Historical Geographical Information System is a unique digital collection of information about Britain's localities as they have changed over time. Information comes from census reports, historical gazetteers, travellers' tales and historic maps, assembled into a whole that is much more than the sum of its parts. [read more]

project: HESTIA

HESTIA provides a new approach towards conceptions of space in the ancient world, supported by a grant from the Arts and Humanities Research Council (AHRC). Combining a variety of different methods, it examines the ways in which space is represented in Herodotus' History, in terms of places mentioned and geographic features described. [read more]

project: A Corpus of Scottish Medieval Parish Churches

Apart from a few widely known examples, such as Edinburgh St Giles or Perth St John, the medieval parish churches of Scotland are very rarely dealt with in discussions of architecture in Britain in the Middle Ages. This is largely because they have never been systematically studied as a body, and there is surprisingly little knowledge of how much of medieval date survives. [read more]

project: The Corpus of Modern Scottish Writing (1700-1945)

The Corpus of Modern Scottish Writing (1700-1945) project will provide an evidence-based platform for a new account of the development of Modern Scots and Scottish English. It will create a major research resource, namely a publicly available, digitised archive of texts in language varieties ranging from Broad Scots to Scottish Standard English. This corpus will provide the 'missing link' between the Helsinki Corpus of Older Scots and its related projects (1375-1700) and the Scottish Corpus of Texts and Speech (1945-present day; www.scottishcorpus.ac.uk ). [read more]