Worried that your query will run forever and overwhelm your DB or make your app or API incredibly slow? Then learn how to add timeouts to PostgreSQL queries.
Tag: postgresql
The Powerful LATERAL JOIN in PostgreSQL
Understand the benefits of and learn how to use the lateral join feature of PostgreSQL (introduced in version 9.3), with the help of an example.
Backup your PostgreSQL table to Azure blob storage
Learn how to take backup a PostgreSQL table in the Azure blob storage as a CSV, using a simple Python function and the azure-storage-blob package.
Using psycopg2 in Azure Functions
If you have tried using psycopg2 with Azure functions, you would have realized that it doesn’t work. This post explains why, and provides a solution.