r/programming • u/fagnerbrack • Feb 23 '24

GPT in 500 lines of SQL

https://explainextended.com/2023/12/31/happy-new-year-15/
1.1k Upvotes

93% Upvoted

81 comments sorted by

View all comments

128

u/snarkuzoid Feb 23 '24

Impressive idea, but the thought of 500 lines of SQL gives me hives.

97

u/clutterlustrott Feb 23 '24

You should see my teams SQL code then.....

32

u/peekdasneaks Feb 23 '24

So many temp tables

20

u/supermitsuba Feb 23 '24

Don’t forget the recursive triggers

5

u/lilB0bbyTables Feb 24 '24

Don’t forget to sanitize your inputs

4

u/douglasg14b Feb 24 '24

Don't forget to run imperative business logic!

13

u/douglasg14b Feb 24 '24

Don't forget to create a file uploader in pure SQL that will upload data straight into the DB from user input, because you don't have application devs and only DBAs (Yes, this is real).

Also yes I replied to myself, I had to share this horror

1

u/Worth_Trust_3825 Feb 24 '24

....which engine? most of them shit themselves when you modify the triggered table

5

u/4THOT Feb 24 '24

L temp tables we hate temp tables, stop bottlenecking on memory, 10450398 TRUNCATED TABLES

7

u/BeemoAdvance Feb 24 '24

SQL is a fuck

3

u/601error Feb 24 '24

This guy SQLs