this post was submitted on 19 Oct 2023
1765 points (98.8% liked)
Programmer Humor
32425 readers
537 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Why not? It sounds like you haven't written any OLAP queries :)
I've written ETL data pipelines using a system similar to Apache Airflow, where most of the logic is in SQL (either Presto or Apache Spark) with small pieces of Python to glue things together. Queries that are thousands of lines long that take ~30 minutes to run and do all sorts of transformations to the data. They run once per day, overnight. I'd definitely call that programming.
Most database systems support stored procedures, which are just like functions - you give them some input and they give you some output and/or perform some side effects.
Oh yea!!! Well I have 76 lines of code that takes up to 18 hours to run for 1 client!!!!!
/s
Haha I only mentioned the run time to provide some context, since a lot of people have only ran OLTP queries that take less than a few seconds to run.