PostgreSQL® welcome
===================

PostgreSQL® is an open source, **relational database**. It's ideal for organisations that need a well organised tabular datastore.
On top of the strict table and columns formats, PostgreSQL also offers solutions for nested datasets with the native ``jsonb`` format and advanced set of extensions including `PostGIS <https://postgis.net/>`_, a spatial database extender for location queries.
Aiven for PostgreSQL is the perfect fit for your relational data. A scalable SQL database solution that can be up and running within a few minutes.

.. grid:: 1 2 2 2

    .. grid-item-card::
        :shadow: md
        :margin: 2 2 0 0

        📚 :doc:`/docs/products/postgresql/concepts`

    .. grid-item-card::
        :shadow: md
        :margin: 2 2 0 0

        💻 :doc:`/docs/products/postgresql/howto`

    .. grid-item-card::
        :shadow: md
        :margin: 2 2 0 0

        📖 :doc:`/docs/products/postgresql/reference`

    .. grid-item-card::
        :shadow: md
        :margin: 2 2 0 0

        🧰 :doc:`Code samples </docs/products/postgresql/howto/list-code-samples>`


PostgreSQL resources
--------------------

If you are new to PostgreSQL then there are lots of great resources out there to get you started with the platform. Here's our recommended reading list:

* `PostgreSQL Project website <https://www.postgresql.org/>`_ providing a comprehensive per-release documentation

* `PostGIS website <https://postgis.net/>`_ to read about location queries and the spatial extension

Starter project
---------------

If you don't have a dataset to play with, try our `Exoplanet example <https://aiven.io/blog/discover-exoplanets-with-postgresql?utm_source=github&utm_medium=organic&utm_campaign=devportal&utm_content=repo>`_