←back to thread

Getting AI to write good SQL

(cloud.google.com)
478 points richards | 3 comments | 16 May 25 21:10 UTC | HN request time: 0s | source
Show context
nashashmi ◴[16 May 25 22:31 UTC] No.44010349[source]▶
AI text to regex solutions would be incredibly handy.
replies(4): >>44010706 #>>44011846 #>>44012981 #>>44015104 #
RadiozRadioz ◴[16 May 25 23:28 UTC] No.44010706[source]▶
This comment appears frequently and always surprises me. Do people just... not know regex? It seems so foreign to me.

It's not like it's some obscure thing, it's absolutely ubiquitous.

Relatively speaking it's not very complicated, it's widely documented, has vast learning resources, and has some of the best ROI of any DSL. It's funny to joke that it looks like line noise, but really, there is not a lot to learn to understand 90% of the expressions people actually write.

It takes far longer to tell an AI what you want than to write a regex yourself.

replies(12): >>44010769 #>>44010791 #>>44010803 #>>44010854 #>>44010941 #>>44011236 #>>44011532 #>>44011584 #>>44011591 #>>44012097 #>>44012483 #>>44013224 #
1. fooker ◴[17 May 25 02:29 UTC] No.44011591[source]▶
Regex, especially non standard (and non regular) extensions can be pretty tricky to grok.

http://alf.nu/RegexGolf?world=regex&level=r00

replies(1): >>44013047 #
2. RadiozRadioz ◴[17 May 25 09:07 UTC] No.44013047[source]▶
/foo/

took me 25.75 seconds, including learning how the website worked. I actually solved it in ~15 seconds, but I hadn't realized I got the correct answer becuase it was far too simple.

This website is much better https://regexcrossword.com/challenges/experienced/puzzles/e9...

replies(1): >>44017836 #
3. fooker ◴[17 May 25 23:42 UTC] No.44017836[source]▶
Great, except you misunderstood the problem and wrote the exact opposite solution here.

Also this is the easiest starter puzzle, once you solve it you can click through to the next ones with increasing difficulty.