• Blog posts

    Bio

    By David Crowther

    PostGIS___PGAdmin_or_DBeaver_-_1..JPG

    Question:

    I am struggling with the latest version of PGAdmin,.. is there any other database GUI that I can use?

    Answer:

    Why not try DBeaver!https://dbeaver.io/

    PostGIS___PGAdmin_or_DBeaver_-_2.JPG

    It’s a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supporting all popular databases: MySQL, PostgreSQL, SQLite, Oracle etc…

    I have just started to use DBeaver in place of PGAdmin as the new browser version of PGAdmin was less stable than before.

    So far I have successfully managed to connect to my PostGIS Instance:

    PostGIS___PGAdmin_or_DBeaver_-_3.JPG

    Viewed the Schemas and Tables in my PostGIS Database.

    PostGIS___PGAdmin_or_DBeaver_-_4.JPG

    Viewed the records in a PostGIS table.

    PostGIS___PGAdmin_or_DBeaver_-_5.JPG

    Ran a simple Query.

    PostGIS___PGAdmin_or_DBeaver_-_6.JPG

    And viewed the query results in both an Attribute window.

    PostGIS___PGAdmin_or_DBeaver_-_7.JPG

    And in a Spatial Viewer!

    PostGIS___PGAdmin_or_DBeaver_-_8.JPG

    The Spatial Viewer alone has meant that I have decided to use DBeaver as my DB Manager for all things PostGIS for the coming months.

    Watch this space for further FAQs and Blogs as I start to see how DBeaver can help me to manage my spatial datasets.