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
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 moreIf 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 moreIn 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