SQL is a cancer.

Reply to this note

Please Login to reply.

Discussion

I don't know a better way to select a thing from a thing tho!

Lol why do you say that?

It's unnecessary with today's compute unless you need to scale to millions and even then...

Also because their are a billion implementations all with their own way of handling auth and what drivers they use.

Saying SQL is unnecessary ignores the fact that structurestructured data exists and the benefits gained from structuring certain data. Not sure how "Today's compute" matters or plays into this.

I agree with the auth and drivers. SQL alchemy helps a lot when using Python.

The compute matters because of the data I need can be returned in nearly the same about of time from a document suite or even raw files then SQL is unnecessary complex. The former example is true for most small applications. More compute in every day machine means less need for optimizing data alaysis. SQL is still needed obviously for big scale or complex data alaysis of a large data set.

Are you saying you prefer to do joins across CSVs without SQL? Is this the new version of "excel as a database" and I will make money cleaning this type of thing up in 5 year?

CSV and SQL are not the only ways to store data. Raw json files, document stores, memory stores.

Json cannot do append. Memory should be cache, not store.

Yes of course.

ORMs still fix this pretty well in many language cathedrals in my experience. I find people who often complain about SQL haven't learned ORMs.

Well yeah.

Especially considering Oracle was created for the CIA, and the whole Oracle system likely has back doors for the 3 letters to collect data.

Oracle CIA Origins:

Oracle was not created as a CIA project, but the company's origins are closely tied to a CIA-funded database project. Larry Ellison, one of Oracle's founders, worked on a CIA-funded project codenamed Oracle in the late 1970s while at Ampex.

This project laid the groundwork for the company's database technology. The CIA became Oracle's first customer after the company was founded in 1977.

Dang it’s all I use to persist, am I going to be okay?

SQL is fine

I smoke 5 packs a day

SQL is beautiful. Objects are the problem

One of the longer running db languages? You’ll have to explain a little.

Why do databases need a language? They need an API, not a language that has to be parsed.

"its not a tumour"

Give https://postgrest.org a try.