Database script for creating readonly user in PostgreSQL

In this short blog post we will connect DBeaver to Google Cloud SQL (PostgreSQL) in two ( and a half ) different ways. First we will look at the recommended way of using the local Cloud SQL Proxy and secondly we will look at how-to hook up DBeaver directly to Cloud SQL using a secure connection.

PostgreSQL 12 comes with a great new feature, Generated Columns. A Generated Column is a special column in a table that contains data automatically generated from other data within the row. The content of the generated column is automatically populated and updated whenever the source data, such as any other columns in the row, are changed them

In Depth series of posts on managing PostgreSQL in different cloud vendors AWS, Digital Ocean, GCP, Azure

Benchmark comparison of AWS Aurora, AWS RDS, Google Cloud Platform (Cloud SQL), Microsoft Azure PostgreSQL

In MySQL or MariaDB we have generic, well performing solution like InnoDB, which works fine in majority of the cases, but we also have separate functions to work with JSON data, separate spatial indexes to speed up querying geometric data or fulltext indexes, helping with text data. In this blog, we will take a look at how MariaDB can be used to work with full text data.

Considering the current major use-case of a database as to retrieve data, it becomes very important that its performance is very high and It can only be achieved if data is fetched in the most efficient possible way from storage. There have been many successful inventions and implementations done to achieve the same. One of the well known approaches adopted by most databases is to have an index on the table.

When working with OLTP (OnLine Transaction Processing) databases, query performance is paramount as it directly impacts the user experience. Slow queries mean that the application feels unresponsive and slow and this results in bad conversion rates, unhappy users, and all sets of problems.

As you may know, Microsoft SQL Server is very popular RDBMS with highly restrictive licencing and high cost of ownership if the database is of significant size, or is used by a significant number of clients. It provides a very user-friendly interface and easy to learn. This has resulted in a large installed user base. PostgreSQL is the world's most advanced open source database. The PostgreSQL community is very strong and continuously improving existing features and implementing new features. A

Using open source software is the very first step to lower down the database infrastructure cost. Almost every commercial software available in the market has an equivalent of it in the open-source world. The most flexible and cost-effective way to optimize your database strategy is to use the right tool for the right job.