4 ms·
That's not really how the prompts work. Or how chat gpt works... There's not a clear seperation between the instructions or input, they're all mathmatically mun
by grogenaut 4y ago
That's not really how the prompts work. Or how chat gpt works... There's not a clear seperation between the instructions or input, they're all mathmatically munged together in the first layer or 3 (depending on how you define layers). Whereas sql injection can be avoided by an explict code path, and usually happens because people use the legacy api. Really they could/should change the sql spec to just require ? for all values and sql would hever have thi poissibility. But that's not how the neural net works.
- layer8 4y ago> That's not really how the prompts work. Or how chat gpt works... There's not a clear seperation between the instructions or input In examples like "Translate the following text between braces to French: {<some text>}", ChatGPT can clearly seperate between the two. For the present use case, you could simply strip any braces from the LinkedIn profile, so no need to worry about escaping. > Really they could/should change the sql spec to just require ? for all values Nope, because SQL query plans are generated and cached for the non-? (non-variable) parts, hence you need/want the ability to specify constants, since some query plan optimizations are based on that. You want to distinguish between which values are variable vs. constant in your application.
- grogenaut 4y agoI do believe, for the former, because that's how they trained it. For the latter if they did so they'd fix sql injection forever, and query plan optimizations also are often better with prepared statements