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)