Skip to main content
Big Data Test Infrastructure (BDTI)

PostgreSQL

PostgreSQL is an open source object-relational database management system that gives its users the ability to manage data, regardless of how large the database is. In PostgreSQL, you can define your own data types, build custom functions, and even write code in another programming language (e.g. Python) without recompiling the database.

Doccano

Features

Find below some of the main features of PostgreSQL:

  • High performance, extensibility, data integrity, and reliability (disaster recovery in place)
  • Supports text search, complex queries, and various data types
  • Runs on all major operating systems and is ACID-compliant
  • PostgreSQL provides multiple different GUI tools to users (e.g. pgAdmin or DBeaver)

Use Cases

Find below some examples of possible use cases:

  • Exploratory data analysis in SQL
  • Store and recover data backups
  • Perform direct analytics on data stored in the PostgreSQL database

Resources

Find below some interesting links providing more information on PostgreSQL: