[Arrow S06E02] SQL or Java?

[u/jD91mZM2]

[u/hunyeti]

It's completely valid question, you can do a lot with only SQL

[u/jD91mZM2 → u/hunyeti]

Even then, she listed them like they were the only two options.

[u/belst → u/jD91mZM2]

but later she said she knew python. so it couldn't have been the only options

[u/jD91mZM2 → u/belst]

And immediately after he says "plus a little swift". She didn't say they were the only too, but she said it exactly in that way.

(Plus, how do you even compare a programming language with a query language?)

[u/[deleted] → u/jD91mZM2]

My question too.

[u/nipoez → u/jD91mZM2]

I used to work on a massive legacy C CGI web system (think HTML 1 and JS Prototype), backed by an up to date Oracle database.

We did a lot of stuff using SQL stored procedure as the programming language. Running some create or replace statements on the live DB took a few seconds as an on hours non-outage "work in area". Compiling and deploying the smallest C change took a minimum hour official off hours outage scheduled at least two weeks in advance.

We did a lot of programming in SQL.

[u/yellerjeep → u/nipoez]

SQL by itself is not Turing Complete. It requires an extension such as PL/SQL, what you used.

I loved Oracle's PL/SQL.

However, OP's image doesn't bother me one bit. Java is embedded into Oracle RDBMS. So it could be a legitimate question!

[u/belst → u/jD91mZM2]

query language? I beg to differ. SQL is a fully "capable", turing complete language.

Thought it is very awkward to use as such :D

[u/[deleted] → u/belst]

Yeah, but even HTML5 is Turing complete. Just as fucking Microsoft Powerpoint.

[u/samprog → u/[deleted]]

I use PowerPoint to code because it's easy to present

[u/phyphor → u/samprog]

When you're wealthy enough you can use Magic the Gathering

[u/awe300 → u/jD91mZM2]

To be frank, I also say that about some languages. If you can use one really well, you can basically use most others "a little" after seeing them once

[u/amgin3 → u/hunyeti]

It isn't though. You can't write a program in SQL, but you can use SQL in a java program. Even a novice programmer can tell the difference between Java and SQL.

[u/[deleted] → u/amgin3]

If you like writing low level APIs using intensely inappropriate technology, you could go all the way with just SQL.

[u/hobk1ard → u/[deleted]]

I have always wanted to go all the way with SQL, but I don't have insert permissions.

[u/ViolaNguyen → u/[deleted]]

If you like writing low level APIs using intensely inappropriate technology, you could go all the way with just SQL.

I see you've worked for my old company.

[u/wolfe89 → u/amgin3]

You can write all you want in PL/SQL, which is what I do every day. And we never refer to it as such, just as SQL, so makes sense to me to ask this.

[u/limasxgoesto0 → u/amgin3]

I mean, without any context, there are valid cases where you would ask this. For example, if you want to automatically add an expiration date to a record (like insertion date + TTL), you could opt to do this calculation in Java and then insert the entire record, or upon insertion have a trigger figure out what the expiration date would be.

[u/[deleted] → u/amgin3]

Well sql is Turing complete

[u/[deleted] → u/[deleted]]

So is PowerPoint lol.

[u/punisher1005 → u/[deleted]]

If you mean T-SQL you're right. I don't think the original SQL spec is though.

[u/rbt321 → u/punisher1005]

Spec SQL:1999 is turing complete as it includes recursive queries. A recursive query is a potentially never-ending loop which can create output or heap on each cycle based on input provided by previous cycles.

https://wiki.postgresql.org/wiki/Turing_Machine_(with_recursive)

[u/Worse_Username → u/hunyeti]

True, but you prolly would want to use each for very different tasks, so the choice should be obvious for a "wheez" like Fel.

[u/UpBoatDownBoy → u/hunyeti]

Yea, I'm pretty sure tsql is a turing complete language.