169 karma · joined September 7, 2023
I guess I'm thinking about this problem from the perspective of these GPT models requiring more training data than a normal person can acquire. Currently, it seems you need the entire internet worth of training data (and a lot of money) to get something that can communicate reasonably well. But most people can communicate reasonably well, so it would be cool if that basic communication knowledge could be somehow used to accelerate training and minimize the reliance on training data.
I'm going to look at an outer join FAR more critically, regardless of who wrote it, because it's easy to mess up the conditions.
Can you talk more about this? I'm working in this space now, but not from the "make an LLM give you the right query" perspective, but from the "make the LLM-produced query be safe" perspective[1]
1. https://docs.heimdallm.ai/en/main/blog/posts/safe-sql-execut...
SELECT user.user_id
FROM users
RIGHT JOIN purchases
ON purchases.user_id = user.user_id
AND user.user_id=123
By leaving the user_id=123 constraint in the JOIN instead of putting it in the WHERE, you've just exposed everyone's purchase data to the user. Easy to miss too if your tests don't fully create fixtures for multiple users. This becomes even more dangerous as we're entering the world of LLMs generating SQL[1]1. https://docs.heimdallm.ai/en/main/attack-surface/sql.html#ou...
Only advice would be: don't follow these fads unless you a) are doing it to learn or b) can quantify tangible business value in the change. The worst reason to do it is because everyone else seems to be doing it*
*Unless literally everyone is doing it and the "old" thing becomes unsupported.
Base64 is 6-bits, so there is no mapping of a single character to another single character. Changing 1 character in the input can change 1 or 2 characters in the output because each of the 6-bit "characters" are up against each other. So there is no mapping of input character to output character(s), it depends on context.
I'm aware that regular NL translations are a similar problem, but with base64, it's a much more exact and unforgiving problem, and GPT-4 seems to perform at a very high level.
https://chat.openai.com/share/02d616c2-5667-454d-9b72-43dfb1...
https://chat.openai.com/share/417169ed-8256-46cb-a3ed-81ab06...
Police were given a tip. They talked to the women, who then admitted to coordinating the crime over chat. A warrant was issued. No 4th amendment was violated.
1. https://www.theverge.com/2022/8/10/23299502/facebook-chat-me...
Businesses are not your friend
They're still competing for the attention of men they don't desire.
Just yesterday, I asked if Typescript has the concept of a "late" type, similar to Dart, because I didn't want to annotate a type with "| null" when I knew it would be bound before it was used. Searching for info would have taken me much longer than asking the LLM, and the LLM was able to frame the answer from a Dart perspective.
I would say that that information neither "important to digest" nor "readily available."