PostgreSQL 13 – lucky number in the world of Postgres

2020-09-08

Many people suffer from the irrational fear of 13, which is professionally referred to as triskaidecaphobia. In the case of the latest PostgreSQL release, bearing this number, however, the concerns are unfounded. Almost everyone will find changes that improve Postgres’s everyday aspects. So let’s try „conjure up ” apparent unluckyness of the 13th PostgreSQL release. […]

Read more

PostgreSQL vs MySQL – which open-source database is better?

2020-04-30
blank

PostgreSQL and MySQL are two extremely popular relational database management systems that have been improved upon for over two decades. Both solutions have their advantages and disadvantages. Which one is the best? Most developers would probably say that PostgreSQL is ideal for large, complex analytical processes, while MySQL is better for websites or online transactions. […]

Read more

What are columns generated in PostgreSQL 12?

2020-03-19
blank

PostgreSQL is known for its almost fanatical pursuit of database standards implementation. With the release of version 12, another step was taken towards making them available as fully as possible in the Open Source model. In this text we will focus on generated columns, also called virtual columns, which allow you to use the latest […]

Read more

Monitoring the health of PostgreSQL

2020-03-10
blank

If you compare the database administrator to a warrior, his sword is undoubtedly the system shell, while the – monitoring system as well as knowledge and experience related to recording database parameters. In this article I will explain how to determine the condition of the database using parameters that the PostgreSQL engine itself presents to […]

Read more

Easier working with PostgreSQL – part III. database connection monitor

2020-01-21
blank

In this installment of the series about useful tools for working with PostgreSQL, we will discuss a tool that will certainly appeal to database administrators – about the interactive activity monitor of the pg_activity server. Database administration requires checking from time to time what is happening in a given system at a given moment. Of […]

Read more

Easier working with PostgreSQL – part II. pgcli

2019-11-26
blank

In this article we will introduce an interesting alternative for psqlwhich can significantly improve the work with the database. Pgcli is a database terminal interface focused on facilitating interaction with the text environment and with greater capabilities than a standard tool. At the beginning it is worth asking yourself – „what I miss in psql”? In my […]

Read more

Easier working with PostgreSQL – part I. pager for psql

2019-09-27
blank

This month we are starting a new series of articles on interesting and not always known tools that can significantly facilitate work with databases based on the PostgreSQL engine. In this article, we’ll look at the pager dedicated to use with psql. We will also show why working with a less database may not be […]

Read more