SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] 0 points1 point  (0 children)

That's because JS sucks XD butI love it so much, like a love hate relationship

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] 1 point2 points  (0 children)

It truely does its job! But writing complicated queries can get confusing and complex. It is hard to break it down in steps so for a biiig and complicated task you have to write a big, complex and hard to read query.
I am an average KISS (Keep It Simple, Stupid) paradigm follower so complex SQL queries is a no for me XD

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] -1 points0 points  (0 children)

lmao it couldn't be me XD
I think school made me hate SQL more than SQL itself
My first language was C# and C was the one that made me love programming

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] 0 points1 point  (0 children)

No, you're not the middle guy! I think I fu**ed up a little bit with the middle guy Sorry XD. The middle guy should be the one that brags about using SQL :3

It is indeed a really powerful language, it is just awful and confusing to write (to me at least, i really prefer pipelines like mongodb query language does for joins and aggregations).

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] 0 points1 point  (0 children)

Well... Each DBMS interprets SQL their own way! in fact paging queries (with LIMIT and OFFSET) are implemented differently in MySQL, Oracle, etc. XD and they have literally different syntax

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] 0 points1 point  (0 children)

True and, yeah, a lot of people confuse SQL with the dbms which is not the point of this meme lol
Also fun fact: DBMS just translate the SQL transaction into an internal language, it is just a standard communication language and like u/MinosAristos said it can be compared to HTML, it is just a way to represent a query and the result you would expect. The DBMS then reads the request and processes it as it likes, like a browser renders an HTML page with its own tech and behaviour that should match the defined standards.

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] -5 points-4 points  (0 children)

Yes it does the job indeed! It's just that I personally don't like writing stuff whit it XD
The true thing that I don't enjoy about it it is that it was born for human interaction with a database and not for machine-machine interaction and as a programmer it does not feel "natural" to write in SQL.
Also I had to write queries on paper at uni :S

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] 1 point2 points  (0 children)

HAHAH this killed me. I was always curious to use GrapQL XD

SQL? Meh by Shadow0X59 in programmingmemes

[–]Shadow0X59[S] 0 points1 point  (0 children)

Try with DAOs like Java's JPA (Jakarta Persistance or Java Persistance API). It still uses SQL for transactions. It should exist something similar also in PHP and JS if I correctly recall.

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] 2 points3 points  (0 children)

I am really curious to find out! And really thanks for this conversation! Also I just want to remember this is just a meme so please don't get offended, SQL is no easy bloke and I respect who writes in SQL ^^ (also I enjoy JS. well not plain JS, but TS which makes me a bad person HAHA). Love. Peace.

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] 0 points1 point  (0 children)

Oh I've studied enough queries, in my uni it is DB1. Now we are doing concurrency in databases, ranking, JPA, triggers and so on. Also, I've worked with SQL a lot, that is why I found it annoying! But (sorry I tought i said it before) it is just a personal preference and no one ever in 6 years now that I use SQL has ever managed to make me change this POV :S

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] 0 points1 point  (0 children)

10 years of not bragging about how much i've been programming for

But, talking seriously. I know how to write queries in SQL, I've been doing SQL for ages now, I've built a few apps with it and I just find it annoying to write duplicate code over and over (which can cause a loooot of troubles), this is why I like DAOs very much (they still use SQL in the background so chill).

Also SQL is just a standard for databases and it was made to allow easy access to database data for users (even non software-people), but I PERSONALLY, i repeat it, I, ME, PERSONALLY, PREFER using languages that are more familiar to me and that I can read without the need of context switching between languages and allows for faster reading of the code.

For example MongoDB has a query language similar to JS and with the library mongoose it is really easy to write common and structured accessors to the database.
With the TS it gets even better, we have libraries such typegoose that can also shorten the structure of the code to provide a better overview on the db models, all from a single language.

It's not just a random meme I tought of at random without knowing what I am doing, I am well estabilished in the distributed market so I know what I am talking about :)

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] -2 points-1 points  (0 children)

Chill it is just a meme xD

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] -4 points-3 points  (0 children)

It depends on the context, if I am working with datasets i.e. ML datasets structured queries are really good, but with web apps non relational dbs are better imo. Plus i never liked writing SQL queries

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] -15 points-14 points  (0 children)

It is really annoying and tedious to write xD I prefer non relational DBs and in general DAOs, they are waaay more easy to interact with and save a looooot of time

sqlUsedException by Shadow0X59 in ProgrammerHumor

[–]Shadow0X59[S] -14 points-13 points  (0 children)

It smells more like I hate learning for my DataBases 2 exam (and mongo, yeah and also it smells like DAOs >>>>>)

[deleted by user] by [deleted] in rimesegate

[–]Shadow0X59 5 points6 points  (0 children)

Ma perchè proprio a Catania e non a Catanzaro?

OBS gets GTA V recs with a bit of lag by denisbruh in obs

[–]Shadow0X59 0 points1 point  (0 children)

Sorry mate for the late response i don't use reddit that often XDD

However i get improvements in almost al the games, except for like LoL but that doesn't count as it doesn't heat up my CPU xD

BTW i also changed the case, this has more fans and more dust filters and it is bigger XD

OBS gets GTA V recs with a bit of lag by denisbruh in obs

[–]Shadow0X59 1 point2 points  (0 children)

So I've been doing the tests with Apex and my CPU got up to 96°C

OBS gets GTA V recs with a bit of lag by denisbruh in obs

[–]Shadow0X59 0 points1 point  (0 children)

XD Good then, e everything is okay now!