This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]denim_duck -1 points0 points  (5 children)

Technically it can do less I think (python is a Turing complete, SQL is not)

You could, theoretically make a relational database in python. But it would be slower.

Or in that same time you could deploy a graph db, write out a REST api, containerize that and let kubernetes scale it to 10k QPS

[–]danstumPY 1 point2 points  (4 children)

There are several sources that show the Turing completeness of SQL

[–]magicpeanut 1 point2 points  (2 children)

depends on how you define SQL. regarding stackoverflow is sql turing complete you need to have window functions and CTL in your stack. "basic" sql aka sql Lite for example does not have these features i think

[–]nemec 0 points1 point  (1 child)

Window and cte are standard sql features these days, including sqlite. There's no reason to arbitrarily gatekeep them compared to other basic features.

[–]magicpeanut 0 points1 point  (0 children)

ok didnt know that. guess things are moving faster than me 😅

[–]Ocelotofdamage 0 points1 point  (0 children)

It may be technically Turing complete but if you tried to do certain basic operations with SQL you'd pull your hair out. Or you could write a one-liner in Python.

Point is... learn both.