A PostgreSQL procedural language handler needs to look up the body of the user defined function or stored procedure for the code to execute. Remember that the C function executed...
2ndQuadrant’s training courses are very popular amongst PostgreSQL professionals and enthusiasts, and have hosted more than 500 trainees in the last 10 years. Our current Public and On-Site training options...
Julia provides an API so that Julia functions can be called from C. PL/Julia will use this C API to execute Julia code from its user defined functions and stored...
This is the second installment of a two-part series on 2ndQuadrant’s repmgr, an open-source high-availability tool for PostgreSQL. In the first part, we set up a three-node PostgreSQL 12 cluster...
With applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes...
PostgreSQL supports many procedural languages, which can be used to write user defined functions or stored procedures. There are four that are readily available as part of the standard PostgreSQL...
I am very excited to announce the first release of " Cloud Native BDR Operator" for Kubernetes. BDR Operator is the first 2ndQuadrant product to be launched in the Cloud...
This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In the article, we’ll use an example of Animals to predict whether they are mammals...
As a PostgreSQL developer, I occasionally need to make my code work on Windows. As I don’t normally use Windows and don’t have a permanent Windows installation around, this has...
Preamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL...
![Webinar: Application Schema Migration [Follow Up]](/sites/default/files/styles/blog_image/public/blog_posts_images/Application-Schema-Webinar-Social.png?h=ce5fe46c&itok=98jKDoft "Webinar: Application Schema Migration [Follow Up]")
