.
.
.
.
.
.
.
.
.
.
.
.
.
.
Databases

Whether it's organising your research data or providing an online membership system the open source relational database PostgreSQL is a fast, reliable Oracle replacement capable of handling the task. We combine the speed and power of PostgreSQL with the versatility of Perl programming to deliver online and offline database solutions which are truly cross-platform.

Since PostgreSQL is a command-line database it is optimised to work with network programming interfaces which makes it an ideal choice for any web project or large network where availability and performance are critical.

Migration from Microsoft Access

Microsoft Access is a desktop database and was never designed to perform well as a network server. However, due to the ubiqity of Microsoft Office it is often used as an office database. As the number of connections increases, however, the limitations of Access become aparent. If your office network uses Microsoft Access you can still take full advantage of the power of PostgreSQL since PostgreSQL is fully ODBC compliant and can therefore be implemented using Access or Open Office as the graphical interface. So you can, if required, run your database online with PostgreSQL and connect to it from your office network with Access as the front-end.

Amongst the range of services we offer in building a database-driven application are:

  • Designing forms and other office software interfaces
  • Data & column typing
  • Column indexing
  • Query optimisation
  • Securing data directory access
  • Securing network access
  • Table repair & maintenance
  • User account management
  • Log file administration
  • Database backups
  • Server tuning