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.
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.
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.
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.