| I have an example where I used the Phind model and GPT4 in a mix. The goal was to get multiple iterations of the same code, written in different ways that I could iterate on. I had this really annoying requirement to get multiple incompatible status codes, and output them in a consolidated human legible way. So pretend I am using MSSQL, and I have 3 status code tables. The status code integers are all slightly different. NEW is always 1, but "Completed" could be 5, 7 or 21 depending on table. The actual "text" is an integer that can be linked to a Text table via the ID and Language name. But, due to the nuances being slightly different, each version can have a different ID.
I can't just use DISTINCT on the text ids. This is even more true when slight differences like "Complete" and "Completed" exist. So I need to use UNION, to 'combine' multiple unrelated status code tables. Then I need to get the language text, and SELECT DISTINCT (or something similar) per language. Then that needs to be outputted as a drop down for the user. Then, I have to use that as a other, separate input for another SQL query. To say "using fast, slightly inaccurate GPT code" was faster than doing it by hand would be an understatement. It gave me about 15 iterations, where about 6 sort of worked. Then I figures it out myself from there. |