Is SQL a Proper Programming Language?

SQL is the language of relational databases, but is it a proper programming language?

My popular courses:

My business courses:

My social links:

Thanks!

Stef

#sql #programming

[ProgrammingwithPeter]

By definition it is a language, can't argue the facts, doesn't matter how it looks!

[leonf.]

When I first started out, I was processing data with PHP. Then I heard that I should learn SQL properly and wow, it made a world of difference. SQL is so powerful, you can get exactly what you need without any other processing.

[leonbrown]

If you want to create controversy, you should do a video asking if CSS is a programming language. ;)

[sethfeingold]

“Visiting another universe for a moment...” 😂

[murigig]

Well, Is Ruby a programming language?😂😂✌️

[sabyasachimitra]

If you don't put the Business logic in Stored Procedure you end up using database like a file system. Fetching data row by row and process which is extremely slow.

[RameenFallschirmjager]

Spoiler Alert: At 1:12 Stefan has a senior moment!

[cawsha]

This is a topic I am particularly interested in so thanks Stef for your views on this. I could expand on what you have said but would end up with the longest comment in YouTube history.


I agree it is a programming language (not just a language) as it can include logic but needs to be classified as a special-purpose language. If you look up most programming languages on Wikipedia they are described as general-purpose even though most are used for a fairly limited range of application types in practice.


(Is that a US flag on your shirt?)

[SMC]

A large nested stored procedure can lead to massive latency when lots more data is added, is the best way to fix that to de-normalize the SQL?

[brianmoore]

At 3:30, meddling humans transported back to mother ship.

[themoneymaker]

If the business logic is not in the SQL layer then u return a bunch of rows u dont need into the next layers. I see SQL code and then the App code. Where do u recommend the business logic go? Maybe I do t understand business logic term can u give an example of biz logic that we don't want in SQL stored proc?

[kodaidev]

Hi Stef,
Would you kindly talk about the differences between sql and non-sql databases, especially when to use each type (what scenarios)?

[daudaabdulrazaq]

Please I heard of this new web language "webassembly" having potential of providing better features than JavaScript in web scripting, but please if this is going to be will it only compete with JavaScript or kill JavaScript

[magfal]

Put PostgREST on Postgres and try to tell me that it's not a real language.

I've yet to stumble on a problem that can't be solved in SQL.
Business logic in SQL is by far a better alternative than using ORMs.

[АлександарВељковић]

"Visiting another universe for a moment." Laughed so hard on this, you Sir made my day.

[dalewarner]

I'd say that pl sql or tsql would be programming languages if I was a nerd 🤓.
One pro of not using proprietary Db Sql is if you want freedom so depending on the app and market it may be a valid reason to want to use 'ansi' sql and support any Db with a single code base.

[waynezor]

Maybe it could be described as a non-Turing complete declarative programming language?

[pixelmartyr]

When it comes to database design. It seems there isn't much out there.

[trajcevskifilip]

Okay so first of all, by definition SQL is not a programming language, it is database management language for relational databases. However you can write in PL SQL which is Procedural Language, which actually is programming language, but outdated (it's not object oriented).

PL SQL as much as i know is available in Oracle only (i may be wrong, but this was the case in the old days). Writing code in PL SQL has advantages but also disadvantages. Advantages: faster updates and searches in the database, traffic trough a local network is reduced, Disadvantages: very hard to maintain, no debugger, the database server needs to be much more powerful in order to get faster update/insert speeds, it will extremely complicate the architecture of the application.

The transfer between the server (the Java code) and the database was never done trough the Internet (it is possible to do so, but it is very bad idea with a lot of cons and no pros).

[mkusanagi]

var Material PreviousVideo
var struct CommandLet


simulated function PostBeginPlay()
PostBeginPlay!=PreviousVideo
{
Should you Learn C++ in 2018?
1, 207, 920 views•Nov 13, 2017
}
//==
function CommandLet P, (before Fire, After Fire)
{
if; LeavingBattleFieldVolume can be extended to field using Touch,
then; Message can be attached to FireBone of FiringSequence;
}