[auspiv]

I have found ChatGPT to be incredibly useful as well. I don't do any fancy prompt engineering, just use plain English. Here are a few recent examples that spit out useful results.

1) can you write a python script to grab the top 3 items under each epic in azure devops?

2) postgres where clause where any item in a string array = 'GoogleApi.Entities.Places.Common.Photo'

3) here is a SQL row output of a single column. can you please extract the 30 as a new column?

P2, Site Inspection: Due 3 days ago (30-day freq.)

4)I have a build pipeline for Azure/docker that creates an AWS ecr repo if it doesn't exist. how can this specify that the images should be scanned upon creation?

      - task: CmdLine@2
        displayName: Create repo if it does not exist
        inputs:
          script: |            
            aws ecr describe-repositories --repository-names {env}-{project_name} || aws ecr create-repository --repository-name {env}-{project_name}

5) postgis query to get places sorted by distance from a lat/lon (say -104.01, 38.88). column is named location and has data like: POINT (-106.676354 39.526714)