PostgreSQL

About

PostgreSQL doesn't have as much wide adoption as MySQL, but it is well known for its advanced features, extensibility, and robustness. It has the ability to support complex data types, full-text-search, and advanced indexing techniques. For this reason, it is often preferred when dealing with large volumes of data that require more complex queries and advanced features.

Use Cases

  • If you need to persist data in your application.
  • If you need a relational database.
  • If you need to support complex data types.
  • If you're planning on performing advanced analytics on large data volumes.

Settings

Name Default Description
Version 16 The version of PostgreSQL to use.
User default The username of the created PostgreSQL user.
Password secret The password of the created PostgreSQL user.
Port 5432 The port PostgreSQL will be accessible from.