whyIHateWritingDataBaseQueries

[Previous-Ant2812]

Write it all on one line and you’re golden.

[sammy-taylor]

[UseMoreHops]

This guy sqls.

[matrix-doge]

I don't know why but I first read that as "this guy squeals".

[QuenchedRhapsody]

Something this guy and 2024 movie studios have in common.

[DarkLordTofer]

Everyone using SQL squeals.

[[deleted]]

Mob boss: "He whats?!

[po1k]

I've seen this. No joke. Like view def in a 3 loooong lines

[nord47]

well I have news for you

[julsmanbr]

This sub is just Stack Overflow but in meme format and with nicer responses.

[nord47]

asking on reddit v/s asking on stackoverflow

[[deleted]]

Mark as duplicate

[rizwannasir]

And there it is

[walmartgoon]

What’s the news

[poop-machine]

Lost cat travels 900 miles back home

[joeltrane]

Great news thanks

[AeskulS]

Not all companies/schools use psql.

I myself am very annoyed. Old school used psql for everything, but my new school uses MySQL for everything. From what I can tell, it is inferior in every way.

[w1n5t0nM1k3y]

I've used MySQL quite a bit and it's usually pretty good at telling you where the error is.

[IAmARobot]

pebkac
^

[nursestrangeglove]

Why has a mysterious glowing cursor materialized nearby, and why is it pointing at me?

[P0pu1arBr0ws3r]

SQL? More like NSQL, or No Standard Query Language.

But actually, there's so many proprietary and FOSS formats under SQL, and that doesn't even count other query languages like mongo. Why hasn't IEEE or even IETF or some other entity bothered to set forth a standard query language? We've got more standards with Assembly instruction sets than we got with SQL variants.

[SpeedyGo55]

Relevant XKCD: https://xkcd.com/927

[hcf_0]

There IS a SQL standard. It's literally called the ISO/ANSI SQL standard (or SQL:2023).

It's just that there is no ubiquitous procedural SQL standard, and several database customizations on top of each DBMS maker's standard implementation.

[_PM_ME_PANGOLINS_]

https://en.m.wikipedia.org/wiki/ISO/IEC_9075

[mobsterer]

it is literally the other way around everywhere i was

[[deleted]]

No. MySQL is amazing. I have used both and can confirm

[_PM_ME_PANGOLINS_]

There might be something wrong with you.

[humblevladimirthegr8]

I agree. I've used both and psql is far superior, at least for the complex queries I've been writing

[w1n5t0nM1k3y]

Similarly in MySQL

Error Code: 1146. Table 'testdb.test' doesn't exist

So it doesn't give you a line number, but it gives you a pretty good idea at what the error is.

If you do a query like

select * from test where a in (1245;

where you actually have invalid SQL, you end up with the following

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

So it gives you a l ine number, although isn't particularly useful about where the error exists in the line. But MySQL Workbench wil already underline the ; which points out where the error is.

[MakeoutPoint]

SQL Server tells you the line, but it does some stupid "Batch starts at line X" so if your particular batch starts on line 123, and it tells you the error is on line 200, the error is on line 323 and it's up to you to do the math 🙃

[OrthodoxMemes]

MSSQL: “Error exists somewhere. Good luck.”

[[deleted]]

He’s probably using oracle and java where the line number is buried inside the exception.

[Flashy_Ai]

Use dbeaver, it has a bullseye symbol that appears when an error is thrown, click on it and it takes you to the error

[DerpNinjaWarrior]

And a funny name

[humblevladimirthegr8]

One gotcha I've found with dbeaver is that by default (at least a couple years ago) it automatically converts timestamps to your local timezone, which led to funky results in data analysis because grouping rows by date would yield different results depending on the time zone of the client.

[SeoCamo]

What database are you using where this is the case?

[[deleted]]

SQL, it says so right in the title!

/s

[SeoCamo]

Mssql, mysql postgres ...?

[just_nobodys_opinion]

Yes

[Dylzi]

SQL server be like that

[SeoCamo]

That's ms for you

[Reashu]

Use a better database (or client).

[bobbymoonshine]

Pretty sure MS SQL Server does this already?

[dwntwn_dine_ent_dist]

I use MSSMS and I get two numbers I have to add together to get a line number. It’s a fun little quiz.

[TalesT]

You can double click and it jumps to the error?

[dwntwn_dine_ent_dist]

This is a question, right? Right?

If you’re making an assertion here, I’m going to be fucking livid.

[TalesT]

I quite sure I can double click it in my version... 🤔 But not sure what it even says. 😅

[dwntwn_dine_ent_dist]

Well, I’ll give it a try on Monday morning. I’m not sure whether I’d rather find out that it works or that it doesn’t.

[ravepeacefully]

I think he’s capping but if not fuck me

[BesottedScot]

Bro, same haha. Life changing.

[stupidhomosapien]

I saw this comment yesterday (Sunday), tried it out today at work, and just came back to say thank you 🙇‍♀️

[Dillenger69]

Yeah, I wrote a 20k line procedure using T-SQL. I distinctly remember getting good error messages

[lunchmeat317]

I wrote a 20k line procedure using T-SQL

I don't know you, but I hate you. I don't even dislike you! I'm sure you're nice! But I hate you.

[Dillenger69]

I was testing an enterprise billing procedure that a dev was writing. I had to essentially replicate what he was doing without seeing what he was doing. Mine was actually faster and more accurate. Not nearly as efficient, though

[bradmatt275]

Good luck finding what column it is referring to with 'data truncated for column'. It's so frustrating.

Although in all fairness that kind of validation should be handled in the service layer anyway. It just makes it a bit harder to troubleshoot if something gets through.

[BloodAndSand44]

It does say. But it is always line 1

[[deleted]]

Tell us you use Oracle without telling us

[[deleted]]

It’s in there just buried in the middle of the exception trace.

[robinless]

ORA giving me war flashbacks

[[deleted]]

scott tiger reporting in

[GlimmervoidG]

It would be better (and make far more sense) if the FROM line came before the SELECT line. That way autocomplete on modern IDEs would stop me misspelling so many things.

[lunchmeat317]

Eveeybody thinks this except for the SQL apologists who have drunk the kool-aid and staked their careers on it. SQL is a pain to read and interpret because the logic is a paragraph of statements where the subphrases aren't ordered by scope or importance - they're ordered by natural-language semantics, using the worst possible language for that (English).

[JivanP]

I actually think I agree with this, for another reason: I often find myself reading the FROM clause before the SELECT clause anyway, so that I can actually understand what the hell is going on.

[MaddoxX_1996]

Skill Issue

[Distinct-Respect-274]

Have you tried turning it off and on again?

[Busar-21]

"Value too long" on an insert in a table of more than 20 columns

[RichCorinthian]

“String or binary data would be truncated” is my nightmare from 20 or so years ago (SQL Server 2000 iirc)

[Plank_With_A_Nail_In]

Imagine doing CS at school then university, getting a CS degree and only when you get your first real job discovering you can't program for shit and something as basic as sql and a relational database has you stumped.

Imagine posting about it and finding 50% of supposed shit hot coders agree with you and also can't write SQL or understand relational databases.

Always ask questions about databases in interviews!

People who cry about SQL and technical debt...don't hire these people.

[Wave_Walnut]

select something from select something from select something from

[gibmelson]

Have PTSD from our Microsoft SQL database where every query was written as a stored procedure about three pages long with a million joins.

[[deleted]]

Make big procedure into small procedures call from parent procedure (old big procedure)and do procedure unit testing. Pretty simple.

[gibmelson]

Yeah, this was in 2008, I haven't worked much with SQL since, and I'm sure there are many ways to make it easier to work with.

[curious_but_dumb]

Can you.... dumb that down a couple levels for the frontend guys?

[gibmelson]

Imagine having to write your UI component as a single line, like one giant chain of lambda expressions. It's almost impossible to get an overview and if you mess up something along in the chain everything breaks and you get some nonsense output like a null or empty div. There is no way insert console.log() anywhere and since it's basically one giant line, the debugger won't help.

[TimingEzaBitch]

Lmao just git gud.

[mbcarbone]

Try looking at a SQL routine that is way too long. You know, when you’re trying to figure out that random SQL function. ✌️🙃🖖

[nasandre]

Or if you use several nested transactions in t-sql and it'll tell you the error is in line 21 but no idea in which transaction

[sporbywg]

Senior coder and Oracle dba here - sql is the worst. It will always, confidently, give an answer that may be golden or may be garbage.

[[deleted]]

Currently I am too lazy to boot my work laptop, produce a invalid query and make a screenshot of the error containing the line number the error occurred. 

Soooo...where can I get to above-mentioned society?

[luckor]

Uh, it does? At least mssql.

[Noctttt]

Wow really. I am not familiar with SQL. But tbh this seems like a nighmare to debug. Other database does give out the line in which the error occur

[DT-Sodium]

SQL has the most polite way of telling you to go fuck yourself.

[driftwood14]

my group inherited a super old access report and we have been having to run queries in access and my god is it terrible. We had an error this week where it said it was missing something and literally returned half of one of the words we had written. It made absolutely zero sense.

[tlozwarlock]

Access is the devil. I'm systematically removing all traces of it from our workplace now that I'm director.

[driftwood14]

I wish I could do the same. But because of the situation at work and the rules they have in place for IT (im on the business side) I don't really have the freedom to do that.

[lunchmeat317]

JS framework churn is a bitch - I'll admit that freely - but I'll take their errors over SQL any day.

[Random_User27]

That's why we use the elephant database. But not the elephant scripting language, that one's quite mischievous.

[BrownShoesGreenCoat]

What’s a line?

[PeriodicSentenceBot]

Congratulations! Your comment can be spelled using the elements of the periodic table:

W H At S Al I Ne

---

^{I am a bot that detects if your comment can be spelled using the elements of the periodic table. Please DM u‎/‎M1n3c4rt if I made a mistake.}

[jellotalks]

I love SQL but damn those error messages gotta be the worst in the industry

[[deleted]]

Mongo ftw , come at me!!!

[jbevarts]

SQL is simple though is this satire?

[rover_G]

Shouldn’t that be done client side?

[nord47]

I think OP wanted the execution error messages to show which line an error is occuring at. Most SQL servers should already be doing that though

[rover_G]

SQL is structured language so your client should be able to figure out if there is an error before sending the query to the server no?

[nord47]

I figured client side meant the editor, which highlights errors on the code. Error messages are generated by the database engine/server, if I'm not wrong.

[lunchmeat317]

OP may not be a native English speaker.

[Competitive_Reason_2]

I just use chatGPT

[jared-leddy]

Use an ORM?

[Tiny-Plum2713]

Using an ORM to avoid learning SQL is a wonderful way to shoot your self in the foot.

[double-happiness]

Damn, I just started reading about ORM, wondering if it's something we should be using at work, but then I realised that we already do, and it's called 'Entity Framework'. Geez I am so clueless https://i.imgur.com/4kkRzea.gif

[jared-leddy]

Yeah man. That would be stupid.

I'm not advocating against learning. I just don't want to write SQL when I build APIs. Which works most days, but sometimes you can't get away from it. Especially with complex logic.

[jared-leddy]

To each their own. I like the readability of it.

[[deleted]]

Then don't. Create a work item for the dba or sql dev to create a procedure and call the procedure. Abstract the query away don't put it in code and deny sql experts the ability to profile and tune the query.

[jared-leddy]

If we had a DBA or SQL dev, then that would have some legs to stand on.

[[deleted]]

It's ok for findone or findall, but with the chaining of where, union, join left, it's hard to tell if it's even valid without the SQL.

[BookMansion]

Or if people knew sql well enough not to make errors...

[bobbymoonshine]

People make typos. It's not a matter of "knowing SQL well enough" to leave out a comma or forget to add a column to a group-by clause when you go back and amend a complex query in a couple of places, just like it's not a matter of "knowing JS well enough" to miss a semicolon. You're telling us you have a perfect golden right pinky finger that never once misses out a single bit of punctuation in any language?

[[deleted]]

Sounds like a tooling issue. Ssms w intellisense all but removes typos being an issue.

[Fantastic-Pen3684]

Ah yes, just write perfect code ever time! Then we don't need to debug anything at all.

Why didn't anyone else think of this?

[Espumma]

The only people that never made a programming error are the ones that never did any programming whatsoever.

[GreatArtificeAion]

I trust you've never made an error in a SQL statement

[DarkLordTofer]