This example will just be focusing on returning data from user defined functions, specifically returning a value as opposed to using OUT parameters. The full code is on Github. To...
The world loves Postgres. If you work with developers, data scientists or anyone wrangling data or you are one of them, you probably are already working on Postgres and know...
Increasing robustness of Full Text Search in PostgreSQL allows applications like Search Engines and Text Editing Software to utilize native support without the need for 3rd party search tools. The...
In today’s world, organizations increasingly face an unprecedented level of threat of cyberattacks against their information assets. Cyberattacks can come in many forms. One such attack is called SQL injection...
Ensuring high availability for our clients’ PostgreSQL databases is our primary business objective. We are able to achieve that by ensuring availability of our PostgreSQL experts round the clock and...
One method to handle input parameters with PL/Julia is to rewrite the body of the user defined function or stored procedure on the fly with the values declared as global...
In the previous blog post, we discussed the different Windows build variants that PostgreSQL supports. In this post, we’ll discuss how, as a Unix-based developer, you can check whether your...
Just as last year was ending, one of our long-time customers came to us because one of their long-existing PostgreSQL queries involving PostGIS geometry calculations was much slower for specific...
Tomas Vondra, PostgreSQL Database Engineer at 2ndQuadrant, presented a webinar on CREATE STATISTICS command in PostgreSQL. The command was initially introduced in PostgreSQL 10 and saw further improvements in PostgreSQL...
This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In this article, we’ll use examples of Animals to predict whether they are Mammals, Birds...
